Hi:
Like this:
With all the different colors the cell above Region didn't bother me, but with the lower headers all the same color, I think I like #1 better now. Note that for #2b, with helper variables, I had to make the helper variables in a separate DATA step program. Also, to get the cell above REGION a different color, some text had to be inserted into that cell so the color could be changed.
Cynthia
Here's the code I used for the above.
data shoes;
set sashelp.shoes;
regback='.';
otherback = 'Spanning Header';
numvar = 1;
run;
ods rtf file = "c:\temp\span_color.rtf";
proc report data=sashelp.shoes(obs=3)
style(header) = [background = lightblue];
title "alt 1) Only Spanning Header light blue AND cell above Region";
column region ('Spanning Header' subsidiary product sales inventory returns);
define region / style(header)={just=c background=lightyellow};
define subsidiary /style(header)={just=c background=lightyellow};
define product /style(header)={just=c background=lightyellow};
define sales / style(header)={just=c background=lightyellow};
define inventory / style(header)={just=c background=lightyellow};
define returns / style(header)={just=c background=lightyellow};
run;
proc format;
value $hdrf 'Region' = 'lightyellow'
'Subsidiary' = 'lightyellow'
'Product' = 'lightyellow'
'Total Sales' = 'lightyellow'
'Total Inventory' = 'lightyellow'
'Total Returns' = 'lightyellow'
'Spanning Header' = 'lightblue'
'~' = 'lightyellow'
other = 'white';
value $h2fm '~' = 'lightyellow';
run;
proc report data=sashelp.shoes(obs=3)
style(header)={just=c background=$hdrf. color=$h2fm.};
title "alt 2a) Use format for changing header backgrounds";
column ('~' region) ('Spanning Header' subsidiary product sales inventory returns);
define region / 'Region' ;
define subsidiary / 'Subsidiary';
define product / 'Product';
define sales / 'Total Sales';
define inventory / 'Total Inventory';
define returns / 'Total Returns';
run;
proc report data=shoes(obs=3);
title "alt 2b) Use 'helper' variables for changing header backgrounds";
column numvar regback,region otherback,(subsidiary product sales inventory returns);
define numvar / group ' ' noprint;
define regback / across ' ' style(header)={just=c background=lightyellow color=lightyellow};
define region / style(header)={just=c background=lightyellow};
define otherback / across ' ' style(header)={just=c background=lightblue};
define subsidiary /style(header)={just=c background=lightyellow};
define product /style(header)={just=c background=lightyellow};
define sales / style(header)={just=c background=lightyellow};
define inventory / style(header)={just=c background=lightyellow};
define returns / style(header)={just=c background=lightyellow};
run;
ods rtf close;
... View more