The ACCESS Procedure for PC Files |
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;
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.