| 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
|
Specify the executing DBMS by connection name 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
|
