Help using Base SAS procedures

proc sql numeric overflow for TeraData query

Accepted Solution Solved
Reply
Regular Contributor
Posts: 204
Accepted Solution

proc sql numeric overflow for TeraData query

I am aware of this and use SAS code along those lines:

 

proc sql;
connect to TERADATA (OVERRIDE_RESP_LEN=YES SERVER=DBC AUTHDOMAIN="Bla" MODE=TERADATA);
create table SomeExcitingData as
Select *
from connection to teradata
(
.... 
);
disconnect from TERADATA;
quit;

 

Here ... contains SQL code which works perfectly fine when submitted to TeraData via SQL Assistant. Unfortunately, I get:

 

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

 

Any ideas? Thanks!

 

 


Accepted Solutions
Solution
‎10-24-2017 05:07 PM
PROC Star
Posts: 511

Re: proc sql numeric overflow for TeraData query

Posted in reply to csetzkorn

Just be careful when you are moving big number, SAS does have restriction in length and precision for numeric column. If number is significantly large cast it to char

 

http://support.sas.com/documentation/cdl/en/hostunx/61879/HTML/default/viewer.htm#a000344718.htm

View solution in original post


All Replies
PROC Star
Posts: 511

Re: proc sql numeric overflow for TeraData query

[ Edited ]
Posted in reply to csetzkorn

do you know, which column could be causing this and are number of records same for what you run in sql assistant and pass through are same?

Regular Contributor
Posts: 204

Re: proc sql numeric overflow for TeraData query

I solved - cast(... as decimal(38,8)) solved the issue!
Solution
‎10-24-2017 05:07 PM
PROC Star
Posts: 511

Re: proc sql numeric overflow for TeraData query

Posted in reply to csetzkorn

Just be careful when you are moving big number, SAS does have restriction in length and precision for numeric column. If number is significantly large cast it to char

 

http://support.sas.com/documentation/cdl/en/hostunx/61879/HTML/default/viewer.htm#a000344718.htm

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 664 views
  • 0 likes
  • 2 in conversation