Chapter Contents

Previous

Next
SAS/ACCESS Software for PC File Formats: Reference

Procedure Statements

This section describes in alphabetical order the statements you use inside a PROC ACCESS program block to create or modify access and view descriptors. Options and Statements Required for the ACCESS Procedure presents a task-oriented overview and indicates the order in which statements must appear. See CREATE for additional information on this order and for information on database-description and editing statements.

Options and Statements Required for the ACCESS Procedure
Tasks Options and Statements You Use
create an access descriptor

PROC ACCESS DBMS=DBF|DIF|WKn|XLS;
CREATE libref.member-name.ACCESS;
required database-description statements;
optional editing statements;
RUN;

create an access descriptor and a view descriptor

PROC ACCESS DBMS=DBF|DIF|WKn| XLS;
CREATE libref.member-name.ACCESS;
required database-description statements;
optional editing statements;

CREATE libref.member-name.VIEW;
SELECT column-list;
optional editing statements;
RUN;

create a view descriptor from an existing access descriptor

PROC ACCESS DBMS=DBF|DIF|WKn|XLS
ACCDESC=libref.access-descriptor;
CREATE libref.member-name.VIEW;
SELECT column-list;
optional editing statements;
RUN;


As the table indicates, you can create one or more access descriptors and view descriptors in one execution of PROC ACCESS, or you can create the descriptors in separate executions.


Chapter Contents

Previous

Next

Top of Page

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