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???
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.