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

"with" statment in proc sql while connecting to oracle

pemfir — Fri, 20 Jun 2014 18:51:11 GMT

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 !

DBailey — Fri, 20 Jun 2014 18:59:55 GMT

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;