Date:         Tue, 11 May 2010 11:57:45 -0500
Reply-To:     Sudo Ku <crafty876@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sudo Ku <crafty876@HOTMAIL.COM>
Subject:      FW: Autosize Excel Columns from SAS
In-Reply-To:  <8CCBF29B9F55308-1928-BD6F@webmail-d056.sysops.aol.com>
Content-Type: text/plain; charset="iso-8859-1"

>
>
> For column Sizing using excel XP I prefer the Absolute_column_width option as in
>
> OPtions Papersize="Legal" nobyline;
> ODS tagsets.excelxp file="C:\output.xls" style=mine;
>
> ODS tagsets.excelxp options(Sheet_Name="&&Loc&I" Embedded_Titles="YES" Embedded_Footnotes="Yes" Print_header_margin="0.1" Print_footer_margin="0.1"
> Frozen_Headers="5" Absolute_Column_Width="15,9,9,9,9,9,9") ;
>
> You can get a full listing of options available (written to the log) with:
>
> ODS tagsets.excelxp file="c:\temp.xls" options(doc='help');
>
> regards,
>
> Kevin
>
> ----------------------------------------
>> Date: Tue, 11 May 2010 10:02:29 -0400
>> From: evilpettingzoo97@AOL.COM
>> Subject: Re: Autosize Excel Columns from SAS
>> To: SAS-L@LISTSERV.UGA.EDU
>>
>> Jack,
>>
>> The EXCELPXP tagset has some helpful options worth exploring:
>>
>> example:
>>
>> ods tagsets.excelxp
>> style=minimal
>> options ( autofilter = 'yes' frozen_headers = '1' autofit_height='yes' )
>> file="xxx.xls"
>> ;
>>
>> Regards,
>>
>> Regards,
>> Ken
>>
>>
>>
>>
>> -----Original Message-----
>> From: Jack Clark
>> To: SAS-L@LISTSERV.UGA.EDU
>> Sent: Tue, May 11, 2010 8:53 am
>> Subject: Autosize Excel Columns from SAS
>>
>>
>> Hello,
>>
>> I am using SAS (v9.1 on Windows) to write a series of datasets to a
>> icrosoft Excel workbook with PROC EXPORT. Each dataset goes to a
>> eparate worksheet and currently there are 24. This is working fine.
>>
>> The thing I don't like is that my Excel file does not size the columns
>> o fully display the data. I don't want to go in manually and size the
>> olumns. Years ago I know I wrote a VBA macro to do this, which I
>> alled from SAS with DDE.
>>
>> I am wondering if there is a better way to issue commands from SAS that
>> ill open the Excel file and autosize the columns in ALL worksheets in
>> he workbook? Or is VBA macro and DDE the preferred method? Any
>> uggestions are appreciated.
>>
>>
>> Jack
>>
>>
>> Jack Clark
>> enior Research Analyst
>> hone: 410-455-6256
>> ax: 410-455-6850
>> clark@hilltop.umbc.edu
>> University of Maryland, Baltimore County
>> ondheim Hall, 3rd Floor
>> 000 Hilltop Circle
>> altimore, MD 21250
>> Please consider the environment before printing this email and/or any
>> ttachments.
>>
>> onfidentiality Notice: This e-mail may contain information that is legally
>> rivileged and that is intended only for the use of the addressee(s) named
>> bove. If you are not the intended recipient, you are hereby notified that any
>> isclosure, copying of this e-mail, distribution, or action taken in reliance on
>> he contents of this e-mail and/or documents attributed to this e-mail is
>> trictly prohibited. If you have received this information in error, please
>> otify the sender immediately by phone and delete this entire e-mail. Thank you.
> _________________________________________________________________
> 30 days of prizes: Hotmail makes your day easier! Enter Now.
> http://go.microsoft.com/?linkid=9729710
_________________________________________________________________
30 days of prizes to be won with Hotmail.  Enter Here.
http://go.microsoft.com/?linkid=9729709