Hello everybody!
I have the following sample data:
DATA offenders;
INPUT group :$1. age :3. residenceStatus :$1. sex :$1.;
INFILE DATALINES DSD;
DATALINES;
A,10,A,m
A,14,A,m
A,11,B,m
B,21,A,w
B,20,B,m
B,,B,m
B,34,C,m
A,60,C,w
;
RUN;
PROC FORMAT;
VALUE agegrp 0-10 = "0-10"
11-20 = "11-20"
21-30 = "21-30"
31-40 = "31-40"
40-high = "41+"
. = "unknown";
RUN;
and the following proc tabulate:
PROC TABULATE;
class group;
class age / preloadfmt missing;
class residenceStatus;
TABLE group, residenceStatus * age;
FORMAT age agegrp.;
RUN;
How can I repeat all agegroups (0-10, 11-20, 21-30, unknown) for every residence status (A, B, C)?
I have experimented somewhat with "preloadfmt" but didn't get it to work properly. Thanks for help!