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;
... View more