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???
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.