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.
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 16. 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.