295
APPENDIX
1
The ACCESS Procedure for
Relational Databases
Overview of the ACCESS Procedure for Relational Databases
295
About ACCESS Procedure Statements
296
Procedure Syntax
297
PROC ACCESS Statement
298
Database Connection Statements
298
ASSIGN Statement 299
CREATE Statement 299
DROP Statement
301
FORMAT Statement
301
LIST Statement
302
QUIT Statement
303
RENAME Statement 303
RESET Statement 304
SELECT Statement 305
SUBSET Statement 306
TABLE= Statement 307
UNIQUE Statement 307
UPDATE Statement 308
Descriptors with the ACCESS Procedure 309
Examples of Using the ACCESS Procedure 311
Updating an Access Descriptor 311
Creating a View Descriptor 311
Overview of the ACCESS Procedure for Relational Databases
Although the ACCESS procedure is still supported for the database systems and
environments on which it was available in Version 6, it is no longer the recommended
method for accessing relational DBMS data. It is recommended that you access your
DBMS data more directly, using the LIBNAME statement or Pass-Through Facility.
Note: Not all SAS/ACCESS interfaces support this feature. See the chapter on
features by host to determine whether this feature is available in your environment.
This section provides general reference information for the ACCESS procedure; see
the SAS/ACCESS documentation for your DBMS for DBMS-speciļ¬c details.
