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

In this example, you create a simple table to test for yourself how the options work. To use name literals, you must specify the SAS system option VALIDVARNAME=ANY. Notice that you print the new DBMS ...