06-24-2016 08:19 PM
In the code below, the SAS base application in our office displays the values in 'displayed' column when a is divided by b, then multiplied to 100, even if we made the format best32. However, the calculator gives longer values.
But when I tried doing the division in the "want" dataset in SAS Studio (SAS base on demand), the division works fine.
Can the automatic rounding of SAS be fixed?
input a b displayed;
16854.17 197890.028 8.5169375
819368.85 369280 221.8828125
150914.35 255027.6243 59.1756875
226253.24 858790.6977 26.3455625
100876.91 363464.5669 27.7542625
14788.51 777104.3771 1.9030275
d = (a/b)*100;
06-24-2016 08:48 PM
Can you post the numbers you want to see?
What version of SAS are you working on?
Most likely it's related to numerical precision:
06-27-2016 12:38 AM
06-27-2016 05:51 AM
Interesting, win7 calculator returns 8.5169374982351308778429199070102 for the first row.
With format 20.10 applyed to variable d, SAS returns 8.5169374982 - SAS on Windows and Linux uses up to 15 digits. I don't think that value can be increased by altering a config file or by setting a sas system option.