BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ABurn
Fluorite | Level 6

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 versionCapture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ

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

View solution in original post

3 REPLIES 3
ballardw
Super User

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
SAS Super FREQ

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
Fluorite | Level 6
That paper is amazing and solved all my problems. Thank you so much!!!

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 3884 views
  • 1 like
  • 3 in conversation