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