Date:         Sat, 14 Dec 2002 14:44:08 -0800
Reply-To:     John Hewitt <john_hewitt2003@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         John Hewitt <john_hewitt2003@YAHOO.COM>
Subject:      Proc Import Error Message
In-Reply-To:  <20021214181915.94162.qmail@web21406.mail.yahoo.com>
Content-Type: text/plain; charset=us-ascii

Dear All:

i am trying to import data from an Excel File. I am
using Import Procedure the code for which is as
follows:
PROC IMPORT OUT= WAI_DIS.DATA_AUG_OCT
DATAFILE= "D:\Development_Disputes\Data_Aug_Oct1.xls"
DBMS=DLM REPLACE;
DELIMITER='00'x;
GETNAMES=YES;
DATAROW=2;
RUN;
The Lof error message which is displayed is:


16 PROC IMPORT OUT= WAI_DIS.DATA_AUG_OCT
17 DATAFILE=
"D:\Development_Disputes\Data_Aug_Oct1.xls"
18 DBMS=DLM REPLACE;
19 DELIMITER='00'x;
20 GETNAMES=YES;
21 DATAROW=2;
22 RUN;
Unable to sample external file, no data in first 5
records.
NOTE: Import Cancelled.
NOTE: The SAS System stopped processing this step
because of errors.
NOTE: PROCEDURE IMPORT used:
real time 0.16 seconds
A portion of the Excel data Zip file is attached.

I have tried importing data as a text file but that
lead to missing values.

Can someone help me understand what is the import
procedure not working.

John


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com