10-21-2015 10:22 AM
I keep getting the error code listed below while importing this excel file into sas. The file name is: pay_file_102115.XLSX
ERROR: Unable to open file
pay_file_102115.XLSX. It does not
exist or it is already opened exclusively by another user, or you need permission to view its data.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
This is the code that I am using to import the file:
PROC IMPORT OUT= WORK.TEST
Can someone help please?
10-21-2015 10:32 AM
It's hard to say much with limited information. What OS are you operating on? Is it possible that file is truly open somewhere else? I would check that the file does exist in the root directory you're referencing and that the case on the file name is correct, including the extension.
10-21-2015 12:55 PM
I am using Windows 7. The file is actually from a share network drive.
Then you need to have the Drive indicated along with the path to the file.
10-21-2015 10:33 AM
I would try two things: One is to use a full path to describe where the file is located. Second, tryit with out any functions or macro variables.
Also, are you running in a server environment? If so the path to the file needs to be as the server sees it.