Your SAS programs, embedded in web apps and elsewhere

How to put computed variables into a report summary section

Reply
N/A
Posts: 0

How to put computed variables into a report summary section

In a new report I've just made, in a stored process, I want to summarize data per academic year, per campus, per ethnic group. Everything is working well, except for one little piece.

I am able to subtotal by campus, and get a subtotal line for the campus with no problem, that says, "Total CMP " ||college;

However, although I am also able to subtotal by year, the year itself does not show. It should say, Total " || YR_Range; but the computed value, YR_Range, does not show up. I get totals, but the value of the YR_Range does not show.
:
Here is the code I am using, and just can't figure out what causes the YR_Range value to not show.

break after flag/summarize;

compute after flag;
POSITION_EMPLOYEE_CLASS_DESC = "Total " || YR_Range;
yr_range = ' ';
college = ' ';
line ' ';
endcomp;

compute after college;
POSITION_EMPLOYEE_CLASS_DESC = "Total CMP " ||college;
college=' ';
yr_range = ' ';
endcomp;

break after college /summarize;
Rbreak after / summarize style={background=darkgray FONT_WEIGHT=BOLD };
compute after;
POSITION_EMPLOYEE_CLASS_DESC = "Grand Total " ;
line 'Total Empls. ' N;
endcomp;
run;

Can anyone explain why one value shows but the other one doesn't? Thanks so much in advance!
N/A
Posts: 0

Re: How to put computed variables into a report summary section

Never mind....I got it fixed. Thank you.
Ask a Question
Discussion stats
  • 1 reply
  • 159 views
  • 0 likes
  • 1 in conversation