It looks like you will need a "Compute After" but I'm not sure exactly how to implement that as i don't know how your car and brand groups are defined.
https://communities.sas.com/t5/SAS-Procedures/How-to-Label-totals-and-subtotals-in-PROC-Report/td-p/430403
Check page 5 of this PDF where they use a format statement to define the groups;
http://www.excursive.net/sas/ProcReportPaper.pdf
proc format;
value $Continent
'U.S.A.', 'CANADA'= 'NA'
'GERMANY' = 'EU';
run;
proc report data=smallprod
nowindows missing headline;
column country region predict actual;
define country / group format=$continent. width=7;
define region / group;
run;
prints:
Country Region PREDICT ACTUAL
-------------------------------------------
EU EAST 1,810.00 1,592.00
WEST 2,283.00 2,224.00
NA EAST 3,369.00 3,979.00
WEST 2,489.00 3,388.00
Probably need to do something like that for your brand/car groups and then use that format in "Define" and "Compute After".
Sorry, kind of lazy. marginally helpful response, but maybe it will be what you need.
... View more
