PROC REPORT - Suppressing one order variable label when computing total for a second order variable

[crichmond410]

Hi all,

I am new to proc report and am having trouble finding an answer to the below. I am in enterprise v8.5.

I have output that looks like this:

I want to add two types of "total" summary rows - one for sub locations and one for parent location. When I do so, it looks like this:

I would like to remove the labels in red, as those rows are the totals for the sub location rather than the parent location, and ideally keep all cells for the parent location merged together until the final "Total Parent 1" row, so that it looks like this:

Is this possible? My code is below.

proc report data=disc spanrows headline headskip split="|";
define ParentLocation / order center;
define SubLocation / order center;
define DataPtA / display "Data|Pt A";
define DataPtB / display "Data|Pt B";
column ("Location" ParentLocation SubLocation)
  DataPtA DataPtB;

break after ParentLocation / summarize;
  compute after ParentLocation;
    ParentLocation="Total " || ParentLocation;
    call define (_row_,'style', 'style=[font_style=bold]');
  endcomp;

break after SubLocation / summarize;
  compute after SubLocation;
    SubLocation="Total " || SubLocation;
    call define (_row_,'style', 'style=[font_style=italic]');
  endcomp;

run;

Thank you!

[PaigeMiller · Accepted solution]

This method puts text on reports where there is none, but the same thing ought to work for removing text that you don't want.

Solved: PROC REPORT, can you place descriptive text in a BREAK or RBREAK row? - SAS Support Communit...

[crichmond410]

Ah, easy fix, thank you! I needed to add the following to my sub location compute: SubLocation="";