Previous Page | Next Page

The ACCESS Procedure for PC Files

ACCESS Procedure Syntax


The general syntax for the is presented here. For specific details, see File Format-Specific Reference for the IMPORT and EXPORT Procedures.

PROC ACCESS <option(s)>;
ASSIGN =YES|NO|Y|N
CREATE < libref.member-name.>ACCESS|VIEW;
DROP <'column-identifier-1'>...<'column-identifier-n'>
FORMAT <'column-identifier1' ><SAS format-name>...<'column-identifier-n' SAS format-name>
LIST ALL|VIEW|<'column-identifier '>
MIXED=YES | NO | Y | N
PATH= <'path-and-filename.PC-filename-extension'>|<'filename'>|<fileref>
QUIT
RENAME <'column-identifier-1'>=<'SAS variable-name-1'>...<'column-identifier-n'>=<'SAS variable-name-n'>
RESET ALL | <'column-identifier-1'>... <'column-identifier-n'>
SELECT ALL|<'column-identifier-1'>...<'column-identifier-n'>
SUBSET <selection-criteria>
TYPE <'column-identifier-1'>=C| N...<'column-identifier-n' >=C|N
UPDATE <libref.member-name.>ACCESS|VIEW
UNIQUE=YES|NO|Y|N
RUN;

Previous Page | Next Page | Top of Page