ACCESS Procedure Statements

In the SAS/ACCESS interface to SYSTEM 2000, the DATABASE statement and its options describe the database. All other statements, except CREATE, are editing statements and are optional. The DATABASE statement is specified after the CREATE statement and before any editing statements.

The options and statements that you use with PROC ACCESS depend on the task that you are performing. For example, to create an access descriptor, use the following program:

proc access dbms=s2k;
   create mylib.employe.access;
      DATABASE statement;
      optional editing statement(s);
run;

To create an access descriptor and a view descriptor, use the following program:

proc access dbms=s2k;
   create mylib.employe.access;
      DATABASE statement;
      optional editing statement(s);

   create vlib.emppos.view;
      optional editing statement(s);
run;

To create a view descriptor from an existing access descriptor, use the following program:

proc access dbms=s2k accdesc=mylib.employe;
   create vlib.emppos.view;
      optional editing statement(s);
run;