SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

Syntax

PROC ACCESS <options>;

CREATE libref.member-name.ACCESS|VIEW;

DATABASE<=>database-name <S2KPW<=>password <MODE<=>SINGLE|MULTI>>;

ASSIGN<=>YES|NO;

BYKEY variable-identifier<=>YES|NO
<...variable-identifier-n<=>YES|NO>;

DROP variable-identifier
<...variable-identifier-n>;

FORMAT variable-identifier<=>SAS-format-name
<...variable-identifier-n<=>SAS-format-name-n>;

INFORMAT variable-identifier<=>SAS-informat-name
<...variable-identifier-n<=>SAS-informat-name-n>;

LENGTH variable-identifier<=>item-width
<...variable-identifier-n
<=>item-width-n>;

LIST <ALL|VIEW|variable-identifier>;

QUIT;

RENAME variable-identifier<=>SAS-variable-name
<...variable-identifier-n<=>SAS-variable-name-n>;

RESET ALL|variable-identifier <...variable-identifier-n>;

SELECT ALL|variable-identifier <...variable-identifier-n>;

SUBSET selection-criteria;

S2KPW<=>password <MODE <=>MULTI|SINGLE>;

UNIQUE<=>YES|NO;

PROC ACCESS Statement Options

The following options can be used with the PROC ACCESS statement.

ACCDESC= libref.access-descriptor

identifies an access descriptor. You use this option to create a view descriptor from an existing access descriptor.

If the access descriptor has been assigned a SAS password, you may 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 information on assigning and using passwords, see Specifying Passwords for SAS/ACCESS Descriptors.

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.

AD= and ACCESS= are aliases for this option.

DBMS= S2K

specifies that you want to invoke the SAS/ACCESS interface to SYSTEM 2000 software. This option is required when creating a descriptor, but not when extracting DBMS data.

OUT=libref.member

specifies the SAS data file to which DBMS data are written. The OUT= option 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 for this option.

See Example Data for examples of using options in procedure statements.

Chapter Contents
Previous
Next
Top of Page