Hi,
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
DATAFILE= "\\pay_file_%sysfunc(date(),mmddyyn6.).XLSX"
DBMS=EXCEL REPLACE;
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
Run;
Can someone help please?
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.
I am using Windows 7. The file is actually from a share network drive.
@jflo36 wrote:
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.
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.