ACCESS Procedure Reference

Options for the ACCESS Procedure

The ACCESS procedure 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=ADABAS

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.

OUT=<libref.>member-name

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

Top of Page