Product	Release
SAS/ACCESS Interface to PC Files	9.2

The ACCESS Procedure for PC Files

ACCESS Procedure Syntax

Create and Update Statements

CREATE libref.member-name.ACCESS|VIEW ;

UPDATE libref.member-name.ACCESS|VIEW ;

Database-Description Statements

PATH= 'path-and-filename<.PC-filename-extension>' | <'>filename<'> | fileref;

(SeeXLS files or WKn files for additional database-description statements for those file formats.)

Editing Statements

ASSIGN <=>YES|NO|Y|N;

DROP <'>column-identifier-1<'>
<<'>...column-identifier-n<'>>;

FORMAT <'>column-identifier-1<'><=>SAS-format-name-1<'> <...<'>column-identifier-n<'><=>SAS-format-name-n>;

LIST <ALL|VIEW|<'>column-identifier<'>>;

MIXED <=> YES | NO | Y | N;

(The MIXED statement is not available for DIF and DBF files.)

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>;

(The TYPE statement is not available for DBF files.)

UNIQUE <=>YES|NO|Y|N ;

RUN;

SAS/ACCESS(R) 9.2 Interface to PC Files: Reference