Percentage accuracy in PROC FREQ

[Sathish_jammy]

Hi ,

Usually I use PROC FREQ to calculate the freq and % of the column.

But in some cases the % value is not accurate like...

While sum up the %column it should be 100, but in some cases it comes like 100.01, 99.99

What are these cases are mean to be in the calculation.

proc freq data = Noida;
by q1_gender;
tables q4_tifbox1 q4_tifbox2 q4_tifbox3	q4_tifbox_other /missing;
run;

 SAS Output -

gender - M

q4_tifbox_other
q4_tifbox_other	Frequency	Percent
0	7	0.13
1	824	14.93
2	4689	84.95

[Kurt_Bremser · Accepted solution]

This is because the result values are formatted and rounded to 2 decimals.

To change the display formats, see this note: http://support.sas.com/kb/24/822.html

You can also output the results to a dataset and set formats there.