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>
Organization: http://groups.google.com
Subject:      Re: Error with Proc IMPORT: File _IMEX_.'Sheet1$'n.DATA does not
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Feb 20, 11:54 am, tomqui...@GMAIL.COM (SUBSCRIBE SAS-L Tom Smith)
wrote:
> The code is the standard code using proc import:
>
> libname mylib 'C:\mypath';
> proc import datafile = 'mypath\myfile.xls' out = mylib.dsn dbms=excel2000
> replace;
> sheet='sheet1';
> getnames=yes;
> run;
>
> 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.
>
> Thanks.
>
> ---------->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?
eg
libname junk 'mypath\myfile.xls' ;
data mylib.dsn;
 set junk.'Sheet1$'n;
run;

R