Help using Base SAS procedures

PROC SQL SUM ISSUE

Reply
Regular Contributor
Posts: 155

PROC SQL SUM ISSUE

Hi

Respected Advisor
Posts: 3,907

Re: PROC SQL SUM ISSUE

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

Frequent Contributor
Posts: 106

Re: PROC SQL SUM ISSUE

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

Respected Advisor
Posts: 3,907

Re: PROC SQL SUM ISSUE

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.

Ask a Question
Discussion stats
  • 3 replies
  • 255 views
  • 6 likes
  • 3 in conversation