ACCESS Procedure Reference |
Creating and Updating Statements
|
CREATE
libref.member-name.ACCESS | VIEW;
|
|
UPDATE
libref.member-name.ACCESS|VIEW <password-level=SAS-password>;
|
|
Database-Description Statements
|
DBSTAT<=>
<">PROD
| <">TEST<"> |
<">test-version<">;
|
|
TABLE<=>
<">Datacom-table-name<">;
|
|
TBLSTAT<=>
<">PROD<"> | <">TEST<"> |
<">test-version<">;
|
|
URT<=>
<">User-Requirements-Table-name<">;
|
|
USER<=>
<">authorized-Datacom-userid<">;
|
|
Editing Statements
|
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<">>;
|
|
|
|
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.