298 PROC ACCESS Statement Appendix 1
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;
PROC ACCESS Statement
PROC ACCESS <options>;
Options
ACCDESC=libref.access-descriptor
specifies an access descriptor. ACCDESC= is used with the DBMS= option to create
or update a view descriptor that is based on the specified access descriptor. You can
use a SAS data set option on the ACCDESC= option to specify any passwords that
have been assigned to the access descriptor.
Note: The ODBC interface does not support this option.
DBMS=database-management-system
specifies which database management system you want to use. This DBMS-specific
option is required. See the SAS/ACCESS documentation for your DBMS.
OUT=libref.member-name
specifies the SAS data file to which DBMS data is output.
VIEWDESC=libref.view-descriptor
specifies a view descriptor through which you extract the DBMS data.
Database Connection Statements
Provide DBMS-specific connection information
database-connection-statements;
Database connection statements are used to connect to your DBMS. For the
statements to use with your DBMS, see the documentation for your SAS/ACCESS
interface.
