topic Re: Color coding for title part in SAS Programming

Color coding for title part

112211 — Thu, 30 Jan 2025 09:29:23 GMT

I need color coding, as mentioned in the title section

Proc report data = sashelp.class ;

column name age sex weight height ;

run;

Re: Color coding for title part

yabwon — Thu, 30 Jan 2025 09:33:19 GMT

See these:

1) https://support.sas.com/resources/papers/proceedings11/290-2011.pdf

2) https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/142-31.pdf

and

3) https://www.lexjansen.com/wuss/2006/tutorials/TUT-Carpenter.pdf

Bart

Re: Color coding for title part

112211 — Thu, 30 Jan 2025 09:43:17 GMT

Thanks for replay
I have gone through all those PDFs, but I'm not getting.

Re: Color coding for title part

Amir — Thu, 30 Jan 2025 09:53:55 GMT

Hi,

So that people can more easily help you, please share 4 more things:

The code you have tried.
The result you received.
The result you want.
The SAS log, if there any issues reported in it.

Thanks & kind regards,

Amir.

Re: Color coding for title part

ballardw — Thu, 30 Jan 2025 13:14:25 GMT

Color code what?

"Title" is normally part that goes before a report in SAS so coloring age doesn't make much sense in relation to "title".

To color a value based the value we need to know exactly what to color.

This example colors the background of cell that has the age.

proc format ;
value agecolor
11 = 'Yellow'
12, 13 =  'Red'
14, 15 = 'Black'
;
run;

Proc report data = sashelp.class ;
   column  name age sex weight height ;
   define name / group;
   define age / style=[background=agecolor.];

run;

Re: Color coding for title part

Tom — Thu, 30 Jan 2025 14:12:13 GMT

If I run your code I do not get any TITLE printed (unless I had previous run a TITLE statement).

Do you mean you want to change the colors of the column headers in your report?

You can do that with the STYLE option on the DEFINE statement in PROC REPORT.

proc report data = sashelp.class ;
  column  name age sex weight height ;
  define name / style(header)={backgroundcolor=red};
run;

Re: Color coding for title part

Ksharp — Fri, 31 Jan 2025 02:59:32 GMT

data class;
 set sashelp.class;
 length x $ 80;
 if age in (11:14) then x=cats('(*ESC*){style [foreground=yellow fontsize=2 fontweight=bold]||||||||}age_',age);
 else x=cats('(*ESC*){style [foreground=red fontsize=2 fontweight=bold]||||||||}age_',age);
 keep name age x;
 run;
ods excel file='c:\temp\temp.xlsx';
 proc report data=class nowd ;
 run;
ods excel close;

data class;
 set sashelp.class;
 length x $ 80;
 y='||||||||'; x=cats('age_',age);
 keep name age y  x;
 run;
ods excel file='c:\temp\temp.xlsx';
 proc report data=class nowd ;
 column name age y x;
 define age/display;
 compute y;
 if age in (11:14) then call define(_col_,'style','style={background=yellow foreground=yellow}');
  else  call define(_col_,'style','style={background=red foreground=red}');
 endcomp;
 run;
ods excel close;