Proc report subtotal titles

[yash82]

Hi there, I want to display subtotals as 'subtotals of  values'

I am refering following example

proc report data=sashelp.class nowd out=yy;

column sex age weight;

define sex / order;

break after sex/ol summarize;

            compute after sex;

                    sex='subtotal of sex';

            endcomp;

run;

But the problem here is I am getting subtotals label as 'Subtotals of sex' everywhere. But I am expecting it to be displayed as 'Subtotals of M' and 'Subtotals of F'

The reason I am stressing on using proc report only is I am getting the values of sex as macro variables from some other dataset.

Hope I am clear and making sense.

Any help is really appreciated

[NN · Accepted solution]

Hi,

I think Your compute block should be...

compute after sex;

sex=catt('Subtotal of",SEX);

endcomp;