merge cells horizontally in a proc report summary line

[ABurn]

I have the following proc report output (to RTF document). I have created little sub-heading rows using:

break before variable / summarize

I would like to merge the cells of the summary line horizontally (likde the Site name, n (%) row - done manually in Word) so I can make column 1 really small. The way it outputs at the moment is like the second summary row (Other, n (%)) which is all squished.

Is this possible? Or is there a way to make those rows act like headings?

I am using SAS 9.4 the desktop version

[ballardw]

Data

Code currently used

Likely you are looking for style override but what it might be I'm not going to guess without at least the current procedure code you are running.

Better is to include some DATA so we could run the code with example data.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

[Cynthia_sas · Accepted solution]

Hi:

  Without seeing your code and data, I'd recommend looking at a custom LINE statement at the break. Here's a paper that may help you understand how you can do that in a COMPUTE block: https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf .

Cynthia

[ABurn]

That paper is amazing and solved all my problems. Thank you so much!!!