topic Re: PROC SQL SUM ISSUE in SAS Procedures

PROC SQL SUM ISSUE

JasonNC — Mon, 28 Oct 2013 04:06:25 GMT

Re: PROC SQL SUM ISSUE

Patrick — Mon, 28 Oct 2013 05:07:24 GMT

This weird value is a very small number. I strongly assume this is caused by some precision issue. Does your data source come from a data base?

One way around this:

SUM(round(AMT,0.00000000001)) AS ID_AMT,PROVIDER

Re: PROC SQL SUM ISSUE

pradeepalankar — Mon, 28 Oct 2013 11:25:28 GMT

Give it a proper format like :

proc sql;

create table test as

select sum(AMT) format = 12.5 as sum ,ID from source_table

group by ID;

quit;

sum ID

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

0.00000 XXX

Re: PROC SQL SUM ISSUE

Patrick — Mon, 28 Oct 2013 21:21:01 GMT

Using a format won't resolve the precision issue but will only mask it. I believe what the OP needs to do is to find an explanation why there is such a precision issue and then resolve it.

One reason can be that the data originates from a database. Numeric precision has been discussed here in these forums multiple times, it's documented and there are also whitepapers around.