@FilipAxelsson wrote:
When im using that code i get the following result. Which doesnt calculate a subtotal, the only column that has a subtotal is C. Is there another way to create a crosstab with subtotals in the way i want it? (Picture in the first post)
The code was to show where the ALL goes with a label that shows in the output and how the nesting of Tabulate works.
If you nest a variable to the right of an ALL you get those subgroups, you don't get to "skip" them. That is not a tabulate feature.
What you want is likely not going to come from Tabulate.
Consider this Proc Report though (and notice that I use a SAS data set that you have so can actually test code SASHELP.CARS is one of the sets SAS supplies for training in your install).
proc report data=sashelp.cars spanrows;
where make in ('Acura' 'Audi' 'BMW');
columns make type cylinders mpg_city;
define make /group;
define type/group ;
define cylinders/group;
define mpg_city/ mean;
break after make/summarize;
run;
... View more