Date:         Sat, 28 Apr 2007 01:20:49 GMT
Reply-To:     pallabs <u33761@UWE.UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         pallabs <u33761@UWE.UGA.EDU>
Subject:      Re: Export and Keep Format
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="utf-8"

Marcio Ribeiro 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


Create a new variable that has a character value equivalent to the formatted
value like this:
newvar= put(oldvar, formatname);

Look up the PUT function and formats; or do a Google search on How do I
convert numeric variables to character in SAS? and just use the same
technique.

Regards,
Paul Sengupta