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?
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
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.
It seems that it is a FORMAT problem .
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.