Date:         Wed, 3 Aug 2005 16:55:05 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: Looking to retain heading formatting after exporting to Excel

Offhand, I cannot come up with a SAS-to-Excel export technique which does
NOT preserve case. For exapmle, when I use the SAS Export Wizard to copy
SASHELP.CLASS to an Excel 2000 worksheet, the first column heading
is "Name" (not "NAME" or "name").

So just how does the problem arise?

On Fri, 29 Jul 2005 16:07:26 -0700, David Fickbohm <davefickbohm@YAHOO.COM>
wrote:

>People,
>Does anybody know of a way in SAS to set headings so that proper case is
retained after export to Excel?   I do not think it is possible, but before
I start working with VB or Perl or PYTHON or ??  I thought I would ask.
>Thanks
>Dave
>
>
>
>Dave Fickbohm
>Use Technology to the Fullest
>1250 45th st suite 200
>Emeryville, CA, 94608
>510 594 4151 voice