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.

Restriction 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. For details, see the DBMS-specific information for your SAS/ACCESS interface.

OUT=libref.member-name

specifies the SAS data set in which DBMS data is stored.

VIEWDESC=libref.view-descriptor

specifies a view descriptor through which you extract the DBMS data.

Last updated: February 3, 2026