Hybrid Queries (from Fraktal SAS Programming): Unterschied zwischen den Versionen

Aus phenixxenia.org
Zur Navigation springen Zur Suche springen
K
K
Zeile 18: Zeile 18:
 
  (
 
  (
 
  select *  
 
  select *  
   from  
+
   from ops$&DB_USR..&MYTABLE.
 
  )
 
  )
  

Version vom 21. Mai 2014, 11:43 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 ops$&DB_USR..&MYTABLE.
)
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;