ACCESS Procedure Reference

PROC ACCESS Statement Options

To create and edit access and view descriptor files, you must issue the PROC ACCESS statement with options and procedure statements. The statement has this format:

PROC ACCESS <options>;

required-procedure-statements;

optional-procedure-statements;

This section describes PROC ACCESS options. For information about the procedure statements, see Invoking the ACCESS Procedure.

Depending on which options you choose, the ACCESS procedure performs several tasks. To create and edit access and view descriptors, use the following options:

DBMS=IMS

specifies the name of the database management system that the access descriptor will access. Specify DBMS=IMS since you are using the SAS/ACCESS interface to IMS.

ACCDESC=libref.access-descriptor

specifies the name of 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 data set option on the ACCDESC= option to specify any passwords that have been assigned to the access descriptor. The access descriptor that you name must exist.

The ACCDESC= option has two aliases: AD= and ACCESS=.

The following options enable you to extract IMS data with a view descriptor:

VIEWDESC=<libref.>view-descriptor: specifies the name of the view descriptor from which to extract the IMS data.
OUT=<libref.>member-name: specifies the SAS data file to which DBMS data is written. OUT= is used only with the VIEWDESC= option.

Top of Page