proc access dbms=oracle; /* create access descriptor */ create adlib.invoice.access; user=scott; password=tiger; path='myorapath' table=invoice; assign=yes; rename invoicenum = invnum amtbilled = ...
When you use a view descriptor in a DATA step or SAS procedure, columns that you specified in the VAR and KEEP statements are passed to the DBMS for processing. Columns that you specified in DROP ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback