New Contributor
Posts: 2

# SAS Decimals

We have an issue where we are adding a supplied number to a starting point number to calculate which observation is selected.  The problem is every once in awhile the incorrect observation is selected.  I.E.  73946.6 + 8212.4 should equal obs # 82159 but 82158 is selected instead.  Is there a way to correct this in SAS?

Posts: 3,167

## Re: SAS Decimals

Not sure if I have completely understood your issue. However, the first thing comes to my mind that it might be about precision. Apply round() or ceil() or floor() etc consistently and see if it gets fixed.

Good luck,

Haikuo

Posts: 3,215

## Re: SAS Decimals

I have seen this happening more often as result of not understanding what precision (floating point Ieee standard) has as impact.

Calculating and integer from decimal fractions is a bad idea. Just think on the following :

3 * 1/3 =? 1          3 * 0.3 =0.9 ?      3*0,3333 = 0,9999 ? or 1    3*0.333 333 333 333 333 333 =?

The floating point is having about 12 meaningfull digits.

---->-- ja karman --<-----
Super User
Posts: 10,761