🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-24-2016 02:03 PM
(1601 views)
Hi,
What is the actual value of 1.534386E-17?
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
FYI - this is scientific notation so it translates to
1.534x10^-17
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
0
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
FYI - this is scientific notation so it translates to
1.534x10^-17
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, that helps! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.