DATA Step, Macro, Functions and more

"with" statment in proc sql while connecting to oracle

Reply
New Contributor
Posts: 4

"with" statment in proc sql while connecting to oracle

how can i create a temporary table (stored in a data-warehouse that i am accessing using oracle and proc sql)

here is the schematic of my problem

proc sql;

connect to oracle

with tableA as (select * from databaseA-in-datawarehouse);

select * from databaseB-in-datawarehouse

Join TableA

On certain condition

disconnect from oracle

Thank you !

Super Contributor
Posts: 578

Re: "with" statment in proc sql while connecting to oracle

proc sql;

connect to oracle as cORA (connect string from library);

create table want as select * from cORA(

     with tableA as (schemaA.tableA)

     select *

     from schemaB.tableb tableB

          on tableA ..... =  tableB....

);

disconnect from cORA;

quit;

Ask a Question
Discussion stats
  • 1 reply
  • 159 views
  • 0 likes
  • 2 in conversation