ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
The log details don't really explain why this failure occurs. The same result occurs when I use the import wizard. Any help with making my copy of SAS (ver. 9.1.3) import excel spreadsheets would be appreciated.
Unfortunately, making that change does not change the outcome. I've tried using the import wizard, too, but the failure persists. Deinstalling/reinstalling SAS does not get rid of the problem, either, and neither does the local sysadmin putting me in the unrestricted usergroup that she is in. And yet(!) if I perform the exact same import on *her* machine it does work. I"ve done everything I can think of to get rid of this problem when I try to import on my machine and nothing seems to work.
One presumption here is that you are able to open the "input" file outside of SAS, especially considering the file resides on a "Q" network drive allocation. Also, suggest you share the info about your LIBNAME statement, as revealed in your SAS log output.
Can open file in question outside of SAS with no problems. Despite what the error message in the log implies, no LIBNAME statement exists in the script. Error message is identical whether I use the script or the import wizard.