backnextLearning Path
   


Introduction

If you have data that was created using other vendors' database products, you can access it and reference it in your SAS programs as if it were stored in SAS data sets. SAS/ACCESS software enables SAS to share data with DB2, Oracle, SYBASE and other relational database management systems (DBMS). Your SAS programs can read data from a DBMS and write data to a DBMS in exactly the same way as reading from or writing to a SAS data library.

Sharing data between SAS and a DBMS

This lesson explains how to reference a DBMS as a SAS library, how to use DBMS objects (such as tables) as SAS data sets in your SAS programs, and how to use the SQL Procedure Pass-Through Facility to send DBMS-specific SQL statements directly to a DBMS.


Note:

Because some details about accessing DBMS data are specific to your operating environment and to your SAS installation, this lesson does not contain guided practices. However, if you have DBMS data and the related SAS/ACCESS software components, you can practice on your own throughout the lesson. Keep in mind that in order to perform many of the examples shown in the lesson, you will need to have the appropriate update or write privileges for your database.

If you want to create practice DBMS data, you can submit sample SAS programs. From the SAS Sample Library, choose SAS/ACCESS programs to create data for the DBMS that you want to use. Data in these sample programs is different from the examples shown in this lesson, so you can choose whatever data is most appropriate for your needs. Be sure to follow the directions in whatever program you submit.



Time to Complete

This lesson contains pages and takes approximately 1 hour to complete.



Objectives

In this lesson, you learn to

  • associate a libref with a DBMS database in the Explorer window
  • associate a libref with a DBMS database in a SAS/ACCESS LIBNAME statement
  • access DBMS data from within a SAS program
  • query, analyze, modify, and combine DBMS data
  • pass SQL statements to a DBMS for processing.

Prerequisites

Before taking this lesson, you should complete the following lessons:

  • .

  Copyright © 2003 SAS Institute Inc., Cary, NC, USA. All rights reserved.
Terms of Use & Legal Information | Privacy Statement
backnext