Proc report subtotal titles

yash82 — Wed, 28 Dec 2011 18:29:38 GMT

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

Proc report subtotal titles

NN — Wed, 28 Dec 2011 18:40:03 GMT

Hi,

I think Your compute block should be...

compute after sex;

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

endcomp;

topic Proc report subtotal titles in ODS and Base Reporting

Proc report subtotal titles

Proc report subtotal titles