DATA Step, Macro, Functions and more

Importing excel file into SAS

Reply
Occasional Contributor
Posts: 10

Importing excel file into SAS

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?

Contributor
Posts: 56

Re: Importing excel file into SAS

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.

Occasional Contributor
Posts: 10

Re: Importing excel file into SAS

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

Super User
Posts: 11,343

Re: Importing excel file into SAS


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.

Super User
Posts: 11,343

Re: Importing excel file into SAS

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.

Ask a Question
Discussion stats
  • 4 replies
  • 176 views
  • 0 likes
  • 3 in conversation