For example, here is my code:
proc freq data=basedata1;
table satcat*apply/nocol norow nopercent missprint;
where hold=1 and reside=1;
format satcat satcat.;
run;
Output:
Table of SATCat by APPLY
SATCat APPLY(apply) Total
1.00
1000-1090 8 8
<1000 165 165
Total 173 173
What I want to do is have the output table also include the other values of the variable SATcat in which there are no observations(in this particular subset of the data) so that the output looks something like this:
Table of SATCat by APPLY
SATCat APPLY(apply) Total
1.00
>1200
1100-1190
1000-1090 8 8
<1000 165 165
Total 173 173
(Other tables I produce use similar variables and subset the data differently so that I end up with observations in all the levels of SATcat and I'm trying to make all of my tables look the same.)
Any ideas? I would also love to know if this can be done in PROC Tabulate as well.