topic Re: Color row in red in SAS Programming

Color row in red

Ronein — Wed, 03 Aug 2022 02:35:33 GMT

Hello
Let's say that I have a data set that included summary information by customers grade.

Let's say that there is a macro variable called colorgrade and the task is to color the row with the chosen grade in red color.

What is the way to do it please?

%let colorgrade=10;
Data have;
Input grade nr obligo2205 obligo2204;
Cards:
2 80000 200 220
3 70000 190 210
4 200000 400 370
5 250000 500 480
6 280000 520 510
7 180000 280 320
8 140000 210 215
9 90000 140 130
10 30000 90 92
;
Run;

Re: Color row in red

andreas_lds — Wed, 03 Aug 2022 05:34:11 GMT

It is not possible to change the background colour of a row in a dataset.

Edit: If you want a report, using proc report would be my first choice. There are many papers explaining how to change the background colour conditionally, i am sure you will find something adaptable to your issue.

Re: Color row in red

Ksharp — Wed, 03 Aug 2022 12:46:29 GMT

%let colorgrade=10;
Data have;
Input grade nr obligo2205 obligo2204;
Cards;
2 80000 200 220
3 70000 190 210
4 200000 400 370
5 250000 500 480
6 280000 520 510
7 180000 280 320
8 140000 210 215
9 90000 140 130
10 30000 90 92
;
Run;

proc report data=have nowd;
define grade/display;
compute grade;
if grade=&colorgrade. then call define(_row_,'style','style={background=red}');
endcomp;
run;