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
Content-Type: text/plain; format=flowed
>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
>Thanks in advance,
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.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
MSN is giving away a trip to Vegas to see Elton John. Enter to win today.