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

To use DICTIONARY tables in other SAS procedures or in the DATA step, use PROC SQL views that are based on the DICTIONARY tables. You can either create a PROC SQL view on a DICTIONARY table or you can ...