topic Re: Import File Error in SAS Programming

Import File Error

vinod4842 — Tue, 16 May 2017 04:34:55 GMT

hi this is vinod

proc import out=work.superstore1 datafile="C:\Users\user\Desktop\m\sample.xlsx"
dbms=excel replace;
run;

i am getting

ERROR: Unable to open file C:\Users\user\Desktop\m\sample.xls. 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.05 seconds

plz tell me the answer is this correct

Re: BASE SAS

Reeza — Tue, 16 May 2017 04:34:30 GMT

The path to the file is incorrect.

If you right click the file holding down SHIFT key you can copy the path to the file directly (COPY AS PATH) and use that in your import. Make sure the file isn't in use either as indicated, ie Excel is closed.

Re: Import File Error

Reeza — Tue, 16 May 2017 04:35:35 GMT

Also use DBMS = XLSX not EXCEL.

Re: Import File Error

ballardw — Tue, 16 May 2017 14:55:24 GMT

And if you are running in a server environment the path would be from the Server machine point of view and would not see your desktop.

Re: Import File Error

Barkat — Wed, 24 Nov 2021 03:22:45 GMT

I have a similar problem. I believe you found the problem. How to solve this?

Re: Import File Error

Reeza — Wed, 24 Nov 2021 03:32:12 GMT

You upload your file to the server or you use the Copy Files task to upload it.
You can also do it via the GUI but via code sadly.