News

create view proclib.view1 as select * from accrec.invoices as invoices using libname accrec oracle user=username pass=password path='dbms-path'; For more information on the SAS/ACCESS LIBNAME ...
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 ...