topic Re: underline one of the label word in proc report column statement in SAS Programming

underline one of the label word in proc report column statement

Sami1234 — Fri, 21 Dec 2018 00:59:37 GMT

Hi there,

Wondering if someone can help me with how to underline 'including and 'excluding' word in col1 col2 from the proc report code below.

Proc Report Data=abc nowd headline split='!';

column col1 col2 col3 ;

define col1 / ' ' flow width=20;

define col2 / 'Total including A' display flow width=25;

define col3/ 'Total excluding A' display flow width=25;

Thanks,

Sam

Re: underline one of the label word in proc report column statement

ChrisNZ — Fri, 21 Dec 2018 01:40:30 GMT

If you output to HTML, having start and end tags guarantees that inner tags are conserved.

proc Report Data=SASHELP.CLASS nowd headline split='!';
  column AGE SEX ;
  define AGE / '<a>Total <u>including</u> A</a>' ;
  define SEX / group;
run;

Total including A	Sex
119	F
134	M

Re: underline one of the label word in proc report column statement

Sami1234 — Fri, 21 Dec 2018 09:29:53 GMT

Thanks for the reply!

It's not working as the output file required is PDF & RTF.

Would it be anyway to display the underline for the rtf and pdf outputs, please?

Many thanks,

Sam

Re: underline one of the label word in proc report column statement

Sami1234 — Fri, 21 Dec 2018 11:18:05 GMT

Following code is creating a line for the RTF output, but not in PDF output.

Wondering if any trick to do so in PDF or lst file.

ods rtf file=…….;

ods escapechar=’^’;

proc report data=SASHELP.CLASS nowd headline split='!';

column AGE SEX;

define AGE / “Total ^ul including ^ul0 A';

define SEX / group;

run;

ods rtf close;

Re: underline one of the label word in proc report column statement

ballardw — Fri, 21 Dec 2018 16:42:10 GMT

You may be looking for text decoration

"^{style [textdecoration=underline]your text }

you will have to turn the decoration off after your value.