Joining SAS Dataset with Teradata table insert into volatile table

Reply
Highlighted
Learner
Posts: 1

Joining SAS Dataset with Teradata table insert into volatile table

I want to join a SAS table to a teradata table which I have figured out how to do but now I want to dump the results into a volatile table to use this in the rest of my Teradata coding. Below is an example of what I am trying to do:

 

LIBNAME tdvolt TERADATA  authdomain=teradata server='server mode=teradata connection=global dbmstemp=yes multi_datasrc_opt=in_clause;

 

 

proc sql noerrorstop;
connect to teradata (authdomain=teradata server='' connection=global mode=teradata multi_datasrc_opt=in_clause);
execute (drop table volatile_table) by teradata;
execute
(create volatile table volatile_table as

(select b.*,a.test

from SAS.table a
left join tdvolt.table (dbmaster=yes) b
on a.test = b.test

) with data no primary index on commit preserve rows;
) by teradata;
quit;

Super User
Posts: 5,383

Re: Joining SAS Dataset with Teradata table insert into volatile table

This Teradata specific syntax. If you want to continue with explicit pass through you will better off asking this at a Teradata forum.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 95 views
  • 0 likes
  • 2 in conversation