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

Version vom 21. Mai 2014, 11:36 Uhr

proc sql;

connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH.");

select * 
  from connection to oracle

(
select * 
  from 
)

disconnect to oracle;

quit;

@@ Zeile 1: / Zeile 1: @@
 [[Kategorie:Zazy]]
-;1st: Make SAS your SQL interpreter
+;1st Make SAS your SQL interpreter
   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.");
-;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 *
     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;
-;6th: Terminate SAS SQL processor status
+;6th Terminate SAS SQL processor status
   quit;