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