296 About ACCESS Procedure Statements Appendix 1
The ACCESS procedure, along with the DBLOAD procedure and an interface view
engine, creates an interface between SAS and data in other vendors’ databases. The
ACCESS procedure enables you to create and update descriptors.
About ACCESS Procedure Statements
The ACCESS procedure has several types of statements:
Database connection statements are used to connect to your DBMS. For details, see
the SAS/ACCESS documentation for your DBMS.
Creating and updating statements are CREATE and UPDATE.
Table and editing statements include ASSIGN, DROP, FORMAT, LIST, QUIT,
RENAME, RESET, SELECT, SUBSET, TABLE, and UNIQUE.
The following table summarizes the PROC ACCESS options and statements that are
required to accomplish common tasks.
Table A1.1 Statement Sequence for Accomplishing Tasks with the ACCESS Procedure
To do this… Use these statements and options
Create an access
descriptor
PROC ACCESS statement-options;
CREATE libref.member-name.ACCESS;
database-connection-statements;
editing-statements;
RUN;
Create an access
descriptor and a view
descriptor
PROC ACCESS statement-options;
CREATE libref.member-name.ACCESS;
database-connection-statements;
editing-statements;
CREATE libref.member-name.VIEW;
SELECT column-list;
editing-statements;
RUN;
Create a view descriptor
from an existing access
descriptor
PROC ACCESS statement-options, including
ACCDESC=libref.access-descriptor;
CREATE libref.member-name.VIEW;
SELECT column-list;
editing-statements;
RUN;
Update an access
descriptor
PROC ACCESS statement-options;
UPDATE libref.member-name.ACCESS;
database-connection-statements;
editing-statements;
RUN;
