To use Proc Append or Proc SQL to add an entire SAS data set to a Teradata Volatile (Temp) table, use the DBMSTEMP=YES
Libname Option, as follows:
libname mytd teradata user=xxxx pwd=yyyy server=zzzz
connection=global dbmstemp=yes;
proc delete data=mytd.temp1;
run;
/* create a volatile table */
proc sql;
connect to teradata(user=xxxx pwd=yyyy server=zzzz
connection=global);
execute
(CREATE VOLATILE TABLE temp1 (col1 INT ) ON COMMIT PRESERVE ROWS )
by teradata;
execute ( COMMIT WORK ) by teradata;
quit;
/* Get at the temp table through the global libname. */
data test;
do col1=1 to 100;output;
end;
run;
options sastrace=',,,d' sastraceloc=saslog;
proc append data=test base=mytd.temp1;
run;
proc sql;
insert into mytd.temp1
select * from test;
quit;
proc print data=mytd.temp1;
run;
libname mytd;