SAS/ACCESS Software for Relational Databases: Reference

Introduction

This topic presents examples of accessing and updating DBMS data through Version 6 view descriptors. In Version 7 and later, there are several changes in the ways that the SAS/ACCESS procedures work. For more information, see Version 8 Compatibility for Version 6 Procedures.

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

For information about using view descriptors efficiently in SAS programs, see Performance and Efficient View Descriptors.

Note: See your DBMS chapter to determine whether the ACCESS and DBLOAD procedures are available for your DBMS. [cautionend]

Tips for Running ACCESS and DBLOAD Procedure Examples

As you work through the examples, notice that the descriptors can be created in several ways. In some cases, the ASSIGN=YES statement is specified and SAS variable names and formats are assigned when the access descriptor is created. In other cases, the ASSIGN statement is omitted and editing statements, such as RENAME and UNIQUE, are specified when the view descriptors are created. How you create descriptors depends on your site's needs and practices.

When you run the examples, you need only to create an access descriptor or a view descriptor once per example. If you rerun the examples, you do not need to re-create the descriptors.

Chapter Contents
Previous
Next
Top of Page