The ACCESS Procedure for Relational Databases Procedure Syntax 297
To do this… Use these statements and options
Update an access
descriptor and a view
descriptor
PROC ACCESS statement-options;
UPDATE libref.member-name.ACCESS;
database-connection-statements;
editing-statements;
UPDATE libref.member-name.VIEW;
editing-statements;
RUN;
Update an access
descriptor and create a
view descriptor
PROC ACCESS statement-options;
UPDATE libref.member-name.ACCESS;
database-connection-statements;
editing-statements;
CREATE libref.member-name.VIEW;
SELECT column-list;
editing-statements;
RUN;
Update a view descriptor
from an existing access
descriptor
PROC ACCESS statement-options, including
ACCDESC=libref.access-descriptor;
UPDATE libref.member-name.VIEW;
editing-statements;
RUN;
Create a SAS data set
from a view descriptor
PROC ACCESS statement-options, including DBMS=dbms-name;
VIEWDESC=libref.member; OUT=libref.member;
RUN;
Procedure Syntax
The general syntax for the ACCESS procedure is presented here; see the
SAS/ACCESS documentation for your DBMS for DBMS-specific details.
PROC ACCESS<options>;
database-connection-statements;
CREATE libref.member-name.ACCESS | VIEW <password-option>;
UPDATE libref.member-name.ACCESS | VIEW <password-option>;
TABLE= <’>table-name<’>;
ASSIGN <=>YES | NO | Y | N;
DROP <’>column-identifier-1<’> <…<’>column-identifier-n<’>>;
FORMAT <’>column-identifier-1<’> <=>SAS-format-name-1
<…<’>column-identifier-n<’> <=> SAS-format-name-n>;
LIST <ALL | VIEW |<’>column-identifier<’>>;
QUIT;
