Date: Wed, 20 Feb 2008 09:50:13 -0500
Reply-To: SUBSCRIBE SAS-L Tom Smith <tomquin99@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: SUBSCRIBE SAS-L Tom Smith <tomquin99@GMAIL.COM>
Subject: Re: Error with Proc IMPORT: File _IMEX_.'Sheet1$'n.DATA does not
-----------SAS log begins
11 proc import datafile = 'C:\temp\res.xls' dbms = excel2000 out =
ERROR: File _IMEX_.'Sheet1$'n.DATA does not exist.
ERROR: Import unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.46 seconds
cpu time 0.12 seconds
-----------SAS log end
The tag Sheet1 does exist, and I also renamed it and tried different
names, and Save As the Excel file to different versions, all of which do
not help. I think the reason may be the number of columns >256.
I had this kind of problem when using PROC Export to convert dataset to
Excel file, then I used PROC DBLOAD to get the job done. Is there any proc
works in opposite direction to PROC DBLOAD ?