Hybrid Queries (from Fraktal SAS Programming)

Aus phenixxenia.org
Zur Navigation springen Zur Suche springen

Zurück

Übersicht

Vorwärts

Documented Code Example

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

Zurück

Übersicht

Vorwärts

Abgerufen von „https://phenixxenia.org/w/index.php?title=Hybrid_Queries_(from_Fraktal_SAS_Programming)&oldid=3742“