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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.