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 ...

This example joins SAS data with CA-OpenIngres data that is retrieved by using a Pass-Through query in a PROC SQL SELECT statement. In this example's PROC SQL CONNECT statement, the database name is ...