Creating Spanning header Underline in proc report rtf

SASuserlot — Tue, 25 Jan 2022 19:27:24 GMT

Hi,

I am not able to create the underline under the 'Characteristics" header in the below Image. Can some body please tell me what I am doing wrong using the code '^R/RTF'\brdrb\brdrs' or is there another alternative to create these underlines. Thank you.

options orientation = landscape errors = 2 missing = ' ' nofmterr ls = 175 validvarname = upcase 

ods escapechar = '^';
ods results on; 
ods _all_ close; 
ods rtf file = "xx.rtf"  style = trtf_style; 


proc report data =SAShelp.class ls = 145 ps = 55  split = "?" headline center missing formchar(2) = '_'
			style(header)=[asis=on just=c /*fontweight=bold*/] style=[borderwidth=.2pt cellspacing=0.1pt cellpadding=0pt];
			** titles **;


	** report **;
	COLUMN  ("^R/RTF'\brdrb\brdrs '" Name 
						("characterstics ^R/RTF'\brdrb\brdrs '"  age height));

	define name     /  order = internal style(header) = [just=l] style(column) = [just=l  cellwidth=45.0% asis=on] id"name" ;
	define age      /  order = internal style(header) = [just=c] style(column) = [just=c  cellwidth=7.0% asis=on] "age" ;
    define height     /  order = internal style(header) = [just=c] style(column) = [just=c 	  cellwidth=8.5% asis=on] "height" ;                                         
	
	
		
ods rtf close;
ods listing close;
ods _all_ close;

Re: Creating Spanning header Underline in proc report rtf

Ksharp — Wed, 26 Jan 2022 12:15:11 GMT

I runed your code and get no problem .

Alternative way is using STYLE statement.

COLUMN  ( Name ("^S={borderbottomcolor=black borderbottomwidth=2} characterstics "  age height));

Re: Creating Spanning header Underline in proc report rtf

SASuserlot — Wed, 26 Jan 2022 14:48:58 GMT

Thanks. Your code worked for some reason my word file not showing underline when I used the 'RTF..." code. Thanks again.

topic Re: Creating Spanning header Underline in proc report rtf in SAS Programming

Creating Spanning header Underline in proc report rtf

Re: Creating Spanning header Underline in proc report rtf

Re: Creating Spanning header Underline in proc report rtf