SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
ProcWes
Quartz | Level 8

ERROR: Teradata row not delivered (trget): Numeric overflow occurred during computation.

 

I have ~300 variables in this data, at least one of them is causing this error.  Without pulling one by one, or something like that, how can I identify which variable is the one causing this problem?

 

It's a teradata database, being read with proc sql in EG 9.4

 

Thanks

5 REPLIES 5
ballardw
Super User

Examine the variables in the Teradata source for characteristics that indicate large or small values like DOUBLE precision, extended precision or some such (I don't speak Teradata).

You apparently are doing something with a computation. Look for computations involving any of those variables. Perhaps either use pass through code an execute in Teradata then move the results to SAS or move the data to SAS prior to the computations.

tomrvincent
Rhodochrosite | Level 12
Make sure you're using explicit passthru with Teradata SQL instead of implicit passthru with SAS SQL.
Tom
Super User Tom
Super User

The surprising thing to me was that simple counts can cause that error, depending on whether you are using TERADATA or ANSI mode.

 

We needed to use explicit passthru and cast the count as BIGINT, or better for working with SAS as FLOAT.

proc sql ;
  connect .... ;
  select * from connection to teradata 
(select cast(count(*) as float) as nobs
  from mydb.mytable
);
quit;

 

ProcWes
Quartz | Level 8

I appreciate all of the replies, but none of the responses answered the question.

tomrvincent
Rhodochrosite | Level 12

If you're summing a smallint, that's one likely cause. The result wouldn't fit in a smallint.  Cast to decimal or float.

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 5840 views
  • 0 likes
  • 4 in conversation