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>
Organization: Web2news.com
Subject:      Re: problem occurs when export sas datasets to EXCEL
Content-Type: text/plain; charset=iso-8859-1

> Prasad:

The code I used is:

libname xl odbc noprompt="DRIVER=Microsoft Excel Driver (*.xls);
ReadOnly=0;DBQ=C:\Juan\Test.xls;";

Data xl.trans;
Set work.alltrans;
Run;

Libname xl;

Sometimes I use proc export. I also observed this problem before.

Thanks

Juan


Juan:
>
>    How are you exporting to EXCEL, can we see the code?.
> Sounds like a TAB
> issue!!
>
> Prasad Ravi
>
>                          Juan
>                          <juan.news.invalid@WE  To:
> SAS-L@LISTSERV.UGA.EDU
>                          B2NEWS.NET>            cc:
>                          Sent by: "SAS(r)       Subject:
> problem occurs when export sas datasets to
>                          Discussion"
>                          <SAS-L@LISTSERV.UGA.E
>                          DU>
>
>                          05/20/2003 08:51 AM
>                          Please respond to
>                          Juan
>
> 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