Date:         Fri, 27 Apr 2007 16:51:00 -0400
Reply-To:     "Larlick, David (IMI)" <dlarlick@ICONMEDICALIMAGING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Larlick, David (IMI)" <dlarlick@ICONMEDICALIMAGING.COM>
Subject:      Re: Export and Keep Format
Comments: To: sbarry@SBBWORKS.COM
In-Reply-To:  <1177697170.352954.21940@b40g2000prd.googlegroups.com>
Content-Type: text/plain; charset=iso-8859-1

I would be curious to find out if you can indeed post the applied format to a separate source.  From what I have read the format is applied using specified SAS statements.  Posting to Excel or some other datasource will utilize the underlying data instead of the applied format.

I have only worked with Excel with the SAS/ACCESS component, so I can't speak for other methods of working with Excel as a datasource.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Scott Barry
Sent: Friday, April 27, 2007 2:06 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Export and Keep Format

On Apr 27, 10:29 am, marcioes...@POP.COM.BR (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

It would be useful to see some of your code and also more importantly see some of your resulting "formatted output" along with what you would expect in Excel.

Scott Barry
SBBWorks, Inc.




_______________________________________________________________________________________________________________________________________




This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. If you
are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this e-mail is strictly prohibited.
If you have received this e-mail transmission in error, please reply to the sender, so that ICON can arrange for proper delivery, and then please
delete the message.  Thank You.