thanks for the suggestions - continued hunting around, and finally found a solution:
add MISSING in the Proc Report line, and NOZERO in the across lines
data a;
input grade type1 $ count1 type2a $ type2b $ count2;
cards;
1 A1 1 . . .
1 B1 1 . . .
1 C1 1 . . .
1 . . A2 A2a 1
1 . . A2 A2b 1
;
run;
proc report data=a missing;
columns ("Grade" grade) (type1,(count1)) (type2a, type2b,(count2));
define grade/' ' group;
define type1/' ' nozero across;
define count1/' ' sum;
define type2a/' ' nozero across;
define type2b/' ' nozero across;
define count2/' ' sum;
run;
... View more