Hi all: Can someone please help me figure out how to remove the colored fill cells from this output (see snapshot attached)? I want to keep the background color for the table, but I don't want that extended every time I add a footnote or a title. ods Tagsets.ExcelXP FILE ="&output.\xxxxx.xml"
style = styles.mer options(sheet_name="xxxxx_#byval1" suppress_bylines='yes' AUTOFIT_HEIGHT='yes' Absolute_Column_Width="15,8,7,3,6,8,7,3,6,8,7,3,6" GRIDLINES='ON' FROZEN_HEADERS='YES'
contents = 'yes' index="No" embedded_titles='yes' embedded_footnotes='yes' title_footnote_nobreak='yes' );
**************************************************************;
/*CONTINUANCE - */
ods proclabel "Continuance";
title1 justify=left bold blank=yes Justify=left BCOLOR=white color=black "Continuance" ;
title2 justify=left bold blank=yes Justify=left BCOLOR=white "RC Level: #byval1";
footnote1 justify=left BCOLOR=white color=black "Report Produced on: &RunDayDateTime" ;
footnote3 blank=yes Justify=left BCOLOR=white color=black UNDERLIN= 2 link="#'Contents'!A1" 'Click to return to Table of contents';
PROC REPORT DATA=temp NOWD Contents=" ";
BY RATE_CLS NOTSORTED;
COLUMNS RATE_CLS (' ' COST_RANGE) YR_CAT,(MEMBERS x1 x2);
DEFINE RATE_CLS /GROUP 'Rate Cls' NOPRINT ;
DEFINE COST_RANGE/GROUP 'YTD Cumulative Spend';
DEFINE YR_CAT /ACROSS NOZERO ORDER=DATA ' ';
DEFINE MEMBERS/ 'Members' format=comma16. style(COLUMN)={tagattr="format:###,###,###"} ;
Define x1 ; Define X2;
RUN;
ods Tagsets.ExcelXP close;
ods listing ;
... View more
