Chapter Contents


SAS/ACCESS Software for Relational Databases: Reference

ACCESS Procedure Syntax

The statements for your DBMS may differ from those listed below. See your DBMS chapter for details.

PROC ACCESS<statement-options>;
Creating and Updating Statements

CREATE libref.member-name.ACCESS | VIEW <password-option>;
UPDATE libref.member-name.ACCESS | VIEW <password-option>;

Database Connection Statements

These statements are used to connect to your DBMS and they vary depending on which SAS/ACCESS interface you are using. See your DBMS chapter for details. Examples include USER=, PASSWORD=, and DATABASE=.

Table Statement

TABLE= <'>table-name<'>;

Editing Statements

ASSIGN <=>YES | NO | Y | N;
DROP <'>column-identifier-1<'> <...<'>column-identifier-n<'>>;
FORMAT <'>column-identifier-1<'> <=>SAS-format-name-1 <...<'>column-identifier-n<'> <=> SAS-format-name-n>;
LIST <ALL | VIEW |<'>column-identifier<'>>;
RENAME <'>column-identifier-1<'> <=> SAS-variable-name-1 <...<'>column-identifier-n<'> <=> SAS-variable-name-n>;
RESET ALL |<'>column-identifier-1<'> <...<'>column-identifier-n<'>>;
SELECT ALL |<'>column-identifier-1<'> <...<'>column-identifier-n<'>>;
SUBSET selection-criteria;
UNIQUE <=> YES | NO | Y | N;



You can use the ACCESS procedure to create and update access descriptors, view descriptors, and SAS data files. Descriptor files describe DBMS data so that you can read, update, or extract the DBMS data directly from within a SAS session or in a SAS program.

The following sections provide complete information on PROC ACCESS options and statements.

PROC ACCESS Statement Options

The ACCESS procedure statement takes the following sets of options:

PROC ACCESS <statement-options>;

Depending on which options you use, the ACCESS procedure statement performs several tasks. You use the PROC ACCESS statement with database connection statements and certain procedure statements to create and update descriptors or SAS data files from DBMS data. The following sections describe PROC ACCESS options in greater detail.


This section describes the options that you use to create and update access descriptors or to create and update a view descriptor.

See Options and Statements Required for the ACCESS Procedure for examples of options and statements. To invoke the ACCESS procedure, you use the options and certain procedure statements. The options and statements that you choose are determined by your task.

specifies an access descriptor.

ACCDESC= is used with the DBMS= option to create or update a view descriptor that is based on the specified access descriptor. You use a CREATE or UDPATE statement to name and create or update the view. 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=.

specifies which database management system you want to use. DBMS= can be used with the ACCDESC= option to create or update a view descriptor, which is then named in the CREATE or UPDATE statement. This option is required. See your DBMS chapter for the value to enter for your DBMS.

specifies the SAS data file to which DBMS data is output. OUT= is used with the VIEWDESC= option. VIEWDESC= specifies the view descriptor through which you extract the DBMS data.

Note:   This option cannot be specified when you create or update a view descriptor.  [cautionend]

specifies a view descriptor through which you extract the DBMS data. VIEWDESC= is used with the OUT= option.

For example:
proc access viewdesc=mydblib.newstaff

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.