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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.