Date:         Thu, 25 Dec 2003 23:23:01 GMT
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: bug in proc import?

Conversely, you could take a look at
http://support.sas.com/techsup/unotes/SN/006/006123.html

The above technical note describes the problem and offers a couple of other
possible solutions.

Art
--------
"Arthur Tabachneck" <art297@netscape.net> wrote in message
news:9SHGb.178260$%TO.167907@twister01.bloor.is.net.cable.rogers.com...
> Definitely doesn't work right with Excel2000 files.  However, if you save
> the file (in Excel) in Excel5/95 format, and then change Excel2000 to
Excel5
> in your SAS code, the file appears to read in correctly.
>
> Art
> ---------
> "Yong Cai" <caiyong@u.washington.edu> wrote in message
> news:Pine.WNT.4.58.0312241722150.1316@IMPACTWS3.IMPACT...
> > I have an excel file like this (attached).
> >
> > 325 62 12 50
> > 12 4 4
> > 5 1 1
> > 2
> > 10
> > 2
> >
> > The blank cells are not truly blank. Each has 8 'spaces'.
> >
> > I imported it to sas. Some thing strange happened: The third column is
> > totally gone.
> >
> > PROC IMPORT OUT= WORK.TEST
> >             DATAFILE= "C:\test.xls"
> >             DBMS=EXCEL2000 REPLACE;
> >      GETNAMES=NO;
> > RUN;
> >
> > proc print data=test; run;
> > Obs     F1    F2    F3            F4
> >
> >  1     325    62                  50
> >  2      12     4                   4
> >  3       5     1                   1
> >  4       2     .                   .
> >  5      10     .                   .
> >  6       2     .                   .
> >
> > Any clue? Thanks in advance and happy holidays!
>
>