Continuation to this Discussion : .
I have ran the code provided cynthia (Find code below) on windows SAS 9.3 and on Enterprise guide with SAS 9.4 . On both , it worked perfectly.
Same code ran on SAS GRID (Linux) environment , the color coding from PROC FORMAT not working. If I hard code color value in style statement (Style(header) = { background = RED font_size= 10pt}; its working fine . For some reason on Linux environment PROC FORMAT values not working in this statement (Style(header) = { background = $color. font_size= 10pt};.
Couldn't find any documentation about it online ?
Thanks much in advance.
proc format;
value $color
'REPORT' = '#9999FF'
'Australia' = '#FF6600'
'States' = 'pink'
'Wombat' = 'lightgreen'
other = 'lightblue';
value $altclr
'REPORT' = '#9999FF'
'Australia' = '#FF6600'
'States', 'Height', 'Weight' = 'pink'
'Wombat', 'Name', 'Age', 'Sex' = 'lightgreen'
other = 'lightblue';
run;
ods listing close;
ods tagsets.excelxp file = 'c:\temp\report.xml'
options ( embedded_titles='yes') style = sansprinter;
proc report data = sashelp.class(obs=3) nowd
style(header) = { background = $color. font_size= 10pt};
title 'All Headers Different Colors Based on Formats';
column ('REPORT'('Australia' ('Wombat' name age sex )('States' height weight)));
run;
proc report data = sashelp.class(obs=3) nowd
style(header) = { background = $altclr. font_size= 10pt};
title 'Some Headers Same Colors Based on Formats (one header diff)';
column ('REPORT'('Australia' ('Wombat' name age sex )('States' height weight)));
define name / 'Name';
define age / 'Age';
define sex / 'Sex';
define height / 'Height';
define weight / 'Weight' style(header)={background=lightyellow};
run;
ods _all_ close;
Hi:
If it doesn't work in Grid, but does work elsewhere, then that is a question for Tech Support.
cynthia.
Thanks Cynthia , Will work with SAS technical support.
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.