Color a row but not print a column

hhchenfx — Wed, 27 Mar 2019 01:36:12 GMT

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;

Re: Color a row but not print a column

hhchenfx — Wed, 27 Mar 2019 02:03:26 GMT

define N/order noprint;

topic Re: Color a row but not print a column in SAS Programming

Color a row but not print a column

Re: Color a row but not print a column