Conditional format to rows with PROC PRINT or REPORT

pax — Wed, 12 Nov 2008 22:35:04 GMT

Is there an easy way conditionally to put a different format to the rows in output from PRINT or REPORT.
I.e. I would like to print all the rows where sex='F' with bold font and red background:

ods html style=sasweb;
proc print data=sashelp.class;
id name;
run;
ods html close;

Re: Conditional format to rows with PROC PRINT or REPORT

Cynthia_sas — Fri, 01 Oct 2021 11:52:40 GMT

Hi:
PROC PRINT allow you to perform traffic lighting on particular cells, while PROC REPORT allows you to perform row level conditional highlighting using the CALL DEFINE statement.

Some sample code is below.

ods html file='style_rept.html' style=sasweb; proc report data=sashelp.class nowd; title 'Conditional Row Highlighting'; column name sex age height; define name / order; define sex / display; define age /display; define height /display; compute sex; if sex = 'F' then do; call define(_ROW_,'style','style={background=red font_weight=bold}'); end; endcomp; run; ods html close;

cynthia

topic Conditional format to rows with PROC PRINT or REPORT in ODS and Base Reporting

Conditional format to rows with PROC PRINT or REPORT

Re: Conditional format to rows with PROC PRINT or REPORT