Help using Base SAS procedures

Proc tabulate calculating percentage

Accepted Solution Solved
Reply
Contributor
Posts: 27
Accepted Solution

Proc tabulate calculating percentage

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
Solution
‎08-21-2013 11:53 AM
Super User
Posts: 5,079

Re: Proc tabulate calculating percentage

It sounds like you are looking for colpctSUM rather than colpctN.

View solution in original post


All Replies
Solution
‎08-21-2013 11:53 AM
Super User
Posts: 5,079

Re: Proc tabulate calculating percentage

It sounds like you are looking for colpctSUM rather than colpctN.

Contributor
Posts: 27

Re: Proc tabulate calculating percentage

Astounding,

Perfect, thank you very much. Out of Curiosity what is the difference between the two?

Martinezz

Super User
Posts: 5,079

Re: Proc tabulate calculating percentage

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)

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 220 views
  • 0 likes
  • 2 in conversation