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)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.