BookmarkSubscribeRSS Feed
kathrin_r
Calcite | Level 5

Hi,

I'm currently facing problems with formatting a table in a rtf document produced with proc report.

The problem is that I would like to reduce the automatic calculated row height or the line spacing. Without any additional settings for the cell height my report looks like screenshot 1. As the proc report is used in a macro where the font size may be adjusted or also the text in column one might need to lines, I can not define a fixed cell height.

That's why I'm trying to adjust it with the cellpadding=0. If I do so, the cell height is fine but the problem is that the left and right cell margins are now to small (see screenshot2). How can I reduce the cell height without getting the problems with the left/right margin? Is there some way to adapt only the top/bottom cell margins?

Here an extract of my code

ods tagsets.rtf file="&outfile." style=journal;

  proc report data=&out. nowd  style(column)={  font_size=&fontsize.pt font=(Calibri)}

                           style(report)={ cellpadding=0  frame=box rules=cols   }
                           style(header)={ font_size=&fontsize.pt font=(Calibri) borderbottomwidth=2 borderbottomcolor=black };
   column  (" ^S={borderbottomcolor=white borderbottomwidth=2} Adverse event type"  event )
           ("N=&Npat."  n_perc   )  ;
   define  event/display " " style(column)=[asis=on];
   define  n_perc/ display "n (%)"  ;
run;

ods tagsets.rtf close;

ods listing;

Thanks for your help.

Kathrin


screenshot2.pngscreenshot1.png
3 REPLIES 3
Cynthia_sas
SAS Super FREQ

Hi:

  This is the type of question best answered by Tech Support. There may not be a way to do what you want, but the experts are there to help you figure it out.

cynthia

ballardw
Super User

increase borderrightwidth and/or borderleftwidth might work since the Journal style uses the border colors as the background color and don't show.

kathrin_r
Calcite | Level 5

Thanks for your answer. Unfortunately to increase the borderrightwidth will not solve my problem, as I want the column borders to be displayed (I use the rule=col option in the style).

Kathrin

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1125 views
  • 0 likes
  • 3 in conversation