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
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
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.
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.