Date:         Tue, 18 Aug 2009 07:21:44 -0700
Reply-To:     mlhoward@avalon.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Please help, what is wrong with 'GuessingRows' statement?
Comments: To: Nancy <nancy0318@GMAIL.COM>
Content-Type: text/plain; charset="UTF-8"

It depends on the DBMS source as to which statements are valid; guesssingrows is
only valid for CVS/TAB and DLM, not for Excel (See the help on Proc Import- Data Source
statements, then inside the box for each group are the ones that you can use).

If you want to use guessingrows, I would recommend exporting the data as a tab-delimited
file, then import as a tab-delimited file.

-Mary

--- nancy0318@GMAIL.COM wrote:

From: Nancy <nancy0318@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject:      Please help, what is wrong with 'GuessingRows' statement?
Date:         Mon, 17 Aug 2009 14:08:45 -0700

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!