Chapter 31
About SAS/ACCESS Software
Definition of SAS/ACCESS Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 703
Dynamic LIBNAME Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 704
SAS/ACCESS LIBNAME Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 704
Using Data Set Options with SAS/ACCESS Librefs . . . . . . . . . . . . . . . . . . . . . . . 704
Embedding a SAS/ACCESS LIBNAME Statement in a PROC SQL View . . . . . 704
SQL Procedure Pass-Through Facility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 705
ACCESS Procedure and Interface View Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . 706
DBLOAD Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 707
Interface DATA Step Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 708
Definition of SAS/ACCESS Software
SAS/ACCESS software
enables you to read and write data to and from other vendors' database management
systems (DBMS), as well as from some PC file formats. Depending on your DBMS,
a SAS/ACCESS product might provide one or more of the following:
• a dynamic LIBNAME engine
• the SQL pass-through facility
• the ACCESS procedure and interface view engine
• the DBLOAD procedure
• an interface DATA step engine
These interfaces are described in this section. Each SAS/ACCESS product provides
one or more of these interfaces for each supported DBMS. See Chapter 35, “SAS
Engines,” on page 739 for more information about SAS engines.
Note: To use the SAS/ACCESS features described in this section, you must license
SAS/ACCESS software. See the SAS/ACCESS documentation for your DBMS for
full documentation of the features described in this section.
703