BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
cellurl
Quartz | Level 8

I want to do something like this:

proc ??
   create table tmp as 
   select 
      t.*,
      o.*
   from
      teradadata t,
      oracle o
   ;

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20
No, not like that.
I'm missing a join criteria in you example.
Your options are joining via SAS implicit pass through , risking that both tables would download to SAS.
If your Oracle table is relative small try to copy it to a TD volatile table so that the join will performed completely in TD.
Or perhaps there is a possibility to connect directly to Oracle from TD?
Data never sleeps

View solution in original post

5 REPLIES 5
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Well, there is FedSQL:

http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/viewer.htm#fedsqlrefwhatsne...

 

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.

cellurl
Quartz | Level 8

the teradata part is GB's.

nirajp91
Calcite | Level 5

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

cellurl
Quartz | Level 8
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???
LinusH
Tourmaline | Level 20
No, not like that.
I'm missing a join criteria in you example.
Your options are joining via SAS implicit pass through , risking that both tables would download to SAS.
If your Oracle table is relative small try to copy it to a TD volatile table so that the join will performed completely in TD.
Or perhaps there is a possibility to connect directly to Oracle from TD?
Data never sleeps

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2636 views
  • 0 likes
  • 4 in conversation