Date:         Thu, 26 Aug 2010 09:56:23 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Tagsets.ExcelXP - Default_Column_Width Question
Comments: To: Jack Clark <jclark@hilltop.umbc.edu>
In-Reply-To:  <456B52C41B724C41B96561D7AD283E7D01F04EA5@mail.chpdm.umbc.edu>
Content-Type: text/plain; charset=ISO-8859-1

I would guess that the writer of the tagset preferred to allow the repeated
option over the above-max-columns possibility - they're mutually exclusive,
after all.  I do think it would not be difficult to modify the tagset to do
this, for someone who knows how to program in tagset-language (I don't
really, though it's possible I could figure it out - it's not that hard to
read).
-
Joe

On Thu, Aug 26, 2010 at 9:50 AM, Jack Clark <jclark@hilltop.umbc.edu> wrote:

> Joe,
>
> Using 0 to get the default is good to know, but still doesn't take care
> of the fact that if the output reached a number of columns greater than
> the number of widths defined, the "pattern" of widths defined is being
> repeated.  Using the example below (DEFAULT_COLUMN_WIDTH =
> '20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0') would result in the 18th column in
> your report having an undesired width of 20.
>
> Maybe this option was primarily developed with reports with a known
> number of columns in mind?
>
>
> Jack
>
>
>
>
>
>
> Jack Clark
> Senior Research Analyst
> phone: 410-455-6256
> fax: 410-455-6850
> jclark@hilltop.umbc.edu
>
> University of Maryland, Baltimore County
> Sondheim Hall, 3rd Floor
> 1000 Hilltop Circle
> Baltimore, MD 21250
>
> Please consider the environment before printing this e-mail and/or any
> attachments.
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe
> Matise
> Sent: Thursday, August 26, 2010 10:45 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Tagsets.ExcelXP - Default_Column_Width Question
>
> Jack,
> A birdie suggested using 0 default widths for the other columns, so
> DEFAULT_COLUMN_WIDTH = '20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'
> would set the columns after the first to be automatically sized.  That
> works
> for me with ABSOLUTE_COLUMN_WIDTH.
>
> -Joe
>
> On Thu, Aug 26, 2010 at 9:12 AM, Jack Clark <jclark@hilltop.umbc.edu>
> wrote:
>
> > Joe,
> >
> > I'm not sure I understand your suggestion.  Could you provide some
> > syntax for what you are suggesting?
> >
> >
> > When I tried...default_column_width="20"...I get ALL columns set to
> 20.
> >
> > When I tried... default_column_width="20,8"...I get columns
> alternating
> > between 20 & 8 (columns 1, 3, 5, etc are 20 - columns 2, 4, 6, etc are
> > 8).
> >
> > When I tried... default_column_width="20,8,2"...I get the alternating
> > thing again (every third column is 20, 8, 2)
> >
> > I would like to set the width for the first column only, and have the
> > remainder of the columns (unknown number) use the default.
> >
> >
> > Thanks.
> >
> >
> > Jack
> >
> >
> >
> > Jack Clark
> > Senior Research Analyst
> > phone: 410-455-6256
> > fax: 410-455-6850
> > jclark@hilltop.umbc.edu
> >
> > University of Maryland, Baltimore County
> > Sondheim Hall, 3rd Floor
> > 1000 Hilltop Circle
> > Baltimore, MD 21250
> >
> > Please consider the environment before printing this e-mail and/or any
> > attachments.
> > -----Original Message-----
> > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Joe
> > Matise
> > Sent: Thursday, August 26, 2010 10:07 AM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: Re: Tagsets.ExcelXP - Default_Column_Width Question
> >
> > I would use the default column width value for a new column for the
> > other
> > columns (64 pixels if I recall correctly).  You don't have to specify
> > ALL
> > columns, it will specify the default for any extra columns.  I suspect
> > it's
> > just that the one argument option behaves differently in case you want
> > all
> > columns the same width.
> >
> > -Joe
> >
> > On Thu, Aug 26, 2010 at 8:44 AM, Jack Clark <jclark@hilltop.umbc.edu>
> > wrote:
> >
> > > Good morning,
> > >
> > >
> > >
> > > I have just started playing with the Tagsets.ExcelXP ODS
> destination.
> > I
> > > am sending the output from PROC TABULATE to Excel.
> > >
> > >
> > >
> > > I have a variable HOSP as the row dimension and a count of records
> (N)
> > > by YEAR as the column dimension.  When the data gets to Excel, the
> > > column for HOSP is not open wide enough.  I found the
> > > DEFAULT_COLUMN_WIDTH option as a way to control the width of columns
> > in
> > > Excel.  The problem I am running in to is that I only need to
> control
> > > the width of the first column (HOSP).  I do not know how many
> > additional
> > > columns there will be, because the data can have different number of
> > > YEAR values each time I run it.
> > >
> > >
> > > Is it possible to use DEFAULT_COLUMN_WIDTH to set the width of the
> > first
> > > column, but not specify additional column widths?  When I put only 1
> > > value in the for option, it set all my columns to that width (which
> I
> > > don't want).  Or, is there a way within the PROC TABULATE code to
> set
> > > the width for HOSP to be used in the Excel file?
> > >
> > >
> > >
> > > Thanks in advance.
> > >
> > >
> > >
> > >
> > >
> > > Jack
> > >
> > >
> > >
> > > Jack Clark
> > > Senior Research Analyst
> > > phone: 410-455-6256
> > > fax: 410-455-6850
> > > jclark@hilltop.umbc.edu
> > >
> > > University of Maryland, Baltimore County
> > > Sondheim Hall, 3rd Floor
> > > 1000 Hilltop Circle
> > > Baltimore, MD 21250
> > >
> > > Please consider the environment before printing this e-mail and/or
> any
> > > attachments.
> > >
> > >
> > > Confidentiality Notice: This e-mail may contain information that is
> > legally
> > > privileged and that is intended only for the use of the addressee(s)
> > named
> > > above. If you are not the intended recipient, you are hereby
> notified
> > that
> > > any disclosure, copying of this e-mail, distribution, or action
> taken
> > in
> > > reliance on the contents of this e-mail and/or documents attributed
> to
> > this
> > > e-mail is strictly prohibited. If you have received this information
> > in
> > > error, please notify the sender immediately by phone and delete this
> > entire
> > > e-mail. Thank you.
> > >
> >
>