The ACCESS Procedure for Relational Databases

Syntax: ACCESS Procedure

The general syntax for the ACCESS procedure is presented here. See DB2 z/OS, Oracle, or Sybase for DBMS-specific details.

CREATE libref.member-name.ACCESS | VIEW <password-option>;

UPDATE libref.member-name.ACCESS | VIEW <password-option>;

TABLE= <'>table-name<'>;

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

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;

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

RUN;