Joining SAS Dataset with Teradata table insert into volatile table

bthe — Thu, 12 Oct 2017 22:00:04 GMT

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;

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

LinusH — Fri, 13 Oct 2017 12:56:03 GMT

This Teradata specific syntax. If you want to continue with explicit pass through you will better off asking this at a Teradata forum.

topic Joining SAS Dataset with Teradata table insert into volatile table in SAS Programming

Joining SAS Dataset with Teradata table insert into volatile table

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