SAS/ACCESS Interface to CA-DATACOM/DB: Reference

ACCESS Procedure Syntax

PROC ACCESS <options>;

Creating and Updating Statements

CREATE libref.member-name.ACCESS | VIEW;

UPDATE libref.member-name.ACCESS|VIEW <password-level=SAS-password>;

Database-Description Statements

DATABASE | DB<=> <">Datacom-database-name<">;

DBSTAT<=> <">PROD<"> | <">TEST<"> | <">test-version<">;

PASSWORD | PASS | PW<=> <">Datacom-password<">;

TABLE<=> <">Datacom-table-name<">;

TBLSTAT<=> <">PROD<"> | <">TEST<"> | <">test-version<">;

URT<=> <">User-Requirements-Table-name<">;

USER<=> <">authorized-Datacom-userid<">;

Editing Statements

ASSIGN | AN<=> YES | NO | Y | N;

CONTENT <">column-identifier-1<"> <=> SAS-date-format | length
<...<">column-identifier-n<"> <=> SAS-date-format | length>;

DROP <">column-identifier-1<"> <...<">column-identifier-n<">>;

EXTEND ALL | VIEW | <">column-identifier-1<"> <...<">column-identifier-n<">>;

FORMAT | FMT <">column-identifier-1<"> <=> SAS-format-name <...<">column-identifier-n<"> <=> SAS-format-name>;

INFORMAT | INFMT <">column-identifier-1<"> <=> SAS-format-name <...<">column-identifier-n<"> <=> SAS-format-name>;

KEY<=> <">Datacom-short-name<">;

LIST ALL | VIEW | <">column-identifier-1<"> <...<">column-identifier-n<">;>

LISTINFO ALL | VIEW | <">column-identifier-1<"> <...<">column-identifier-n<">>;

LISTOCC <">column-identifier-1<"> <...<">column-identifier-n<">>;

OCCURS <">column-identifier<">
CONTENT occurrence-1 <=> SAS-format-name
<...occurrence-n <=> SAS-format-name>;
|
DROP occurrence-1 <TO> occurrence-n;
|
FORMAT <">occurrence-1<"> <=> SAS-format-name
<...<">occurrence-n<"> <=> SAS-format-name>;
|
INFORMAT <">occurrence-1<"> <=>SAS-format-name
<...<">occurrence-n<"> <=> SAS-format-name>;
|
RENAME <">occurrence-1<"> <=> SAS-name
<...<">occurrence-n<"> <=> SAS-name>;
|
RESET occurrence-1 <TO> occurrence-n;
|
SELECT occurrence-1 <TO> occurrence-n;

RENAME <">column-identifier-1<"> <=> SAS-name
<...<">column-identifier-n<"> <=>SAS-name>;

RESET ALL | <">column-identifier-1<"> <...<">column-identifier-n<">>;

SELECT ALL | <">column-identifier-1<"> <...<">column-identifier-n<">>;

SUBSET selection-criteria;

QUIT | EXIT;

Description

You use the ACCESS procedure to create and edit access descriptors and view descriptors, and to create 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 ACCESS procedure can run in batch or interactive line modes.

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

PROC ACCESS Statement Options

The ACCESS procedure statement takes the following options:

PROC ACCESS options;

Depending on which options you use, the ACCESS procedure 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. See Procedure Statements for information on which procedure statements to use for each task. The following sections describe PROC ACCESS options in greater detail.

Options

This section describes the options that you use to create and edit access descriptors and view descriptors.

ACCDESC=libref.access-descriptor

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=.

DBMS=DATACOM

specifies the database management system you want to the descriptor(s) to access. Specify DBMS=DATACOM since you are using the SAS/ACCESS interface to CA-DATACOM/DB.

OUT=<libref.>member-name

specifies the SAS data file to which DBMS data are written. OUT= is used only with the VIEWDESC= option.

VIEWDESC=<libref.>view-descriptor

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=.

Chapter Contents
Previous
Next
Top of Page