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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: