https://communities.sas.com/t5/SAS-Programming/Teradata-SAS/m-p/461372#M117362 <P>Make sure to create a libref first&nbsp;and use connection=global.</P> <P>Something like this.</P> <PRE><CODE class=" language-sas">libname tdwork teradata ..... dbmstemp=yes connection=global; proc sql ; connect using tdwork; execute ( create volatile table xxx as ... ) by tdwork; quit; data work.want ; set tdwork.xxx ; run; </CODE></PRE> Thu, 10 May 2018 17:58:00 GMT Tom 2018-05-10T17:58:00Z https://communities.sas.com/t5/SAS-Programming/Teradata-SAS/m-p/461366#M117359 How do I create a sas dataset from the final output of the code which is a teradata volatile table ? Thu, 10 May 2018 17:11:36 GMT https://communities.sas.com/t5/SAS-Programming/Teradata-SAS/m-p/461366#M117359 nickspencer 2018-05-10T17:11:36Z https://communities.sas.com/t5/SAS-Programming/Teradata-SAS/m-p/461372#M117362 <P>Make sure to create a libref first&nbsp;and use connection=global.</P> <P>Something like this.</P> <PRE><CODE class=" language-sas">libname tdwork teradata ..... dbmstemp=yes connection=global; proc sql ; connect using tdwork; execute ( create volatile table xxx as ... ) by tdwork; quit; data work.want ; set tdwork.xxx ; run; </CODE></PRE> Thu, 10 May 2018 17:58:00 GMT https://communities.sas.com/t5/SAS-Programming/Teradata-SAS/m-p/461372#M117362 Tom 2018-05-10T17:58:00Z