SAS/ACCESS Software for Relational Databases: Reference

Introduction

This topic contains examples of easier and more direct ways of using data stored in your database management system (DBMS), beginning in Version 7 of SAS/ACCESS software. These examples use ORACLE and DB2, but SAS/ACCESS also provides interfaces to many other widely used database management systems.

Refer to Using DBMS Data with the SQL Pass-Through Facility for SAS/ACCESS examples that use the SQL Procedure Pass-Through Facility, access descriptors, view descriptors, and the ACCESS and DBLOAD procedures.

Running the Examples in This Section

The examples in this section all use the SAS/ACCESS LIBNAME statement to associate a libref directly with DBMS objects. When you assign a libref in SAS/ACCESS, you can customize the way your data is processed by using SAS LIBNAME statement options, including the new SAS/ACCESS LIBNAME options listed in SAS/ACCESS LIBNAME Statement as well as additional DBMS-specific LIBNAME statement options listed in your DBMS chapter.

When you use the LIBNAME statement to create a libref that refers to DBMS data, you can refer to the DBMS objects within the libref, such as tables and views, by using the libref.object-name syntax. Because these objects are treated by SAS software as SAS data sets, you can specify how they are processed by using SAS data set options, including the new SAS/ACCESS data set options listed in SAS/ACCESS Data Set Options and additional DBMS-specific data set options listed in your DBMS chapter.

If you specify a data set option that has the same name as a LIBNAME option that was specified during LIBNAME assignment, the data set option overrides the LIBNAME option.

The files that create the DBMS tables, descriptors, and the examples are shipped with your SAS/ACCESS software. See Sample Data in This Book for more information about these files.

Note: The examples in this chapter use the SAS/ACCESS Interface to DB2 and the SAS/ACCESS Interface to ORACLE. Because the connection arguments, such as USER=, PASSWORD=, and DATABASE= vary depending on which DBMS you use, you must substitute the appropriate connection arguments for your DBMS if you run these examples on your DBMS. [cautionend]

Chapter Contents
Previous
Next
Top of Page