topic Re: How to indent rows in html in SAS Programming

How to indent rows in html

Guofeng — Fri, 14 Dec 2018 08:16:08 GMT

I'd like to indent some words when generate html files. For instance, there is column aecat as below shows:

data abc;

set a;

if aedecod ='' then aecat=aesoc;
else aecat="(*ESC*){unicode 007C}"||strip(aedecod);

run;

ods html file='xxxx/a.html';

proc report data=abc nowd;

column aecat;

define aecat/display;

run;

ods html close;

However, the unicode doesn't work. Could anybody help me? Thank you.

Re: How to indent rows in html

Kurt_Bremser — Fri, 14 Dec 2018 08:38:46 GMT

Try this:

data abc;
set a;
if aedecod = ''
then aecat = aesoc;
else aecat = "  " || strip(aedecod);
run;

ods html file='xxxx/a.html';

proc report data=abc nowd;
column aecat;
define aecat/display style(column)={asis=on};
run;

ods html close;

Idea taken from https://communities.sas.com/t5/ODS-and-Base-Reporting/Preserve-Leading-Blanks-in-ODS-Output/td-p/1935, which is the first hit of a google search (Maxim 6) for "leading blanks in proc report".

Re: How to indent rows in html

Cynthia_sas — Fri, 14 Dec 2018 14:49:47 GMT

Hi:

This previous posting showed one technique for RTF and PDF:

https://communities.sas.com/t5/SAS-Programming/Proc-report-help/td-p/327126

The only difference is that for HTML, you need to use INDENT= instead of LEFTMARGIN=, as shown below:

Cynthia

Re: How to indent rows in html

Guofeng — Mon, 17 Dec 2018 06:56:45 GMT

Hi KurtBremser, thank you for your advice. Yes, it can indent by this way. However, the outcome appearance is not good: there are unnecessary frame for the indent words.(already highlighted as yellow)

Re: How to indent rows in html

Guofeng — Mon, 17 Dec 2018 08:52:55 GMT

Hi Cynthia, Thank you so much for your detail explain. It's so wonderful~ This is the best way to intent word if previous group like Region is just used for group (no need to summary by region).