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.
6001 Montrose Rd.
Rockville, MD 20852
"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."
> -----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?
> Direct access to this group with http://web2news.com