Date: Tue, 19 Feb 2008 18:30:20 -0800
Reply-To: Richard <richard.hockey@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Richard <richard.hockey@GMAIL.COM>
Subject: Re: Error with Proc IMPORT: File _IMEX_.'Sheet1$'n.DATA does not
Content-Type: text/plain; charset=ISO-8859-1
On Feb 20, 11:54 am, tomqui...@GMAIL.COM (SUBSCRIBE SAS-L Tom Smith)
> The code is the standard code using proc import:
> libname mylib 'C:\mypath';
> proc import datafile = 'mypath\myfile.xls' out = mylib.dsn dbms=excel2000
> Error message is "File _IMEX_.'Sheet1$'n.DATA does not exist" where _IMEX_.
> is not defined by the user, instead I think it is a system or automatic one.
> ---------->Art said
> I don't think the list can celp unless you provide your code. Was the
> libname _IMEX_ assigned?
Have you tried using the libname method?
libname junk 'mypath\myfile.xls' ;