SAS 9.3 (TS1M2)
Excel 2007 32-bit
Hi,
When I run the below code, I get a rouge cell at the end of the data (A21) which has a background color of gray instead of white. This is problematic when the worksheet is printed.
Do you get the same results? If so, any idea how to get SAS to play nicely?
Thanks,
Scott
ods _all_ close;
ods noresults;
ods noproctitle;
ods tagsets.excelxp
file="c:\temp\temp.xml"
style=statistical
options(
sheet_interval='none'
frozen_headers='yes'
autofilter='all'
);
ods tagsets.excelxp
options(
sheet_name='Class'
);
proc print data=sashelp.class noobs label
style(header)={
just=left
font_face="Marriott Light"
font_size=11pt
bordertopwidth=1
borderbottomwidth=1
borderleftwidth=1
borderrightwidth=1
}
style(data)={
font_size=10pt
font_face="Marriott Light"
bordertopwidth=1
borderbottomwidth=1
borderleftwidth=1
borderrightwidth=1
}
split='*'
;
run;
ods _all_ close;
ods listing;
Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.