—•Today is •—

This example shows how to use PROC ACCESS to read an existing Excel 5/95 file and create an Access descriptor, an Access view, and a SAS data set. The view and descriptor must be created, even if the ultimate goal is a SAS dataset.

This program creates an Access view, descriptor, and SAS data set from an EXCEL 5/95 file. 


  proc access dbms=xls;
    create work.houses.access;
    path='c:\Excel Files\test.xls';
    scantype=yes;
    getnames=yes;
    assign=yes;
    list all;
    create work.test.view;
    select all;
  run;

  data work.mydata;
    set work.test;
  run;

Print Document

Copyright © 2006 www.nycinformatics®.com All Rights Reserved
Last edited on: May 28, 2006
SAS product or service names are registered trademarks of SAS Institute, Inc. in the USA and other countries.
® indicates USA registration.