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

When SAS data is joined to DBMS data by using a Pass-Through query, PROC SQL cannot optimize the query. In this case it is much more efficient to use a SAS/ACCESS LIBNAME statement, as shown in the ...