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	Start coding a passthru SQL code segment
( create table my_ora_tab as select * from ops$&DB_USR..&MYTABLE. )	Inside brackets type your DBMS SQL code as if you were using some DBMS client or frontend
by oracle	Name the executing DBMS connection opened before
;	Pass the code through to DBMS by issuing the SAS statement terminator ';'
disconnect from oracle;	Close connection to DBMS
quit;	Terminate SAS SQL interpreter status