Round function NOT WORKING

[SASKiwi]

@JohnChen_TW - unfortunately I don't think that is possible with "normal" SAS. Maybe SAS's DS2 is worth checking out? I'm pretty sure that is only available with SAS 9.4 though.

[JohnChen_TW]

@SASKiwi I've discussed with our vendor and they will provide us the results with 14 decimal places at most in the future. (although I'm still curious how to fix it)

Thanks again for all your replies:)

JC

[Kurt_Bremser]

---

@JohnChen_TW wrote:

@SASKiwi I've discussed with our vendor and they will provide us the results with 14 decimal places at most in the future. (although I'm still curious how to fix it)

Thanks again for all your replies:)

JC

---

Since the 15-decimal-digits precision is a hard limit imposed by the use of the 8-byte real format for numerical storage, there is no fix until software that works with numbers switches to 128 bits for numerical storage. Given the non-existent statistical relevance of such digits, I don't expect that switch for statistical software in the near future. You might see something in accounting software, where people would want precision down to cents in amounts like the GDP of the US.