ODS RTF Proc Report Help.

[mcook]

Using the SASHELP.Class data set as an example.  

I have the following Code.  

 ods rtf file="C:\FilePath\TestRTF.rtf";
options nodate nonumber;
Title "Summary";

proc report data=SASHELP.Class
Style(Report) = [Frame=Below];
Column Sex Name Age Height Weight;
Define Sex / Group Center;
Define Name / Style(Column)=[CellWidth=0.75in] CENTER;
Define Age / Style(Column)=[CellWidth=0.75in] CENTER;
Define Height / Style(Column)=[CellWidth=0.75in] CENTER;
Define Weight / Style(Column)=[CellWidth=0.75in] CENTER;
run;
ods rtf close;

This outputs the following

How do I Remove the Row lines in the sex Column(Except the line separating F from M of course), and Vertically Center the F and M? 

as in the 'Usage' and 'Attributes' Rows in this table below (Ironically from a paper on how to use proc report).

Also.  Is it possible to remove only certain vertical lines?  For example.  Remove the Vertical Lines separating 'Name' from 'Age', and 'Age' from 'Height'.  While leaving the rest?

Any help appreciated.  

[data_null__]

You need PROC REPORT statement option SPANROWS.

[Reeza]

Line colours, width and spacing is controlled with the STYLE options.

[Cynthia_sas]

Hi:

  Is this what you need to produce?

Cynthia

[mcook]

I was able to remove specified vertical lines with borderleftcolor=white and borderrightcolor=white. But this leaves a small gap in the horizontal row lines, where the vertical line is now white.. I tried to put in borderbottomcolor=black to compensate, but it does not. Are those the style options you were referring to?

[ballardw]

As @data_null__ says SPANROWS to get the group variables in a single "cell". Style with Vjust (vertical justification) to center.

To remove one side of cell border you can set adjacent border widths to zero (need both as each cell draws its own border). If you want the border removed between the column headings you would remove the (column) part of the Style override, otherwise the Name and Age headers in the example below will still have the vertical line.

proc report data=SASHELP.Class SPANROWS
Style(Report) = [Frame=Below];
Column Sex Name Age Height Weight;
Define Sex / Group Center style=[Vjust=center] ;
Define Name / Style(Column)=[CellWidth=0.75in borderrightwidth=0] CENTER;
Define Age / Style(Column)=[CellWidth=0.75in borderleftwidth=0] CENTER ;
Define Height / Style(Column)=[CellWidth=0.75in] CENTER;
Define Weight / Style(Column)=[CellWidth=0.75in] CENTER;
run;

This will make any group variable span the rows though. So if you have multiple Group variables this might not be what you want.

[mcook]

I added your borderrightwidth and borderleftwidth=0 , but it does not get rid of the lines.
also tried borderrightwidth and borderleftwidth = 0pt. Still no change.

[mcook]

from https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsproc/p1pt77toue3iyun0z4l9gth5as9f.htm

BorderLeftWidth=Dimension

     specifies the width of the left border of the table or cell.

And Dimension is a whole number, a percentage, or nonnegative number followed by unit of measure

So Borderleftwidth=0  is not a valid dimension.  

[mcook]

oh wait. i read non negative as non zero. My fault.

I agree that borderleftwidth=0pt, or 0in, etc.. should work.

[Cynthia_sas]

Hi:

  Before you start playing with bordercolor and border width, I recommend experimenting with RULES, FRAME and CELLSPACING to see if that provides the look you want:

(All output ODS RTF -- same code as in previous screen shot with only style(report) overrides changed as shown.)

Cynthia

[mcook]

All of those seem to get rid of all interior lines. I only want to remove certain ones.

[Cynthia_sas]

Hi:
You're right. All of those get rid of interior lines because of the RULES=NONE override. There are other possible values for the RULES attribute. You can have RULES=NONE, as I show,. Also, RULES=ALL (the default), RULES=ROWS, RULES=COLS, and RULES=GROUPS. Those can be combined with the possible values for FRAME= to customize the look. Then, if none of those combinations can work for you, you can experiment with bordercolor and borderwidth.
Cynthia

[mcook]

Using Rules=Rows to to give me just the rows, and adding in manually all the vertical ones I want does get me closer to what i am looking for.  However not quite.  it leaves white spaces in the header where the missing vertical lines would go.  

here is my current code 

ods rtf file="FilesPath\TestRTF.rtf";
options nodate nonumber;

proc report data=SASHELP.Class spanrows

Style(Report) = [Rules=Rows Frame=HSides 
					pretext='Table1.1 Temp Title' Just=left
					font=('Times New Roman', 12pt, bold)];

Column Sex Name Age Height Weight;
Define Sex / Group Center style(column)=[Vjust=Center];
Define Name / style=[borderleftwidth=1pt] CENTER;
Define Age /  style=[borderrightwidth=1pt] CENTER ;
Define Height / Style(Column)=[CellWidth=0.75in] CENTER;
Define Weight / Style(Column)=[CellWidth=0.75in] CENTER;
run;
ods rtf close;

This outputs the below table.  How do remove the white vertical bars between name|age and height|weight?  

Much Appreciation.  

[Reeza]

Do you need to apply those to the HEADER as well as the REPORT?
Ie Style(HEADER) = .....

[Cynthia_sas · Accepted solution]

Hi:

  Remember that a cell has borders on ALL sides. So if you are going to change one border to be black, then you've got to change the other border to be the same as the background color (in this case, the color GRAYBB, which is the same as CXBBBBBB. This worked for me:

Cynthia