Passthru SQL (from Fraktal SAS Programming)

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
(	Start passthru code using a 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 code using a 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