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;
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.