topic Proc Summary with Grand Total in SAS Programming

Proc Summary with Grand Total

ertweety — Mon, 21 Nov 2016 21:00:08 GMT

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 — Mon, 21 Nov 2016 21:14:22 GMT

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 — Mon, 21 Nov 2016 21:16:48 GMT

Probably easier to do this in PROC TABULATE?

You can get grand totals and a more formatted table.

ertweety — Tue, 22 Nov 2016 20:49:14 GMT

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