| 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 |
|---|
|
| 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
|
