Date:         Sun, 29 Apr 2007 22:24:50 -0700
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: Export and Keep Format
In-Reply-To:  <200704271429.l3RAkok1017051@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

marcioestat@POP.COM.BR wrote:
>
>Hey all,
>
>I am using the proc report with FORMAT and OUT options, so I export the
>table obtained to the Excel. How do I keep the format to be shown at the
>Excel?
>
>Thanks in advance,
>
>Márcio

I think that a better approach is not to use PROC EXPORT at all.

If you can use the ExcelXP tagset, then you can *tell* it to keep the
formats you want for the variables you want.  The ODS TAGATTR= style
attribute does that for you.  It's one of the many powerful features
of this tagset.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
MSN is giving away a trip to Vegas to see Elton John.  Enter to win today.
http://msnconcertcontest.com?icid-nceltontagline