DATA Step, Macro, Functions and more

Teradata SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

Teradata SAS

How do I create a sas dataset from the final output of the code which is a teradata volatile table ?

Accepted Solutions
Solution
‎05-10-2018 02:54 PM
Super User
Super User
Posts: 8,116

Re: Teradata SAS

Posted in reply to nickspencer

Make sure to create a libref first and use connection=global.

Something like this.

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;

View solution in original post


All Replies
Solution
‎05-10-2018 02:54 PM
Super User
Super User
Posts: 8,116

Re: Teradata SAS

Posted in reply to nickspencer

Make sure to create a libref first and use connection=global.

Something like this.

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;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 107 views
  • 0 likes
  • 2 in conversation