Thanks again for your help. I've adapted the example you posted to create a sample dataset so that I can show outputs. Whatever I do though, I still get that same warning whenever I include both the MLF and PRELOADFMT options. WARNING: MLF conflicts with PRELOADFMT in class variable bucket. It is ignored Here is the code: data junk;
do i=1 to 50;
bucket = round(5*ranuni(1234)+.5);
osb = round(100*ranuni(1234)+.5);
output;
end;
run;
proc tabulate data = junk order=data;
class bucket / mlf preloadfmt;
classlev bucket / style=[asis=on];
var osb;
table bucket ALL,
(N*F=comma8. osb*F=NLMNLEUR20.2 PCTN*F=pctfmt8.2 PCTSUM*osb=""*F=pctfmt8.2)
ALL*(N*F=comma8. osb*F=NLMNLEUR20.2 PCTN*F=pctfmt8.2 PCTSUM*osb=""*F=pctfmt8.2)
/ BOX = "TEST";
label bucket = "" osb = "€";
keylabel N = "#" SUM = "" PCTN = "%#" PCTSUM = "%€" ALL = "Total";
format bucket bucketfmt.;
title "Test";
title2 "the Tester";
run; The proc format is still the same as before, since from the examples you posted it seems to be set up in the same way. As the warning says, the MLF option is ignored and the ouput contains neither the subtotal rows nor the rows for which there are no values (see picture).
... View more
