Date:         Tue, 19 Feb 2008 21:07:34 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Error with Proc IMPORT: File _IMEX_.'Sheet1$'n.DATA does not
              exist
Comments: To: SUBSCRIBE SAS-L Tom Smith <tomquin99@GMAIL.COM>

Tom,

Try it with:

proc import datafile = 'c:\mypath\myfile.xls' out = mylib.dsn
 dbms=excel2000

and, if that fails, show the list your log.

Art
---------
On Tue, 19 Feb 2008 20:54:55 -0500, SUBSCRIBE SAS-L Tom Smith
<tomquin99@GMAIL.COM> 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?