Hi Everyone,
This code below paint each line a color.
I use N=_N_ to keep track of the row.
Clearly, I don't want to print this column N in my report.
Is there any way to do it?
Thank you,
HHCFX
data have;
input name $ v1 v2 v3;
datalines;
a 1 2 1
a 3 4 0
b 4 5 0
b 3 5 0
b 1 1 1
c 1 1 0
c 0 0 1
;run;
data have; set have;
N=_N_;run;
proc report data=have nowd;
define name/display;
define v1/display;
define v2/display;
define v3/display;
define N/display;
compute N ;
IF N=1 then call define(_row_,'style','style={background=VLIGB}'); ELSE
IF N=2 then call define(_row_,'style','style={background=LIGGR}'); ELSE
IF N=3 then call define(_row_,'style','style={background=TAN}'); ELSE
IF N=4 then call define(_row_,'style','style={background=WHITE}'); ELSE
IF N=5 then call define(_row_,'style','style={background=VLIGB}'); ELSE
IF N=6 then call define(_row_,'style','style={background=LIGGR}'); ELSE
IF N=7 then call define(_row_,'style','style={background=TAN}');
endcomp;
run;
define N/order noprint;
define N/order noprint;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.