DATA Step, Macro, Functions and more

Proc Summary with Grand Total

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Proc Summary with Grand Total

 

I have the following proc summary.  How do I make a grand total at the end of the rows?


proc summary data=inv3 nway;
class dt rep supe cur_pd;
output out=inventory_counts (drop=_type_ rename=(_freq_= TL_INVENTORY));
run;


Accepted Solutions
Solution
‎11-22-2016 03:49 PM
Occasional Contributor
Posts: 15

Re: Proc Summary with Grand Total

figured it out.  Just did a data step after the summary where it sums the 4 columns

View solution in original post


All Replies
Trusted Advisor
Posts: 1,586

Re: Proc Summary with Grand Total

[ Edited ]

change from:

       proc summary data=inv3 nway;

 

to:

     proc means data=inv3  types (0  16);

 

where 0 means the grand total

and 16 = 2**4 - as you have 4 class variables.

Super User
Posts: 19,878

Re: Proc Summary with Grand Total

Probably easier to do this in PROC TABULATE?

 

You can get grand totals and a more formatted table. 

Solution
‎11-22-2016 03:49 PM
Occasional Contributor
Posts: 15

Re: Proc Summary with Grand Total

figured it out.  Just did a data step after the summary where it sums the 4 columns

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 419 views
  • 0 likes
  • 3 in conversation