I've tried to mimick your example code to my situation and included a copy of error log, see below. It still is not formatting the specific columns qbo 'OKC Total' the color shade I'm requesting in the code? I don't understand why -- I was thinking I have been referencing the attribute incorrectly -- thats why I was asking how to reference the column attribute? All I know is its still not working -- I'm a beginner at this so any other hints are very much appreciated!
ods tagsets.excelxp file="I:\FINANCE\QShare\2010\Stmt201010s\GLTrialBal.xml" style=minimal
options(sheet_name='GLBAL'
sheet_interval='proc'
frozen_headers='1'
autofit_height='yes'
absolute_column_width='5,4,25,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9'
autofilter='yes');
proc report data=GLBAL NOWD
style(header)={ BACKGROUND = yellow
FONT_WEIGHT = bold}
style(column)={BACKGROUND = PINK};
COLUMN EXCa EXCm DESC b1 b11 qbo b9 b2 b3 b62 b63 b67 qbs qbt b12 b27 b14 b25 bqet b16 b76 b78 bqgm b75 bal b77 b79;
define qbo / 'OKC Total' style(header)={background = CX90D9D7}
style(column)={background = CX90D9D7}; /*OKC Total*/
define QBS / 'Uinta Total' style(header)={background = CX90D9D7}
style(column)={background = CX90D9D7}; /*QEP Uinta*/
define QBT / 'QEP Total' style(header)={background = CXB1E599}
style(column)={background = CXB1E599}; /*Total QEP*/
define bqet / 'QET Total' style(header)={background = CXB1E599}
style(column)={background = CXB1E599}; /*QET Total*/
define bqgm / 'QGM Total' style(header)={background = CXB1E599}
style(column)={background = CXB1E599}; /*QGM Total*/
define BAL / 'QMR Total' style(column)={background = CXB1E599}
style(column)={background = CXB1E599}; /*QMR Total*/
define _NUMERIC_ / style={tagattr='format:#,##0.00_);[Red](#,##0.00)'};
run;
Error Log
326 dm 'log' clear;
3327 dm 'odsresults' clear;
3328 *ODS tagsets.excelxp file="c:\test.xml" options(doc="help");
3329
3330 * Tells SAS where to find the ExcelXP tagset;
3331 ods tagsets.excelxp file="I:\FINANCE\QShare\2010\Stmt201010s\GLTrialBal.xml" style=minimal
3332 options(sheet_name='GLBAL'
3333 sheet_interval='proc'
3334 frozen_headers='1'
3335 autofit_height='yes'
3336 absolute_column_width='5,4,25,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9'
3337 autofilter='yes');
NOTE: Writing TAGSETS.EXCELXP Body file: I:\FINANCE\QShare\2010\Stmt201010s\GLTrialBal.xml
NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.116, 08/25/10). Add options(doc='help') to the ods statement for more information.
3338
3339 proc report data=GLBAL NOWD
3340 style(header)={ BACKGROUND = yellow
3341 FONT_WEIGHT = bold}
3342 style(column)={BACKGROUND = PINK};
3343 COLUMN EXCa EXCm DESC b1 b11 qbo b9 b2 b3 b62 b63 b67 qbs qbt b12 b27 b14 b25 bqet b16 b76 b78 bqgm b75 bal b77 b79;
3344 define qbo / 'OKC Total' style(header)={background = CX90D9D7}
3345 style(column)={background = CX90D9D7}; /*OKC Total*/
3346 define QBS / 'Uinta Total' style(header)={background = CX90D9D7}
3347 style(column)={background = CX90D9D7}; /*QEP Uinta*/
3348 define QBT / 'QEP Total' style(header)={background = CXB1E599}
3349 style(column)={background = CXB1E599}; /*Total QEP*/
3350 define bqet / 'QET Total' style(header)={background = CXB1E599}
3351 style(column)={background = CXB1E599}; /*QET Total*/
3352 define bqgm / 'QGM Total' style(header)={background = CXB1E599}
3353 style(column)={background = CXB1E599}; /*QGM Total*/
3354 define BAL / 'QMR Total' style(column)={background = CXB1E599}
3355 style(column)={background = CXB1E599}; /*QMR Total*/
3356 define _NUMERIC_ / style={tagattr='format:#,##0.00_);[Red](#,##0.00)'};
3357 run;
NOTE: There were 1686 observations read from the data set WORK.GLBAL.
NOTE: PROCEDURE REPORT used (Total process time):
real time 19.92 seconds