Specify DBMSTEMP=YES Option to Write SAS Data Set to Teradata Temporary Table


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;