Hi:
Hmmm -- I never see the footnote start in Column B. When I run this code -- slightly altered from your version:
[pre]
data test;
length site_no $20;
set sashelp.class;
if sex = 'F' then site_no = put(age,2.0)||put(int(height),2.0)||'001';
else if sex = 'M' then site_no = put(age,2.0)||put(int(height),2.0)||'002';
run;
ods listing close;
ods html file='html4.xls' style=sasweb;
ods msoffice2k file='mso.xls' style=sasweb;
ods html3 file='html3.xls' style=sasweb;
proc report data=test nowd;
title1 'The Default Title';
title2 h=14pt j=l c=red 'RED' j=c c=blue 'BLUE' j=r c=green 'GREEN';
footnote1 j=l c=black h=14pt "Run Date: &sysdate9.";
Column site_no;
define site_no /'Site #'
style(column)={background=white foreground=black font_face='Ariel' font_size=8pt
htmlstyle="mso-number-format:\@"}
style(header)={foreground=black background=white font_face='Ariel' font_size=10pt};
run;
ods _all_ close;
[/pre]
This is what I observe:
--HTML (HTML 4.0 tags): Title 1 starts in Row1, colA; title2 uses multiple cells on one line; footnote starts in column A; site_no is text in Excel
--MSOFFICE2K (Microsoft HTML tags): Title1 appears in Row 1, centered above table; title2 uses 3 lines; footnote starts in column A; site_no is text in Excel
--HTML3 (HTML 3.2 tags): Title starts in Row 2, approximately centered above table; title2 uses 1 line; footnote starts in column A; site_no is text in Excel
Here's why I changed your code:
1) there's no need to "send" a <style> section in HEADTEXT to change TD because a) other pieces of the output might have TD tags that could be adversely affected by this style change and b) you can pass in an mso-number-format style property via the HTMLSTYLE= attribute and the HTMLSTYLE attribute method works with all 3 destinations above (HTML, HTML3 and MSOFFICE2K)
2) rather than use HTML tags for the footnote, I used the font, color and size options that were built into ODS. Note in the observations above that each destination creates different tags and Excel interprets each set of HTML tags in a different manner.
You can easily left-justify title and footnote strings by using J=L in the TITLE or FOOTNOTE statement. (you can see in the output that J=C or J=R is interpreted a bit differently by Excel --even though it works beautifully in a browser.) For size changes in the title and footnote, you would use the H= attribute. For font changes, you would alter the TITLE or FOOTNOTE statement to have a font reference:
[pre]
title1 j=l font='Courier New' h=14pt c=purple 'The Default Title';
[/pre]
When you create HTML files that can be opened and rendered in Excel, remember that even if you give the file a ".xls" extension, you are not creating a true, binary Excel file. You are merely creating an ASCII text file that Excel knows how to open and render. Because you use a file extension of ".xls" when you double click on the file icon, Excel will automatically launch because that extension is associated with Excel -- so basically you're fooling the Windows registry because otherwise a browser would launch if you clicked on a file with an ".html" or ".htm" file extension.
cynthia