Setting Up Your SAS Session |
Referencing Files in SAS Libraries |
Specifying Engines
To indicate which engine to use, you specify the engine name in the LIBNAME statement, as shown below. |
General form, LIBNAME statement for files in other
formats:
where
|
Interface Library Engines
Interface library engines support read-only access to BMDP, OSIRIS, and SPSS files. With these engines, the physical filename associated with a libref is an actual filename, not a SAS library. This is an exception to the rules concerning librefs. |
Engine | Description |
---|---|
BMDP | allows read-only access to BMDP files |
OSIRIS | allows read-only access to OSIRIS files |
SPSS | allows read-only access to SPSS files |
For example, the LIBNAME statement below specifies the libref
Rptdata and the engine SPSS for the file
G:\Myspss.dat in the Windows operating environment.
libname rptdata spss 'g:\myspss.dat'; For more information on interface library engines, see the SAS documentation for your operating environment. |
SAS/ACCESS Engines
If your site licenses SAS/ACCESS software, you can use the LIBNAME statement to access data that are stored in a DBMS file. The types of data you can access depend on your operating environment. |
ORACLE | ADABAS | Excel (.xls) |
SYBASE | IMS/DL-I | Lotus (.wkn) |
Informix | CA-IDMS | DBF |
DB2 for OS/390 | SYSTEM 2000 | DIF |
DB2 for UNIX and PC | ||
Oracle Rdb | ||
ODBC | ||
CA-OpenIngres |
For details, see the lesson Accessing Other Vendors' DBMS Data. |
Copyright © 2002 SAS Institute Inc.,
Cary, NC, USA. All rights reserved.