Proc Summary with Grand Total

[ertweety]

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;

[Shmuel]

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.

[Reeza]

Probably easier to do this in PROC TABULATE?

You can get grand totals and a more formatted table. 

[ertweety · Accepted solution]

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