SAS/ACCESS Software for Relational Databases: Reference

Introduction

In most of the interfaces that are provided in Version 6 of SAS/ACCESS software, the ACCESS procedure enabled you to create descriptor files that are used to access and update DBMS data in SAS. The ACCESS procedure continues to be supported in Version 7 and later. However, there are some changes in the support, as described in Version 8 Compatibility for Version 6 Procedures.

This chapter provides general reference information for the ACCESS procedure. The PROC ACCESS statement and its options are presented first, followed by the procedure statements. The last section, Performance and Efficient View Descriptors, presents several efficiency considerations for using SAS/ACCESS software.

See your DBMS chapter to determine whether the ACCESS procedure is supported for your DBMS, and for DBMS-specific information pertaining to the ACCESS procedure. Refer to the SAS Language Reference: Dictionary and to the SAS Companion for your operating system environment for information about SAS data sets, SAS data libraries, and their naming conventions. If you are using this documentation from a book, remember that help is available from the Help menu.

Note: It is recommended that you use the new SAS/ACCESS LIBNAME statement instead of PROC ACCESS in order to access your DBMS data more directly and to take full advantage of the Version 7 and later enhancements. See SAS/ACCESS LIBNAME Statement for more information about the new LIBNAME statement. [cautionend]

Chapter Contents
Previous
Next
Top of Page