Joining SAS Dataset with Teradata table insert into volatile table

[bthe]

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;

[LinusH]

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