SAS ODS - Coloring Spanning Headers

[Dob4Die]

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;

[Cynthia_sas]

Hi:

If it doesn't work in Grid, but does work elsewhere, then that is a question for Tech Support.

cynthia.

[Dob4Die]

Thanks Cynthia , Will work with SAS technical support.