|
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!
|
