"with" statment in proc sql while connecting to oracle

[pemfir]

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]

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;