|Date: ||Wed, 17 Jan 2007 02:31:50 GMT|
|Reply-To: ||Paula Sims <paulasims2004@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Paula Sims <paulasims2004@HOTMAIL.COM>|
|Organization: ||SBC http://yahoo.sbc.com|
|Subject: ||Re: Excel taking over SAS output|
Thanks Art. I didn't try PROC Export (just ODS and the right-click "View
in Excel") but don't know why I didn't (just lazy??), I just didn't.
I'll have to force the PROC Export. Interesting, when the "View in
Excel" option is used, X does become numeric.
Thanks for the nudge.
In article <200701162316.l0GMlJNs031848@mailgw.cc.uga.edu>, art297
> I wasn't able to replicate the problem. I ran the following code on SAS9
> (Windows 2003 server):
> data have;
> input x $ y $;
> 111 222
> 4E1 ABC
> 3E4 DEF
> 111 222
> PROC EXPORT DATA= WORK.have
> OUTFILE= "S:\have.xls"
> DBMS=EXCEL2000 REPLACE;
> The resulting spreadsheet contained all text items with notes asking if I
> wanted to convert the text to numbers.
> On Tue, 16 Jan 2007 22:40:51 GMT, Paula Sims <paulasims2004@HOTMAIL.COM>
> >Hello there,
> >OK, I know Excel has a "mind" of its own and does what it thinks is
> >right, regardless of the truth, but I could use help in figuring out how
> >to stop what's happening to me.
> >I'm outputting from a SAS dataset to Excel and one of the columns has
> >values such as 4E1. Unfortunately, Excel interprets this as 4.00E+1.
> >I've tried ODS, and the right-click export method and it still doesn't
> >work. Is there any way to prevent this?
> >Thanks so much.