Hybrid Queries (from Fraktal SAS Programming): Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K |
K |
||
Zeile 21: | Zeile 21: | ||
) | ) | ||
− | ; 5th Terminate connection to DBMS | + | ;5th Execute the query by issuing the SAS statement terminator ';' |
+ | |||
+ | ; | ||
+ | |||
+ | ;6th Terminate connection to DBMS | ||
disconnect to oracle; | disconnect to oracle; | ||
− | ; | + | ;7th Terminate SAS SQL processor status |
quit; | quit; |
Version vom 21. Mai 2014, 11:38 Uhr
- 1st Make SAS your SQL interpreter
proc sql;
- 2nd Connect to the DBMS using your credentials stored in Macro Variables
connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH.");
- 3rd Start your query from inside SAS with a special from clause
select * from connection to oracle
- 4th Inside brackets use DBMS specific SQL
( select * from )
- 5th Execute the query by issuing the SAS statement terminator ';'
;
- 6th Terminate connection to DBMS
disconnect to oracle;
- 7th Terminate SAS SQL processor status
quit;