Accessing DBMS Data with the LIBNAME Statement

About the LIBNAME Statement Sample Code

The examples in this section demonstrate how to use the LIBNAME statement to associate librefs with DBMS objects, such as tables and views. The LIBNAME statement is the recommended method for accessing DBMS data from within SAS.

These examples work with all SAS/ACCESS relational interfaces. Follow these steps to run these examples.

Modify and submit the ACCAUTO.SAS file, which creates the appropriate LIBNAME statements for each database.
Submit the ACCDATA.sas program to create the DBMS tables and SAS data sets that the sample code uses.
Submit the ACCRUN.sas program to run the samples.

These programs are available in the SAS Sample Library. If you need assistance locating the Sample Library, contact your SAS support consultant. See Descriptions of the Sample Data for information about the tables that are used in the sample code.

Note: Before you rerun an example that updates DBMS data, resubmit the ACCDATA.sas program to re-create the DBMS tables. [cautionend]

Top of Page