|Date: ||Fri, 12 Jul 2002 12:58:47 -0700|
|Reply-To: ||paula D <sophe@USA.NET>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||paula D <sophe@USA.NET>|
|Subject: ||Re: Two small Q on Proc tabulate with ODS|
|Content-Type: ||text/plain; charset=ISO-8859-1|
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.
wielki@INED.FR (Andre Wielki) wrote in message news:<firstname.lastname@example.org>...
> 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
> 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.
> 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...)
> 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
> >class yearmonth/s=[font_face="Time New Roman" font_weight=bold
> >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
> >colpctn="% of Monthly total"*f=percen.)/Box=[label="Sources"
> >row=float RTS=25 printmiss;
> >ods html close; run;
> >Everything is fine, except two.
> >1. When ODS outputs the html file inside SAS, the labels of the N and
> >columns are "text wrapped". That is, they look like this
> ># of
> >instead of "# of People" on one wider cell. The wrapped text is what I
> >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
> Tel: 01 56 06 21 54