DATA Step, Macro, Functions and more

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

Reply
Regular Learner
Posts: 1

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

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.

 

Super User
Posts: 6,948

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

Please post the log of that step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,257

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

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.

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 160 views
  • 0 likes
  • 3 in conversation