Importing excel file into SAS

[jflo36]

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?

[JoshB]

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.

[jflo36]

I am using Windows 7. The file is actually from a share network drive.

[ballardw]

---

@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.

[ballardw]

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.