DATA Step, Macro, Functions and more

Teradata DB insert data from sas dataset in a efficient way

Reply
Contributor
Posts: 55

Teradata DB insert data from sas dataset in a efficient way

Teradata administrator team informed that my data for insert into teradata is less but cpu skew usage is very high..

 

I have below statement to improve performance but I am getting error as "Insert substitution
values are not shown"

 

proc append base=TERA_TABLE_NAME (MULTILOAD=YES MULTISTMT=YES) data=work.SASDATASET1; run;

 

Super User
Posts: 5,257

Re: Teradata DB insert data from sas dataset in a efficient way

It would be beneficial to dhow the full log.
From your excerpt it looks like you are appending to a table in SAS WORK, not in Teradata.
Data never sleeps
Super User
Posts: 9,682

Re: Teradata DB insert data from sas dataset in a efficient way

Could you try proc sql + insert ?

libname x teradata .......  insertbuff=10000 dbcommit=yes;
proc sql;
insert into ......


Ask a Question
Discussion stats
  • 2 replies
  • 302 views
  • 0 likes
  • 3 in conversation