ACCESS Procedure Reference |
Syntax for PROC ACCESS Statement Options |
PROC ACCESS options; |
Depending on which options you use, the PROC ACCESS statement performs several tasks.
You use the PROC ACCESS statement with database-description statements and certain procedure statements to create descriptors or SAS data files from DBMS data.
The PROC ACCESS statement takes the following options:
specifies 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 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 the database management system that you want the descriptor(s) to access. Specify DBMS=Datacom since you are using the SAS/ACCESS interface to CA-Datacom/DB.
specifies the SAS data file to which DBMS data is written. OUT= is used only with the VIEWDESC= option.
specifies a view descriptor that accesses the CA-Datacom/DB data. VIEWDESC= is used only with the OUT= option.
For example:
proc access dbms=Datacom viewdesc=vlib.invq4 out=dlib.invq4; run;
The VIEWDESC= option has two aliases: VD= and VIEW=.
PROC ACCESS Statement Options |
The ACCESS procedure statement takes the following options:
specifies 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 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 the database management system you want the descriptor(s) to access. Specify DBMS=Datacom since you are using the SAS/ACCESS interface to CA-Datacom/DB.
specifies the SAS data file to which DBMS data written. OUT= is used only with the VIEWDESC= option.
specifies a view-descriptor that accesses the CA-Datacom/DB data. VIEWDESC= is used only with the OUT= option.
For example:
proc access dbms=Datacom viewdesc=vlib.invq4 out=dlib.invq4; run;
The VIEWDESC= option has two aliases: VD= and VIEW=.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.