ACCESS Procedure Reference

ACCESS Procedure 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;

UNIQUE = YES|NO;

The PROC ACCESS Statement

PROC ACCESS <options>;

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.

For programs that use these options, see Example Programs.

Top of Page