topic Re: Print a table with a column highlighted background in SAS Programming

Print a table with a column highlighted background

hhchenfx — Fri, 16 Nov 2018 22:42:57 GMT

Hi Everyone,

I want to print table sashelp.class with column AGE highlighted with yellow background.

Can anyone help me to do it?

Thank you,

HHCFX

Re: Print a table with a column highlighted background

Reeza — Fri, 16 Nov 2018 22:50:39 GMT

proc report data=sashelp.class;
columns name age sex weight height;
define name / display;
define age / style=[background=yellow];
define sex / display;
define weight/ format=8.1;
define height/ format=8.1;
run;quit;

More complicated options are here:

http://www2.sas.com/proceedings/forum2008/224-2008.pdf

@hhchenfx wrote:

Hi Everyone,

I want to print table sashelp.class with column AGE highlighted with yellow background.

Can anyone help me to do it?

Thank you,

HHCFX

Re: Print a table with a column highlighted background

Cynthia_sas — Sat, 17 Nov 2018 01:11:26 GMT

Hi:

And a variation, if you want to be able to style the header cell separately from the data cells.

proc report data=sashelp.class;
columns name age sex weight height;
define name / display;
define age / style(header)={background=yellow font_style=italic}
             style(column)={background=lightblue};
define sex / display;
define weight/ format=8.1;
define height/ format=8.1;
run;
quit;

Cynthia