Bottomline totals/percentages on proc summary

[Q1983]

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

[Reeza · Accepted solution]

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.

[ballardw]

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;