OK. I think you need to change the type of variable "Cylinders" to avoid the conflict with keyword "N" .
And try this one:
data have(keep=Make Model Cylinders);
set sashelp.cars;
if make in ('Mercedes-Benz') then output;
run;
proc sql;
insert into work.have
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8)
values("Mercedes-Benz", "E501", 8);
quit;
proc sort data=have;
by Make Model;
run;
proc format;
value $ mycol '12'='Yellow';
run;
data have;
set have;
_Cylinders=put(Cylinders,best. -l);
drop Cylinders;
run;
PROC TABULATE DATA=WORK.HAVE order=data;
CLASS _Cylinders Make Model;
classlev _Cylinders / s={background=$mycol.} ;
keyword N / s=< parent >;
keylabel all="Total";
TABLE
(Make * (Model all = 'Total' ) all = 'Total' ),
_Cylinders*n*{style=<parent>};
RUN;
... View more