Accessing DBMS Data with the SQL Pass-Through Facility

About the SQL Pass-Through Facility Sample Code

The examples in this section demonstrate how to use the SQL pass-through facility to access and update DBMS data. You can use the SQL pass-through facility to read and write data between SAS and a DBMS. However, it is recommended that you use the LIBNAME statement to access your DBMS data more easily and directly.

To run these examples, follow these steps:

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