SAS 9.1 import wizard is having problem with excel file imports, it works ok for .txt files.
I was using the same files to work in SAS in Oct this year , it worked well.
Now, I tried using both the import wizard and command line approach, same result.
This is the sas log message which I get -
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.54 seconds
cpu time 0.17 seconds
Also for some reason, after I reinstalled SAS ( thinking it might sort the problem )it has gone to -
Grace Period: 45 days (ending 14FEB2006).
Warning Period: 45 days (ending 31MAR2006)
This is not the forum for IMPORT Wizard problems -- since the IMPORT Wizard is not generally involved in ODS and Base SAS Reporting (PRINT, REPORT, TABULATE) production of reports.
If you are having trouble with PROC IMPORT and/or need a SETINIT, your best and fastest resource is to open a track with Tech Support. To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem".