The SAS Output Delivery System and reporting techniques

Proc report subtotal titles

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

Proc report subtotal titles

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


Accepted Solutions
Solution
‎12-28-2011 01:40 PM
Regular Contributor
Regular Contributor
Posts: 166

Proc report subtotal titles

Hi,

I think Your compute block should be...

compute after sex;

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

endcomp;

View solution in original post


All Replies
Solution
‎12-28-2011 01:40 PM
Regular Contributor
Regular Contributor
Posts: 166

Proc report subtotal titles

Hi,

I think Your compute block should be...

compute after sex;

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

endcomp;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 664 views
  • 0 likes
  • 2 in conversation