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 |
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.