Date:         Thu, 21 Aug 2008 04:27:43 -0700
Reply-To:     Sri <subhadrasri@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sri <subhadrasri@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: help with my program
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Aug 20, 10:07 am, a...@CDC.GOV (Charles Chambers) wrote:
> Why don't you use ods with ExcelXP tagset. It outputs an XML file even if
> you put the file extension as XLS.
>
> ods tagsets.ExcelXP
>  file="C:\Temp\filename.xml"
>  style=sasweb
>  options(Absolute_column_width = "10,10,10,10,12,15,15"
>    sheet_name='SheetName');
>
> proc print noobs data = QC_Test;
> run;
>
> ods tagsets.ExcelXP close;
>
> See:http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html
> and the Focus Areas on ODS Markup

I did not want to use ODS because you will be limited to format
individual cells. Thanks for the response.