topic Re: Importing excel file into SAS in SAS Programming

Importing excel file into SAS

jflo36 — Wed, 21 Oct 2015 14:22:28 GMT

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?

Re: Importing excel file into SAS

JoshB — Wed, 21 Oct 2015 14:32:35 GMT

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.

Re: Importing excel file into SAS

ballardw — Wed, 21 Oct 2015 14:33:22 GMT

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.

Re: Importing excel file into SAS

jflo36 — Wed, 21 Oct 2015 14:45:59 GMT

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

Re: Importing excel file into SAS

ballardw — Wed, 21 Oct 2015 16:55:40 GMT

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