I want to make a table in report format showing results for individuals in two groups and then also means by group. I would like the means for each group to be listed directly under the individual results for that group.
When I do this in SAS (not EG), using proc tabulate, the means are displayed directly under each group. However, when I do this in EG and output in SAS Report format, the means for the two groups are listed at the bottom of the table. Why is this? If I change the output to RTF, the means are displayed as I want them. Is there any way to change this?
Below is the code:
PROC TABULATE
DATA=WORK.CS;
VAR Depression;
CLASS Day / ORDER=UNFORMATTED MISSING;
CLASS group/ ORDER=UNFORMATTED MISSING;
CLASS id / ORDER=UNFORMATTED MISSING;
TABLE /* Row Dimension */
group_name*( id ALL={LABEL='Total'}) ALL={LABEL='Total'},
/* Column Dimension */
Day* Depression={LABEL=' '}* Sum={LABEL=' '}*F=2.0 ; ;
RUN;