topic merge cells horizontally in a proc report summary line in SAS Procedures

merge cells horizontally in a proc report summary line

ABurn — Tue, 15 Oct 2019 03:01:48 GMT

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

Re: merge cells horizontally in a proc report summary line

ballardw — Tue, 15 Oct 2019 15:33:09 GMT

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-data-AKA-generate/ta-p/258712 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.

Re: merge cells horizontally in a proc report summary line

Cynthia_sas — Tue, 15 Oct 2019 19:53:43 GMT

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

Re: merge cells horizontally in a proc report summary line

ABurn — Tue, 15 Oct 2019 23:35:47 GMT

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