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 <jclark@HILLTOP.UMBC.EDU> 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.