I want to do something like this:
proc ?? create table tmp as select t.*, o.* from teradadata t, oracle o ;
Well, there is FedSQL:
Never used it myself. What is it your trying to do as that code doesn't seem logical or valid. Why not just pull in both data sources then process, or pull in the smaller and use that in a query to the larger.
the teradata part is GB's.
If you have a common identifier between the two sources, you can simple do a join/merge operation
proc sql;
create table test as
select
a.id,
a.name,
b.age
from table1 as a
left join table 2 as b on (a.id=b.id);
quit;
Refer to: https://communities.sas.com/t5/SAS-Procedures/LEFT-JOIN-in-SAS-using-PROC-SQL/td-p/158240
proc sql; connect ... to Teradata; connect ... to oracle; create table tmp as select * from connection to oracle, Teradata ( select t.*, o.* from Teradata t, oracle o ); //something like this, DOUBLE connection. Is that possible???
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.