BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

Hello

I want to color Female rows.

I don't want to display column "SEX"  in proc report.

If I type  define sex / noprint;

then the rows are not colored .

What is the way to do it please?

 

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;
2 REPLIES 2
PaigeMiller
Diamond | Level 26
	define sex / display noprint;

--
Paige Miller
Ksharp
Super User

I tested the statment "define sex / noprint;" and didn't get any problem .

 

Ksharp_0-1685964961440.png

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 492 views
  • 0 likes
  • 3 in conversation