Date:         Wed, 26 Aug 2009 09:34:11 -0400
Reply-To:     Seth StJames <sethstjames@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Seth StJames <sethstjames@GMAIL.COM>
Subject:      Excel via ODS and proc report vs. proc export
Content-Type: text/plain; charset=ISO-8859-1

SAS-L

I create an EXCEL file using ODS (ods html body='...\filename.xls')  the
file is much larger than an excel file created using proc export.  I think
in part since I have all the labels (instead of the variable names), and all
of the columns are fully expanded.  But
does anyone know if this is the only reason the file is larger, that is, due
to ODS.  The larger file with all the data I need takes about 5 minutes to
open as compared to about 30 seconds for the same file created with proc
export.  The reason I'm using ODS is to
get the labels instead of the variable names.

A second question is:  Is there a way to get the variable labels in the
EXCEL file using proc export instead of ODS?

Thanks!
Seth