| 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.