Chapter Contents |
Previous |
Next |
SAS/ACCESS Software for Relational Databases: Reference |
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
| ||||||||||||
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
| ||||||||||||
Editing
Statements
|
Description |
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.
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=.
Note: This option cannot be specified when you create
or update a view descriptor.
proc access viewdesc=mydblib.newstaff out=dlib.newstaff; run;
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.