The
following options can be used in the PROC ACCESS statement:
ACCDESC= libref.access-descriptor
identifies an access descriptor. Use this option to create a view descriptor from
an existing access descriptor.
If the access descriptor has been assigned a SAS password, you might need to specify
the password in the ACCDESC=
option in order to create a view descriptor based on the access descriptor. Whether
you specify the password depends on the level of protection that was assigned to the
access descriptor. For more information,
see Passwords for Descriptor Files.If you create the access descriptor and the view descriptor in the same execution
of PROC ACCESS, omit the ACCDESC= option because you specify
the access descriptor's name in the CREATE statement.
ACCESS= and AD= are
aliases.
DBMS= S2K
specifies that you
want to invoke the SAS/ACCESS interface to SYSTEM 2000. This option is required when creating a descriptor, but
is not required when extracting DBMS data.
OUT=libref.member
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 DBMS data. VIEWDESC= is used only with
the OUT= option.
VIEW= and VD= are aliases.