Date:         Tue, 18 Aug 2009 11:29:16 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Please help, what is wrong with 'GuessingRows' statement?
Comments: To: nancy0318@GMAIL.COM

Nancy,

Out of curiosity, have you tried both changing the DBMS=EXCEL to DBMS=XLS,
as well as commenting out the last three lines (i.e., commenting out or
deleting?:

  SCANTEXT=YES;
  USEDATE=YES;
  SCANTIME=YES;

Art
--------
On Mon, 17 Aug 2009 14:08:45 -0700, Nancy <nancy0318@GMAIL.COM> wrote:

>PROC IMPORT OUT= WORK.Spec2
>            DATAFILE= "J:\Hsee\Spec\SpecB.xls"
>            DBMS=EXCEL REPLACE;
>     SHEET="Specb$";
>         GETNAMES=YES;
>         guessingrows=260;
>         MIXED=YES;
>     SCANTEXT=YES;
>     USEDATE=YES;
>     SCANTIME=YES;
>
>RUN;
>
>I tried to import the excel data, however, I always get the following
>error:
>
> guessingrows=260;
>          ------------
>          180
>ERROR 180-322: Statement is not valid or it is used out of proper
>order.
>
>I tried to put this statment for several places, it did not work.
>What is wrong ?
>
>Thank you so much!