| Date: | Mon, 11 Aug 2008 05:09:54 -0600 |
|---|
| Reply-To: | Alan Churchill <savian001@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Alan Churchill <savian001@GMAIL.COM> |
|---|
| Subject: | Re: Proc Export and Formatting |
|---|
|
| In-Reply-To: | <212799cf-85af-4773-b5d9-be2cc4bdcccc@j1g2000prb.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
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
Savian
www.savian.net
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
jlee8071@gmail.com
Sent: Sunday, August 10, 2008 9:22 PM
To: SAS-L@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
| 
