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:
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=.
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.
specifies the SAS data
file to which DBMS data is written. OUT= is used only with the VIEWDESC=
specifies a view descriptor
that accesses the CA-Datacom/DB data. VIEWDESC= is used only with the OUT= option.
proc access dbms=Datacom viewdesc=vlib.invq4 out=dlib.invq4;
The VIEWDESC= option
has two aliases: VD= and VIEW=.