Hi
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
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.