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!