BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Q1983
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

2 REPLIES 2
Reeza
Super User

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
Super User

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;

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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