topic Re: Proc tabulate add total row after each category in SAS Programming

Proc tabulate add total row after each category

Ronein — Tue, 16 Nov 2021 09:54:31 GMT

Hello

I want to add a total row after each origin.(There are 3 origins : Asia,Europe ,USA so I need to add 3 total rows)

What is the way to do it please?

proc tabulate data=sashelp.cars  out=want_a1(drop=_type_ _page_ _table_) format=comma21. MISSING;
 class origin   Type   Cylinders ;
 table origin='Factory Origin'*Type='Type of Car' all='TOTAL', (Cylinders='Number_Cylinders' )*(n=''*f=comma21.) all='TOTAL' / rts=10  misstext='0';
run;

Re: Proc tabulate add total row after each category

Kurt_Bremser — Tue, 16 Nov 2021 10:21:02 GMT

Maxim 6: Google Is Your Friend.

A search for "sas subtotal proc tabulate" immediately leads to this communities post (first hit), which gives me this solution:

proc tabulate data=sashelp.cars  out=want_a1(drop=_type_ _page_ _table_) format=comma21. MISSING;
 class origin   Type   Cylinders ;
 table (origin='Factory Origin' all="Origin Total")*(Type='Type of Car' all='TOTAL'), (Cylinders='Number_Cylinders' )*(n=''*f=comma21.) all='TOTAL' / rts=10  misstext='0';
run;