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
It sounds like you are looking for colpctSUM rather than colpctN.
It sounds like you are looking for colpctSUM rather than colpctN.
Astounding,
Perfect, thank you very much. Out of Curiosity what is the difference between the two?
Martinezz
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)
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.