Note: See the appendix for a description of DLIB.OUTOFSTK. You can use the SQL procedure to create a view that joins the data from these three sources and displays their output. The SAS WHERE or ...
proc access dbms=dbf; create adlib.invoice.access; /* create access descriptor */ path="c:\sasdemo\invoice.dbf"; assign=yes; rename invoicenum = invnum amtbilled = amtbilld amountinus = amtinus; ...
create or replace view ', dbname,'.user_distinct_projects_view as select `a`.`parent_project` AS `parent_project`, `a`.`created_by` AS `created_by` ...