- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hey all,
1.I need to calculate a percentage in proc tabulate. I am trying to sum a variable (totalsch) then find it's percentage of the column total.
I believe the code below would do that, however, when I check the calculation the percentage is incorrect.
Any thoughts?
proc tabulate data = Collegeofmusic style=untpdf;
class acad_plan acad_term_desc;
var totalsch;
Table acad_plan All='Total',acad_term_desc*totalsch*(sum colpctn) ALL='Total';
run;
Thanks Martinezz
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
It sounds like you are looking for colpctSUM rather than colpctN.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
It sounds like you are looking for colpctSUM rather than colpctN.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Astounding,
Perfect, thank you very much. Out of Curiosity what is the difference between the two?
Martinezz
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Both get you column percentages, but ...
colpctN computes percentages based on the N statistic (number of observations with a nonmissing value for the analysis variable)
colpctSUM computes percentages based on the SUM statistic (sum of the analysis variable)