SAS ODS - Coloring Spanning Headers

Dob4Die — Thu, 04 Dec 2014 23:25:41 GMT

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;

Re: SAS ODS - Coloring Spanning Headers

Cynthia_sas — Fri, 05 Dec 2014 03:53:15 GMT

Hi:

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

cynthia.

Re: SAS ODS - Coloring Spanning Headers

Dob4Die — Sat, 06 Dec 2014 01:42:46 GMT

Thanks Cynthia , Will work with SAS technical support.

topic Re: SAS ODS - Coloring Spanning Headers in ODS and Base Reporting

SAS ODS - Coloring Spanning Headers

Re: SAS ODS - Coloring Spanning Headers

Re: SAS ODS - Coloring Spanning Headers