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?
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
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;
>I tried to import the excel data, however, I always get the following
>ERROR 180-322: Statement is not valid or it is used out of proper
>I tried to put this statment for several places, it did not work.
>What is wrong ?
>Thank you so much!