Date: Tue, 18 Aug 2009 07:21:44 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mary <mlhoward@AVALON.NET>
Subject: Re: Please help, what is wrong with 'GuessingRows' statement?
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.
--- nancy0318@GMAIL.COM wrote:
From: Nancy <nancy0318@GMAIL.COM>
Subject: Please help, what is wrong with 'GuessingRows' statement?
Date: Mon, 17 Aug 2009 14:08:45 -0700
PROC IMPORT OUT= WORK.Spec2
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!