topic Re: Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues in SAS Programming

Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues

SASuserlot — Mon, 25 Oct 2021 20:48:34 GMT

I am generating the tables using the proc report. I want to get a underline under the one of the 'Treatment' heading, I used this code " '"^R/RTF'\brdrb\brdrs' " in the column section however, it not generating the underline covering the treatments. I need an underline beneath the 'Treatment' covering all the treatments. Can you please suggest what I am doing wrong and other options to achieve it. Thanks.

This is the code I used in column section

column ("^R/RTF'\brdrb\brdrs '" sort col1 ("^R/RTF'\brdrb\brdrs' Treatment Group" trt1 trt2 trt3 trt4 ) );

This is the output it generating without 'underline' beneath the Treatment header.

Re: Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues

ballardw — Mon, 25 Oct 2021 22:22:24 GMT

@SASuserlot wrote:

I am generating the tables using the proc report. I want to get a underline under the one of the 'Treatment' heading, I used this code " '"^R/RTF'\brdrb\brdrs' " in the column section however, it not generating the underline covering the treatments. I need an underline beneath the 'Treatment' covering all the treatments. Can you please suggest what I am doing wrong and other options to achieve it. Thanks.

This is the code I used in column section
column ("^R/RTF'\brdrb\brdrs '" sort col1 ("^R/RTF'\brdrb\brdrs' Treatment Group" trt1 trt2 trt3 trt4 ) );
This is the output it generating without 'underline' beneath the Treatment header.

Because of the way many options interact in Proc Report it is suggested to always include the entire procedure code, not just one line. Especially not a line that doesn't work.

You might consider creating a dummy report appearance with a word processor or other program, creating an image of that appearance and sharing that as well. I pretty sure at this time that I do not know where you want "line".

Re: Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues

Ksharp — Tue, 26 Oct 2021 12:20:44 GMT

Try this one:

ods rtf file='c:\temp\temp.rtf' style=journal bodytitle;
proc report data=sashelp.class nowd;
columns name age ("(*ESC*)S={borderbottomcolor=black borderbottomwidth=2}Treatment Group"  weight height);
define name/display;
run;
ods rtf close;

Re: Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues

SASuserlot — Tue, 26 Oct 2021 12:56:35 GMT

Thanks for our response. I will try to post the sample code.

Re: Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues

SASuserlot — Tue, 26 Oct 2021 12:57:17 GMT

It worked Ksharp. Thank you very much.

Re: Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues

sps_sandy14 — Tue, 12 Jul 2022 07:15:00 GMT

Hi,

We need to assign border width for the line you need for that report

'"^R/RTF'\brdrb\brdrs\brdrw' "

that W is the width of the border ,give 3 for that "w"

'"^R/RTF'\brdrb\brdrs\brdr3' "

Now it will work.Kindly check and update your comment.

Re: Proc Report " '"^R/RTF'\brdrb\brdrs' " Issues

KevinViel — Wed, 31 Jan 2024 16:04:53 GMT

Similar to what Ksharp posted, I would consider an alternative, which might be more destination agnostic? I am presenting a macro at PHUSE US Connect 2024 in paper SM04 that covers some of this and how to get adequate spacing between multiple headers of columns headers. Consider:

`S={ borderbottomcolor = black
     borderbottomwidth = 1pt
     borderleftstyle   = none
     borderrightstyle  = none
   }

column page_order_1
       page_1
       section_order_1
       row_order_1
       row_1
       ( "`S={ borderbottomcolor = black borderbottomwidth = 1pt borderleftstyle = none borderrightstyle = none }Group 1`n(N = 10)"
         col1 
         col2
       )
       null1 
       ( "`S={ borderbottomcolor = black borderbottomwidth = 1pt borderleftstyle = none borderrightstyle = none }Group 2`n(N = 8)" 
         col3 
         col4 
       ) 
       null2 
       ( "`S={ borderbottomcolor = black borderbottomwidth = 1pt borderleftstyle = none borderrightstyle = none }All`n(N = 18)" 
         col5 
         col6
       ) 
       ;

I create the null_ variable using a compute block in REPORT and given them cellwidth = 0.25%. They are missing values and have no borders. A very important point is what TEMPLATE or STYLE overrides you employ.

HTH,

Kevin