topic Re: Couldn't Load all rows from SAS to Teradata using Proc Append in SAS Programming

Couldn't Load all rows from SAS to Teradata using Proc Append

iSAS — Tue, 07 Mar 2017 05:38:56 GMT

I need to load the table of SAS to Teradata. To do it i used the below command:

PROC APPEND BASE = TERADATA.TARGET (MULTILOAD=YES TPT=YES)

DATA = SAS.SOURCE () FORCE;

RUN;

However, not all rows are being appended. Did i miss any option on my code? Thanks.

Kurt_Bremser — Tue, 07 Mar 2017 08:18:35 GMT

Please post the log of that step.

LinusH — Tue, 07 Mar 2017 10:40:39 GMT

Also, issue

options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix;

prior to the append step to get more info on waht's going on in Teradata.