| 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
|
create table my_sas_tab as
|
Initiate creating your SAS table using ANSI SQL code
|
select *
from connection to oracle
|
Start your query from inside SAS with a special from clause
|
(
select *
from ops$&DB_USR..&MYTABLE.
)
|
Inside brackets use DBMS specific SQL
|
;
|
Execute the query by issuing the SAS statement terminator ';'
|
disconnect from oracle;
|
Close connection to DBMS
|
quit;
|
Terminate SAS SQL interpreter status
|
