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.
这个是俺找到的答案,就是说列不能超过255列~ 希望对你有帮助
|