Hi,
What is the actual value of 1.534386E-17?
FYI - this is scientific notation so it translates to
1.534x10^-17
0
FYI - this is scientific notation so it translates to
1.534x10^-17
Thanks, that helps! 🙂
Although @Reeza's post is rather terse, he is probably spot-on to the problem. Numbers in that range are often encountered when the internal representation of numbers in SAS (8-byte real) causes problems stemming from the decimal-to-binary conversion (ie 0.1 cannot be correctly stored as a binary number).
In such cases, apply the round() function to get rid of inaccuracies happening far to the right of the decimal point.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.