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 !
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.