ACCESS Procedure

See: DB2 z/OS, Oracle, SAP ASE
Syntax
Table of Procedure Tasks

Syntax

PROC ACCESS <options>;
database-connection-statements;
CREATE libref.member-name.libref.member-name.ACCESS | VIEW password-option ;
UPDATE libref.member-name.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<'>>;
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;
UNIQUE <=> YES | NO | Y | N;
RUN;

Table of Procedure Tasks

Statement Task
PROC ACCESS Access relational DBMS data
Database Connection Provide DBMS-specific connection information
ASSIGN Indicate whether SAS variable names and formats are generated
CREATE Create a SAS/ACCESS descriptor file
DROP Drop a column so that it cannot be selected in a view descriptor
FORMAT Change a SAS format for a DBMS column
LIST List columns in the descriptor and give information about them
QUIT Terminate the procedure
RENAME Modify the SAS variable name
RESET Reset DBMS columns to their default values
SELECT Select DBMS columns for the view descriptor
SUBSET Add or modify selection criteria for a view descriptor
TABLE Identify the DBMS table on which the access descriptor is based
UNIQUE Generate SAS variable names based on DBMS column names
UPDATE Update a SAS/ACCESS descriptor file
Last updated: February 3, 2026