Value keeps repeating after each break in PROC Report

[jlwatts]

Question.  I have existing code that I am trying to update.  It has the following:

The report is setup as:

PROC REPORT Data=Enroll_intl;
COLUMN college_desc1 NATION_OF_CITIZENSHIP_DESC break_group level group academic_period_Desc, (Heads fte) Fall2017 Fall2018 ChangeNo ChangePct Fall2017fte Fall2018fte ftechangeno ftechangepct;

And it has break setup as:

break after NATION_OF_CITIZENSHIP_DESC  / summarize dol dul style=[fontweight=bold];
COMPUTE after NATION_OF_CITIZENSHIP_DESC ;
NATION_OF_CITIZENSHIP_DESC=' ';
level='9';
ENDCOMP;

Is there a way to not have the college repeated with each break?  The user has the output in excel format.

[ballardw]

Complete procedure code and example input data in the form of a working data step will probably get a workable solution faster.

Complete code is needed because other pieces may be the cause of undesired output.

Is that example of actual output or desired output? If not of desired output then show what the desired appearance is.

[jlwatts]

That is the current output. I would like to not list the college name on
each total line.

[Kathryn_SAS · Accepted solution]

It would be helpful to see your code and how you are defining the variables on the Column statement. However, if you want to not repeat college_desc1 at the BREAK line, you can try the following:

compute college_desc1;
if upcase(_break_)='NATION_OF_CITIZENSHIP_DESC' then college_desc1=' ';
endcomp;

[jlwatts]

Thank you.  I will give that a try and let you know the result.

[jlwatts]

That worked.  I thank you for your time and effort.