PROC SQL SUM ISSUE

[JasonNC]

Hi

[Patrick]

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

[pradeepalankar]

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

[Patrick]

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.