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:
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 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=.