I am using the tagsets.excelxp destination to write PROC PRINT output to
an Excel file. I have been asked to set the header information
(variable labels) in Row 1 of the Excel file to have a background color
of yellow for columns 1-9 and a background color of blue for the rest of
the columns. Using the code below, I was able to STYLE the header to
set the background color to yellow for the whole file - but I need some
suggestions on how to set 2 different colors in the header.
Could I set the whole header to blue using the method below, then
override the color somehow for columns 1-9? Thanks for any ideas.
ods tagsets.excelxp file = "C:\filename.xls" style = minimal
proc print data = excelrpt noobs label
var blank1-blank9 medrecno medrec birthdat ssn lastnm firstnm currid
recipno elgbegdt elgenddt covgroup
covtype county age begdos enddos billpaydt prov provnpi provname
hosp source mco mconame;
ods tagsets.excelxp close;
Senior Research Analyst
University of Maryland, Baltimore County
Sondheim Hall, 3rd Floor
1000 Hilltop Circle
Baltimore, MD 21250
Please consider the environment before printing this e-mail and/or any attachments.
Confidentiality Notice: This e-mail may contain information that is legally privileged and that is intended only for the use of the addressee(s) named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying of this e-mail, distribution, or action taken in reliance on the contents of this e-mail and/or documents attributed to this e-mail is strictly prohibited. If you have received this information in error, please notify the sender immediately by phone and delete this entire e-mail. Thank you.