DATA Step, Macro, Functions and more

SAS Decimals

Reply
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?

Respected Advisor
Posts: 3,156

Re: SAS Decimals

Posted in reply to gdudley720

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

Trusted Advisor
Posts: 3,215

Re: SAS Decimals

Posted in reply to gdudley720

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,041

Re: SAS Decimals

Posted in reply to gdudley720

It seems that it is a FORMAT problem .

Ask a Question
Discussion stats
  • 3 replies
  • 229 views
  • 5 likes
  • 4 in conversation