ACCESS Procedure
PROC ACCESS Statement
Accesses relational DBMS data
Syntax
Optional Arguments
- 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 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.
Copyright © SAS Institute Inc. All rights reserved.