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;