ACCESS Procedure Reference

ACCESS Procedure Syntax for ADABAS

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

DDM = data-definition-module-name;

NSS (LIBRARY | LIB= library-identifier
USER= user-identifier
PASSWORD | PW= Natural-Security-password);

ADBFILE (NUMBER | NUM= Adabas-file-number
PASSWORD | PW= Adabas-password
CIPHER | CC= Adabas-cipher-code
DBID= Adabas-database-identifier);

SYSFILE (NUMBER | NUM= Adabas-system-file-number
PASSWORD | PW= Adabas-password
CIPHER | CC= Adabas-cipher-code
DBID= Adabas-database-identifier);

SECFILE (NUMBER | NUM= Natural-Security-system-file-number
PASSWORD | PW= Adabas-password
CIPHER | CC= Adabas-cipher-code
DBID= Adabas-database-identifier);

Editing Statements

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

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

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

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

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

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

KEY<=> column-identifier-1 <...column-identifier-n>;

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

MVF column-identifier
CONTENT occurrence-1<=>SAS-date-format | length | E
<... occurrence-n<=>SAS-date-format| length| E >;
|
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>;
|
OCCURS<=>number-of-occurrences;
|
RENAME occurrence-1<=>SAS-variable-name
<...occurrence-n<=>SAS-variable-name>;
|
RESET occurrence-1 <<TO>... occurrence-n>;
|
SELECT occurrence-1 <<TO>... occurrence-n>;

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

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

SECURITY <=> YES | NO | Y | N;

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

SUBSET selection-criteria;

QUIT;

RUN;

Top of Page