topic Re: Bottomline totals/percentages on proc summary in SAS Procedures

Bottomline totals/percentages on proc summary

Q1983 — Mon, 17 Aug 2015 15:13:02 GMT

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 — Mon, 17 Aug 2015 15:27:33 GMT

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 — Mon, 17 Aug 2015 15:39:20 GMT

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;