Help using Base SAS procedures

Bottomline totals/percentages on proc summary

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 141
Accepted Solution

Bottomline totals/percentages on proc summary

proc summary data = lm_pull_through_positive nway;

     class Grouping ;

     output out = lm_pull_through_Summary

           sum(num) = num;

run;

data lm_pull_through_Summary_1;

     set lm_pull_through_Summary;

     Pct = num / _Freq_;

    

run;

Grouping        _type_     _freq_        Num          Pct

Liquidation          1              610            117 0.1918032787

Retention            1              2040         160 0.0784313725

I want to now combine and show bottom line of totals  for desired output

Freq          Num           Pct

2650           277            0.104528


Accepted Solutions
Solution
‎08-17-2015 11:27 AM
Super User
Posts: 19,775

Re: Bottomline totals/percentages on proc summary

Remove the NWAY option from summary and you'll get a line with the overall total included with the variable _TYPE_=0 to indicate the total.

View solution in original post


All Replies
Solution
‎08-17-2015 11:27 AM
Super User
Posts: 19,775

Re: Bottomline totals/percentages on proc summary

Remove the NWAY option from summary and you'll get a line with the overall total included with the variable _TYPE_=0 to indicate the total.

Super User
Posts: 11,343

Re: Bottomline totals/percentages on proc summary

And another way with a different procedure if you do not need a data set with the values

Proc tabulate data = lm_pull_through_pos;

     class Grouping;

     var num;

     table grouping all='Total', n='Count' sum pctsum;

run;

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 573 views
  • 4 likes
  • 3 in conversation