Using PROC ACCESS Statement Options

PROC ACCESS Statement Options

PROC ACCESS options;

Depending on which options you use, the PROC ACCESS statement performs several tasks.

You use the PROC ACCESS statement with database-description statements and certain procedure statements to create descriptors or SAS data files from DBMS data.

The PROC ACCESS statement takes the following options:

ACCDESC=libref.access-descriptor

specifies an access descriptor. ACCDESC= is used with the DBMS= option to create a view descriptor that is based on the specified access descriptor. You specify the view descriptor's name in the CREATE statement. You can also use a SAS data set option on the ACCDESC= option to specify any passwords that have been assigned to the access descriptor.

The ACCDESC= option has two aliases: AD= and ACCESS=.

DBMS=Datacom

specifies the database management system that you want the descriptor(s) to access. Specify DBMS=Datacom since you are using the SAS/ACCESS interface to CA-Datacom/DB.

OUT=<libref.>member-name

specifies the SAS data file to which DBMS data is written. OUT= is used only with the VIEWDESC= option.

VIEWDESC=<libref.>view-descriptor

specifies a view descriptor that accesses the CA-Datacom/DB data. VIEWDESC= is used only with the OUT= option.

For example:

proc access dbms=Datacom viewdesc=vlib.invq4 out=dlib.invq4;
run;

The VIEWDESC= option has two aliases: VD= and VIEW=.

Options

The ACCESS procedure statement takes the following options: