Date: Tue, 30 Sep 2008 07:30:39 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: Proc Export and Formatting
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">
> See what others have to say but that is an option for you.
> Alan Churchill
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of
> 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 -
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..