Chapter Contents

Previous

Next

Procedure Statements

Within SAS/ACCESS software, there are two categories of procedure statements: database-description statements and editing statements. In SAS/ACCESS interface to SYSTEM 2000 software, the DATABASE statement and its options describe the database. All other statements, except CREATE, are considered to be editing statements and are optional. The DATABASE statement is specified after the CREATE statement but before any editing statements.

The options and statements you use with the ACCESS procedure depends on your task.

For example, to create an access descriptor:

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

To create an access descriptor and a view descriptor:

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:

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

The procedure statements are described in the following sections.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.