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

Aus phenixxenia.org
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „Kategorie:Zazy ;1st: Make SAS your SQL interpreter proc sql; ;2nd: Connect to the DBMS using your credentials stored in Macro Variables connect t…“)
 
K
Zeile 1: Zeile 1:
 
[[Kategorie:Zazy]]
 
[[Kategorie:Zazy]]
  
;1st: Make SAS your SQL interpreter
+
;1st Make SAS your SQL interpreter
  
 
  proc sql;
 
  proc sql;
  
;2nd: Connect to the DBMS using your credentials stored in [[Macro Variables]]
+
;2nd Connect to the DBMS using your credentials stored in [[Macro Variables]]
  
 
  connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH.");
 
  connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH.");
  
;3rd: Start your query from inside SAS with a special from clause
+
;3rd Start your query from inside SAS with a special from clause
  
 
  select *  
 
  select *  
 
   from connection to oracle
 
   from connection to oracle
  
;4th: Inside brackets use DBMS specific SQL
+
;4th Inside brackets use DBMS specific SQL
  
 
  (
 
  (
Zeile 21: Zeile 21:
 
  )
 
  )
  
; 5th: Terminate connection to DBMS
+
; 5th Terminate connection to DBMS
  
 
  disconnect to oracle;
 
  disconnect to oracle;
  
;6th: Terminate SAS SQL processor status  
+
;6th Terminate SAS SQL processor status  
  
 
  quit;
 
  quit;

Version vom 21. Mai 2014, 11:36 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 Terminate connection to DBMS
disconnect to oracle;
6th Terminate SAS SQL processor status
quit;