Date:         Tue, 20 May 2003 12:52:38 -0400
Reply-To:     Robert Abelson <rabelson@KAI-RESEARCH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Robert Abelson <rabelson@KAI-RESEARCH.COM>
Subject:      Re: problem occurs when export sas datasets to EXCEL
Content-Type: text/plain

I had the same problem with PROC EXPORT. The solution was to use ODS to
write to an HTML file, with a .XLS extension, read it into Excel, and save
it. Give that a try, and see if the problem goes away.

Good luck.

Bob Abelson
KAI
6001 Montrose Rd.
Suite 920
Rockville, MD 20852
T: 301-770-2730
F: 301-770-4183
rabelson@kai-research.com

"If you want to inspire confidence, give plenty of statistics.  It does not
matter that they should be accurate, or even intelligible, as long as there
is enough of them."

-Lewis Carroll



> -----Original Message-----
> From: Juan [SMTP:juan.news.invalid@WEB2NEWS.NET]
> Sent: Tuesday, May 20, 2003 11:52 AM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      problem occurs when export sas datasets to EXCEL
>
> Dear SAS Users,
>
> While I export sas datasets to Excel, when some of the numeric variables
> have missing values, the following numeric variable values(non missing
> of course) from the same obs will move forward to fill in that field,
> resulting lots of mismatch. But the interesting thing is that it is not
> happened to all the obs. Everything looks just fine except the result.
> Who can explain this and how to fix this problem?
>
> TIA
>
> Juan
> --
> Direct access to this group with http://web2news.com
> http://web2news.com/?comp.soft-sys.sas