I have a proc report with group, across and an analysis variable. Furthermore there is a break and an rbreak. All this works well. Now I'd like to add an additional row after each break. Yet I don't want to do this with the line statement but in a way so that there are all individual cells for each column like in a break statement. You can think of this wished-for line like a break statment which however contains any computation that I want and not only a summary.
thanx for your great answer. Still there are two things which don't work.
First: the newly computed "summary" line appears before the other break. I'd like to have that after the other break. Changing orders in the column statement however doesn't do the trick as the computed summary line then appears somewhere completely different (after each change of value for the second group variable - mygroupfield2).
Second: doing any computation doesn't work either. It is ignored and the same values as in the other break statement are displayed.
Here is my code:
/* add the helping variable to later display the computed break line */
Usind myvalues.sum in the compute after myhelp doesn't work unfortunately. I get the error
ERROR: The variable type of MYVALUES.SUM is invalid in this context.
ERROR: Illegal reference to the array MYVALUES.SUM.