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)
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.