topic Re: Value keeps repeating after each break in PROC Report in SAS Programming

Value keeps repeating after each break in PROC Report

jlwatts — Tue, 30 Sep 2025 16:38:29 GMT

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.

Re: Value keeps repeating after each break in PROC Report

ballardw — Tue, 30 Sep 2025 18:03:14 GMT

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.

Re: Value keeps repeating after each break in PROC Report

Kathryn_SAS — Tue, 30 Sep 2025 18:38:45 GMT

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;

Re: Value keeps repeating after each break in PROC Report

jlwatts — Tue, 30 Sep 2025 18:47:22 GMT

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

Re: Value keeps repeating after each break in PROC Report

jlwatts — Tue, 30 Sep 2025 19:16:01 GMT

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

Re: Value keeps repeating after each break in PROC Report

jlwatts — Tue, 30 Sep 2025 19:23:02 GMT

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