topic Re: ODS EscapeChar style not work in html in SAS Programming

ODS EscapeChar style not work in html

Blaine7 — Tue, 14 Mar 2023 07:21:08 GMT

I want to left justify one of my column header when running proc report. I refer to the question here:https://communities.sas.com/t5/ODS-and-Base-Reporting/How-Can-I-Make-Header-Justified-Left-Partially-by-Using-PROC/m-p/563424#M22814. It is quite familiar to my question. One difference is I want to output a html. The solution works for rtf and pdf. Not works for html.

Here is my example code:

data test;
length column1-column3 $200.;
column1="aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"; column2="bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb "; column3="cccccccccccccccccccccccccccccccccccccccccccccccccc "; output;
run;

ods html file="****";
ods escapechar='~';
proc report data=test nowindows style(header)={just=c};
column ('aaaaa' column1 ('~S={just=l} bbbb' column2) ('~S={just=r} cccc' column3));
define column1 / display;
define column2 / display;
define column3 / display;
run;
ods HTML close;

Any suggestion would be appreciated.

Re: ODS EscapeChar style not work in html

Hao_Luo — Tue, 14 Mar 2023 08:12:59 GMT

This may works:

ods escapechar='~';
proc report data=test nowindows style(header)={just=c};
column ('aaaaa' column1 ('~S={just=l width=300%}bbbb' column2) ('~S={just=r width=300%}cccc' column3));
define column1 / display;
define column2 / display;
define column3 / display;
run;

Have no idea about the reason and feel pity about that. I may back to complete this.

Re: ODS EscapeChar style not work in html

Blaine7 — Tue, 14 Mar 2023 08:24:11 GMT

Hi Luo, thanks for your response. I didn't see any difference with the code you provided. Did that work on your SAS console?

Re: ODS EscapeChar style not work in html

Hao_Luo — Tue, 14 Mar 2023 08:28:56 GMT

Yes, I am using SAS 9.4 TS1M8.

Re: ODS EscapeChar style not work in html

Hao_Luo — Tue, 14 Mar 2023 08:29:51 GMT

Just a quick try in SAS EG, this trick failed >_<

Re: ODS EscapeChar style not work in html

Blaine7 — Tue, 14 Mar 2023 08:33:25 GMT

Yes. I am using SAS studio and it failed either.

Re: ODS EscapeChar style not work in html

Ksharp — Tue, 14 Mar 2023 12:47:26 GMT

Try Traffic Light Format.

data test;
length column1-column3 $200.;
column1="aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"; column2="bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb "; column3="cccccccccccccccccccccccccccccccccccccccccccccccccc "; output;
run;

proc format;
value $ fmt
'bbbb'='l'
'cccc'='r'
other='c'
;
run;

ods escapechar='~';
proc report data=test nowindows style(header)={just=$fmt. };
column ('aaaaa' column1 ('bbbb' column2) ('cccc' column3));
define column1 / display;
define column2 / display;
define column3 / display;
run;

Re: ODS EscapeChar style not work in html

Blaine7 — Tue, 14 Mar 2023 13:48:19 GMT

It works. Thanks a lot.