SAS/ACCESS LIBNAME statement

Program 3.3 Using the SAS/ACCESS LIBNAME Statement to Get Data from Oracle... 

PROC IMPORT and the Import Wizard 44 SAS DATA Step 52 SAS Enterprise Guide 53 Importing Microsoft Office Files 56 LIBNAME Statement 58 Import Wizard and PROC IMPORT 59 SAS/ACCESS SQL Pass-Through Facility 64 SAS Enterprise Guide 65 Importing XML 68... 

Some commonly used SAS tools for importing Microsoft Excel and Microsoft Access data into SAS include the LIBNAME statement, the Import Wizard/PROC IMPORT, the SQL Pass-Through Facility, and SAS Enterprise Guide. 

Beginning with SAS 9.1, the LIBNAME statement can be used to simply map to an Excel or Access database. This facility is available in the Microsoft Windows and UNIX operating systems. For example, the following SAS code reads in and then prints the lab normal file normal ranges.xls. 

Be aware that the LIBNAME statement approach allows for both reading and writing to and from Microsoft Office files, which means the contents of the Microsoft Office files can be changed by SAS. There are many libref options not covered here that provide further access control features to Microsoft Excel and Access files. See the SAS documentation on the LIBNAME statement for PC files for more details. 

---