Date: Tue, 20 May 2003 18:30:08 +0200
Reply-To: Juan <juan.news.invalid@WEB2NEWS.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Juan <juan.news.invalid@WEB2NEWS.NET>
Subject: Re: problem occurs when export sas datasets to EXCEL
Content-Type: text/plain; charset=iso-8859-1
The code I used is:
libname xl odbc noprompt="DRIVER=Microsoft Excel Driver (*.xls);
Sometimes I use proc export. I also observed this problem before.
> How are you exporting to EXCEL, can we see the code?.
> Sounds like a TAB
> Prasad Ravi
> <juan.news.invalid@WE To:
> B2NEWS.NET> cc:
> Sent by: "SAS(r) Subject:
> problem occurs when export sas datasets to
> 05/20/2003 08:51 AM
> Please respond to
> 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