ACCESS Procedure

PROC ACCESS Statement

Accesses relational DBMS data

Syntax

PROC ACCESS <options>;

Optional Arguments

ACCDESC=libref.access-descriptor
specifies an access descriptor. ACCDESC= is used with the DBMS= option to create or update a view descriptor that is based on the specified access descriptor. You can use a SAS data set option on the ACCDESC= option to specify any passwords that have been assigned to the access descriptor.
Note: The ODBC interface does not support this option.
DBMS=database-management-system
specifies which database management system you want to use. This DBMS-specific option is required. See SAS/ACCESS documentation for your DBMS.
OUT=libref.member-name
specifies the SAS data file to which DBMS data is output.
VIEWDESC=libref.view-descriptor
specifies a view descriptor through which you extract the DBMS data.