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
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.
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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.