[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: tagsets.excelxp column width question
From:       John Vickery <john_vickery () NCSU ! EDU>
Date:       2012-06-27 13:33:21
Message-ID: CAMA0K0N=Cj2x+mxoroRO+iNJ6FAg4UZmk5F65OKh3S5gm7Z4nQ () mail ! gmail ! com
[Download RAW message or body]

Thank you, Joe and Mary!

I have Vince DelGobbo's paper on my desk now. It was helpful to understand
that width is a combination of factors.

Best,
John


On Tue, Jun 26, 2012 at 2:13 PM, Joe Matise <snoopy369@gmail.com> wrote:

> From Vince's paper: width = PointSize * NumberOfCharacters * FudgeFactor ,
> with both PointSize and FudgeFactor affecting ABSOLUTE_COLUMN_WIDTH, while
> NumberOfCharacters is used for the calculations for non-absolute cells.
>  WIDTH_POINTS sets PointSize
> default, and WIDTH_FUDGE sets FudgeFactor default. So try:
>
> ods tagsets.ExcelXP options(
> width_points='1' width_fudge='1'
> absolute_column_width='14');
>
> Though I think with width_points='1' you will need to change 14 to
> something else, as your default font is probably not 1 point in width - but
> play with it and see what you really want.  He points out in the paper I
> linked to how to read the XML to find out what your real result is, so just
> change in Excel to what you want, and then see in the XML what that is
> equivalent to.
>
> FudgeFactor is 0.75 by default, PointSize I'm not sure about but is not 1 I
> don't think. There might also be a slight adjustment to allow for padding
> around the cell (this could account for the -0.7 you see, though the
> padding would be a + not a - I would think).
>
> -Joe
>
> On Tue, Jun 26, 2012 at 1:06 PM, Mary Rosenbloom <
> mary.rosenbloom.sas@gmail.com> wrote:
>
> > John,
> >
> > I didn't realize that you could use absolute_column_width with just one
> > column number specification, so I learned something new.  Thanks!
> >
> > I tried some other column width specifications, to see if perhaps the
> > widths that you were specifying were just too small, and ended up with
> the
> > following:
> >
> > (sas, excel)
> > (14, 19.29)
> > (25, 35)
> > (50, 70.71)
> > (10, 13.57)
> >
> > Which roughly follows this equation:
> > y=1.428x - 0.7045
> >
> > I'm not sure what the root cause of this is, but thought that I'd let you
> > know what found.
> >
> > Best wishes!
> > Mary R.
> >
> >
> > On Tue, Jun 26, 2012 at 10:49 AM, Joe Matise <snoopy369@gmail.com>
> wrote:
> >
> >> Width is a combination of a bunch of different factors to get to the
> final
> >> number.  Vincent DelGobbo has explained one solution here:
> >>
> >>
> >>
> http://www.wuss.org/proceedings09/09WUSSProceedings/papers/how/HOW-DelGobbo.pdf
> >>
> >>
> >> You might look through some of his other papers, as they might go in
> more
> >> detail on this issue (which does trip up a lot of people) -
> >> http://www.sas.com/reg/gen/corp/867226?page=Resources lists them.
> >>
> >> Thanks,
> >>
> >> Joe
> >>
> >> On Tue, Jun 26, 2012 at 12:30 PM, John Vickery <john_vickery@ncsu.edu
> >> >wrote:
> >>
> >> > Hi everyone,
> >> >
> >> > If I set the ABSOLUTE_COLUMN_WIDTH option to '14' shouldn't that be
> the
> >> > column width in the xml file? In other words, if I open the xml file
> >> using
> >> > excel and right click on a column the width should be 14. Instead, the
> >> > column widths that I get are all 19.29.
> >> >
> >> > Does anyone know what might be affecting the Absolute_Column_Width
> >> option?
> >> >
> >> > Below, I've used the SASHELP.CLASS dataset with the code that's giving
> >> me
> >> > the unexpected widths.
> >> >
> >> > I am using the most current ExcelXP tagset (09/26/2011, version
> 1.127).
> >> >
> >> > ods listing close;
> >> > ods tagsets.excelxp file="Class.xml" style=listing
> >> > options(embedded_titles='yes'
> >> > embed_titles_once='yes'
> >> > embedded_footnotes='yes'
> >> > merge_titles_footnotes='yes'
> >> > autofit_height='yes'
> >> > wraptext='yes'
> >> > absolute_column_width='14'
> >> > sheet_name='Class'
> >> > sheet_label='none'
> >> > sheet_interval='table');
> >> >
> >> > title j=l "Why is the output column width 19.29 instead of 14";
> >> >
> >> > footnote j=l height=9pt bold italic "John Vickery
> >> > %sysfunc(today(),date9.)";
> >> > footnote2 j=l height=9pt bold italic "Program:
> >> %sysget(SAS_EXECFILEPATH)";
> >> >
> >> > proc report data=sashelp.class nowd
> >> > headline
> >> > headskip;
> >> > column age name sex height weight;
> >> >
> >> > define age / order;
> >> > define name / order;
> >> > define sex / order;
> >> > define height / order;
> >> > define weight / order;
> >> >
> >> > break after age / summarize ol style=[background = yellow just=right];
> >> > rbreak after / summarize dol style=[font_weight=bold
> font_style=italic];
> >> > run;
> >> > title;
> >> > footnote;
> >> > ods _all_ close;
> >> > ods listing;
> >> >
> >> >
> >> > Thanks!
> >> > John
> >> >
> >> > ---
> >> > John Vickery
> >> > North Carolina State University
> >> >
> >>
> >
> >
> >
> > --
> > Cheers,
> > Mary F. O. Rosenbloom
> > http://www.sascommunity.org/wiki/User:Otterm1
> >
> >
>
[prev in list] [next in list] [prev in thread] [next in thread]