Thank you, Andre. I thought nobody was going to respond to my question, so I did not watch my original Q closely, until I saw yours minutes. I will try and let you know if the problem can be fixed.

Paula D

wielki@INED.FR (Andre Wielki) wrote in message news:<5.1.0.14.0.20020711140915.0264b008@mailhost.ined.fr>... > Paula, > If it could help you > the number you mention is in wich unit mesure in html ods direction: > > from documentation on line doc //........sasdoc/sashtml/proc/z0060410.htm > > dimension > is a nonnegative number, followed by one of the following units of measure > cm centimeters > in inches > mm millimeters > pt a printer's point > px pixels (based on the size of a pixel on the target device) > > Note: In Version 8 of the SAS System, only the Printer destination > supports units of measure on dimensions. However, if you specify CSS in the > ODS HTML statement, the HTML destination supports units of measure. The CSS > option is experimental in Version 8. > > Default: > For the HTML destination, pixels; for the Printer destination, units of > 1/150 of an inch > > Conclusion use the css facilities to define your values again . > > > Excel behavior is free from sas definition: at import of a html file does > excel make always > transformation (following a microsoft rule...) > > HTH > Andre > > > > > At 14:07 09/07/2002 -0700, paula D wrote: > >This is the code I wrote today: > > > >ods html body="c:\quarter3\testtabulate.html"; > > > >Proc tabulate data=ccc.DecideNTF5(keep=type yearmonth firsthd) > >order=formatted ; > >class type/s=[font_face='Time New Roman' font_weight=bold > >font_size=4]; > >class yearmonth/s=[font_face="Time New Roman" font_weight=bold > >cellwidth=12]; > >format yearmonth $month. type $type.; > >keyword n colpctn /s=[background=yellow font_face="Time New Roman"]; > >keyword all/s=[background=white]; > >classlev type /s=[font_face="Time New Roman" background=white]; > >classlev yearmonth/s=[background=yellow]; > >table (type=" " all="Total"),(yearmonth=" ")*(N="# of > >People"*f=comma7. > >colpctn="% of Monthly total"*f=percen.)/Box=[label="Sources" > >s=[background=yellow]] > >row=float RTS=25 printmiss; > >run; > >ods html close; run; > > > >Everything is fine, except two. > > > >1. When ODS outputs the html file inside SAS, the labels of the N and > >colpctn > >columns are "text wrapped". That is, they look like this > > > ># of > >People > > > >instead of "# of People" on one wider cell. The wrapped text is what I > >want. > >But when I open the same HTML file in Excel 2000, the wrapped text is > >lost. The data are "# of People" on one wider cell. Is there any way > >to control that? > > > >2. Html font_size is different from Excel font_size, right? when I set > >font_size=12 in proc tabulate, the cell size is 36 inside Excel. Where > >can I find a 'translation table' to plug in the values quickly, > >instead of try-by-error? This Q is partially related to the first Q. > >When font-size >=6, the wrapping text problem does not exist. When at > >4, the problem persists. > > > >Thanks in advance. > > > >Paula D > > > ___________ > WIELKI Andre > INED - Service Informatique > 133 Bd Davout, > 75 980 Paris Cedex 20 > FRANCE > Tel: 01 56 06 21 54