The SAS Output Delivery System and reporting techniques

tagsets.excelxp style(header) background color

Accepted Solution Solved
Reply
Regular Contributor
Posts: 196
Accepted Solution

tagsets.excelxp style(header) background color

Currently the header background color (ie CXBBBFAC) is only shown for ydoi1, clm_num, bop_grp, and task.
Does anyone know why the header background color is not being displayed for oergo1, msd1, and fall1?
Everything else works as expected.

proc format;
value ydoif 2010="2010"
             2011="2011 YTD"
;
value $colorf 'Yes'='Yellow'
;
run;

ods tagsets.excelxp file="C:\file.xls"
style=journal
options(frozen_headers='1'
      autofit_height='yes'
      absolute_column_width='8,9,18,14,8,6,9'
   sheet_interval='none' sheet_name='Corp'
   embedded_footnote='yes')
;
proc report data=class5 nowd contents="Claims" out=test
style(header)=[font_weight=bold background=CXBBBFAC /*yellowish grey*/];
options missing='';
column ydoi1 clm_num task bop_grp oergo1 msd1 fall1;
define ydoi1 / '' format=ydoif. style(column)={font_weight=bold just=l};
define clm_num / 'Claim #' width=14 style(column)={just=l};
define task / 'Task';
define bop_grp / 'Body Part';
define oergo1 / 'Office' style={background=$colorf.};
define msd1 / 'MSD' style={background=$colorf.};
define fall1 / "STF" style={background=$colorf.};
compute clm_num;
  if clm_num = "" then call define(_row_,"style","style=[background=CXE599A7]" /*light pink*/);
endcomp;
run;


Accepted Solutions
Solution
‎07-25-2011 03:32 PM
Super Contributor
Posts: 394

tagsets.excelxp style(header) background color

In a define statement, by default the style option affects both the data rows and the header rows, so the style options on the define statements for oergo1, msd1, and fall1 override the style option on the proc statement. Change those style options to style(column) to match the style options on the other define statements.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146851.htm#a00053...

View solution in original post


All Replies
Solution
‎07-25-2011 03:32 PM
Super Contributor
Posts: 394

tagsets.excelxp style(header) background color

In a define statement, by default the style option affects both the data rows and the header rows, so the style options on the define statements for oergo1, msd1, and fall1 override the style option on the proc statement. Change those style options to style(column) to match the style options on the other define statements.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146851.htm#a00053...

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 673 views
  • 0 likes
  • 2 in conversation