SAS 9.4 Language Reference, 6th Edition

Chapter 33

About SAS/ACCESS Software

Definition of SAS/ACCESS Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 709

Dynamic LIBNAME Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 710

SAS/ACCESS LIBNAME Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 710

Using Data Set Options with SAS/ACCESS Librefs . . . . . . . . . . . . . . . . . . . . . . . 710

Embedding a SAS/ACCESS LIBNAME Statement in a PROC SQL View . . . . . 710

SQL Procedure Pass-Through Facility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 711

ACCESS Procedure and Interface View Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . 712

DBLOAD Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 713

Interface DATA Step Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 714

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 37, “SAS

Engines,” on page 745 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.

709