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.
See Invoking the ACCESS Procedure for information
about which procedure statements to use for each task.
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=.
specifies which database
management system you want to use. DBMS= can be used with the ACCDESC=
option to create a view descriptor, which is then named in the CREATE
statement.
specifies the SAS data
file to which DBMS data are written. OUT= is used only with the VIEWDESC=
option.
VIEWDESC=
<libref.>view-descriptor
specifies a view-descriptor
that accesses the ADABAS data. VIEWDESC= is used only with the OUT=
option. For example:
proc access dbms=adabas viewdesc=vlib.invq4 out=dlib.invq4;
run;
The VIEWDESC= option
has two aliases: VD= and VIEW=.
CAUTION:
Altering
a DBMS table can invalidate descriptors.
Altering
the format of a DBMS table that has descriptor files defined on it
might cause these descriptors to be out-of-date or no longer valid.
For example, if you add a column to a table and an existing access
descriptor is defined on that table, the access descriptor and any
view descriptors that are based on it do not show the new column.
You must re-create the descriptors to be able to show and select
the new column.