| Code executed
|
Function performed
|
proc sql;
|
Start the SQL interpreter inside SAS
|
connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH.");
|
Open connection to the DBMS using your credentials stored in Macro Variables
|
execute
|
Trigger execution of passthru code by the SAS SQL interpreter
|
(
|
Open passthru SQL channel using a left bracket
|
create table my_ora_tab as
|
Type your Oracle SQL code as if you were using some Oracle client or frontend
|
select *
from ops$&DB_USR..&MYTABLE.
|
Inside brackets use DBMS specific SQL
|
)
|
Close passthru SQL channel using a right bracket
|
by oracle
|
Trigger execution using the DBMS connection opened before
|
;
|
Execute the query by issuing the SAS statement terminator ';'
|
disconnect from oracle;
|
Close connection to DBMS
|
quit;
|
Terminate SAS SQL interpreter status
|
