Date:         Tue, 30 Sep 2008 07:30:39 -0700
Reply-To:     dkin26@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         dkin26@GMAIL.COM
Organization: http://groups.google.com
Subject:      Re: Proc Export and Formatting
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Aug 11, 4:09 pm, savian...@GMAIL.COM (Alan Churchill) wrote:
> If running on Windows, SaviCells has a format string option:
>
>         <Cell location="H3">
>           <Style>
>             <Bold>true</Bold>
>             <NumberFormat>###,##0</NumberFormat>
>           </Style>
>           <Formula>SUM(D3:G3)</Formula>
>         </Cell>
>
> See what others have to say but that is an option for you.
>
> http://utilities.savian.net
>
> Alan
>
> Alan Churchill
> Savianwww.savian.net
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of
>
> jlee8...@gmail.com
> Sent: Sunday, August 10, 2008 9:22 PM
> To: SA...@LISTSERV.UGA.EDU
> Subject: Proc Export and Formatting
>
> Hello everyone,
>
> I have been asking some formatting questions and I just have one more
> to bother you guys. I hope this one can be easily solved.
>
> In my SAS dataset, I have odds ratios (OR) with values of 1.00
>
> When I export it to EXCEL (proc export), the significant figures .00
> is lost so I just see a bunch of 1's in my EXCEL sheet.
>
> Is there an option in proc export that allows me to keep the
> significant figures when I export to EXCEL?
>
> Or any other possible solutions?
>
> It is essential that I keep the significant figures.
>
> Thank you,
>
> claus- Hide quoted text -
>
> - Show quoted text -

Hi Alan,

Your logic is looking good, but when we are exporting a dataset to
excel, how can we know that a particular column will occupy the cell?

could you please explain it clearly..

Regards,
kali