Simon Fraser University

Using the SQL Procedure with DBMS Data

The following examples use the SQL procedure to query, update, and create DBMS tables. Querying a DBMS Table This example uses the SQL procedure to query the ORACLE table PAYROLL. The PROC SQL query ...
Simon Fraser University

Creating SAS Data Sets from DBMS Data

Note that you can specify a libref that references DBMS data in the DATA= option. libname mydb2lib db2 ssid=db2; proc print data=mydb2lib.staff (keep=lname fname hphone state); where state = 'NJ'; ...