Tom

I believe that I have seen this before but it is too long ago to remember the fix. -- a fat log of good that does you!

I just googled the message and found the following from Paul Choate

Mia - Save and close Excel before importing to SAS. hth

and I believe that someone has already suggested. The SAS usage notes have several entries under File_IMEX_ :

Problem Note 7883: "ERROR: File _IMEX_.'Sheet1$'.DATA does not exist" returned when trying to import an Excel file

(Embedded image moved (Embedded image moved (Embedded image moved to ( to file: pic12760.gif) to file: pic19357.gif) file: pic02324.gif) E m b e d d e d i m a g e m o v e d t o f i l e : p i c 0 6 4 7 7 . g i f )

Type: Problem Note

Priority: low

Date Modified: 2006-01-03 16:04:26

Date Created: 2002-06-28 09:42:11

When using PROC IMPORT statements or the Import Wizard to read an Excel97 or Excel2000 file into SAS, the following error may be returned:

ERROR: File _IMEX_.'SHEET1$'.DATA does not exist. ERROR: Import unsuccessful. See SAS Log for details.

If the Excel file has 256 columns, the MS Jet Provider will not be able to read the file. There is a bug in the MS Jet Provider. It will create an Excel file that has the maximum number of fields allowed, 256. However, it can read only 255 fields. You can save the Excel file as a MS Excel 5/95 workbook file or as a delimited text file and import that into SAS. These file types are not accessed via the MS Jet Provider by the SAS IMPORT procedure.

There are other notes but most of these appear to involve Access files and particularlly, situations when there is a hyphen or other special character in the name.

As others have said, the complete log including code and notes would be more helpful.

Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977

----------------------------------------- CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.