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;