topic Re: ODS RTF Proc Report Help. in SAS Programming

ODS RTF Proc Report Help.

mcook — Tue, 05 Oct 2021 20:43:32 GMT

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.

Re: ODS RTF Proc Report Help.

data_null__ — Tue, 05 Oct 2021 20:52:54 GMT

You need PROC REPORT statement option SPANROWS.

Re: ODS RTF Proc Report Help.

Reeza — Tue, 05 Oct 2021 20:56:39 GMT

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

Re: ODS RTF Proc Report Help.

Cynthia_sas — Tue, 05 Oct 2021 23:33:52 GMT

Hi:

Is this what you need to produce?

Cynthia

Re: ODS RTF Proc Report Help.

ballardw — Tue, 05 Oct 2021 23:35:30 GMT

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.

Re: ODS RTF Proc Report Help.

mcook — Wed, 06 Oct 2021 12:24:43 GMT

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?

Re: ODS RTF Proc Report Help.

mcook — Wed, 06 Oct 2021 13:04:29 GMT

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.

Re: ODS RTF Proc Report Help.

mcook — Wed, 06 Oct 2021 14:20:02 GMT

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.

Re: ODS RTF Proc Report Help.

mcook — Wed, 06 Oct 2021 14:22:01 GMT

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

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

Re: ODS RTF Proc Report Help.

Cynthia_sas — Wed, 06 Oct 2021 14:41:57 GMT

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

Re: ODS RTF Proc Report Help.

mcook — Wed, 06 Oct 2021 17:16:40 GMT

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

Re: ODS RTF Proc Report Help.

Cynthia_sas — Wed, 06 Oct 2021 17:45:04 GMT

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

Re: ODS RTF Proc Report Help.

mcook — Wed, 06 Oct 2021 20:19:42 GMT

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.

Re: ODS RTF Proc Report Help.

Reeza — Wed, 06 Oct 2021 20:23:37 GMT

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

Re: ODS RTF Proc Report Help.

Cynthia_sas — Wed, 06 Oct 2021 23:59:57 GMT

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

Re: ODS RTF Proc Report Help.

mcook — Thu, 07 Oct 2021 12:09:02 GMT

Ah yes, that is exactly what I want. And it was actually the first thing i was going to try this morning. But it just seemed a long, piecemeal way to go about it. I was assuming SAS would have a more generalized way to accomplish it. But if not, this does the trick. Thank you so much.

Re: ODS RTF Proc Report Help.

Reeza — Thu, 07 Oct 2021 14:57:39 GMT

You can put a style(header) on your PROC REPORT line, but because you're controlling the colors of each column individually in this case you cannot simplify it. Basically when you want options to control all the details, then you have to specify all the details 🙂