Percentage accuracy in PROC FREQ

Sathish_jammy — Sat, 15 Dec 2018 05:59:00 GMT

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

Re: Percentage accuracy in PROC FREQ

Kurt_Bremser — Sat, 15 Dec 2018 08:03:11 GMT

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.