SAS/ACCESS Software for Relational Databases: Reference

Introduction

This section presents examples of using the new SAS/ACCESS LIBNAME statement, the SQL Procedure Pass-Through Facility, and Version 6 view descriptors.

Throughout the examples, the SAS terms variable and observation are used instead of column and row because these chapters illustrate SAS System procedures and the SAS DATA step.

See DBMS Tables (Textile Data) for a listing of the sample data that the examples use. This appendix also includes SAS data files that are used in this section, as well as the SAS statements that created them.

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 Versions 7 and 8 enhancements. See SAS/ACCESS LIBNAME Options for more information about the new LIBNAME statement. [cautionend]

Running the Examples in This Section

The examples in the following sections show DBMS data from a number of SAS/ACCESS interfaces. The interface is identified in each example and any DBMS-specific issues are described in the example.

Note: In examples that update DBMS data, examples that are rerun will not produce the same results because the DBMS tables have been modified. You must submit the GENSQL.SAS or GENDBL.SAS file included with your software to re-create the DBMS tables. [cautionend]

If you run the examples individually instead of running the entire examples file, you must preface them with LIBNAME statements to identify where data is stored.

The files that create the DBMS tables, descriptors, and the examples are shipped with your SAS/ACCESS software. See Introduction to Sample Files for more information about these files.

Chapter Contents
Previous
Next
Top of Page