importing xlsx files to sas9.4

[sminsky]

this is my program, I tried all sorts of things, and now it says the file does not exist, but it does....

107 PROC IMPORT DATAFILE="C:\Users\Shula\Documents\Yaffa
107! Rose.PAP_done_undup2.xlsx"
108 DBMS=xlsx
109 OUT=YR_papdone REPLACE;
110 SHEET='papdone';
111 RUN;

ERROR: Physical file does not exist, C:\Users\Shula\Documents\Yaffa
Rose.PAP_done_undup2.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

[Reeza]

Are you using SAS on a server or a different type of installation that may not have access to your C drive?

[sminsky]

I am using my own personal computer.

[SASKiwi]

What SAS interface are you using? SAS Windowing Environment, Enterprise Guide or SAS Studio? If it is EG, do you use a local or remote SAS server?

[Kurt_Bremser]

When SAS tells you a file is not there, then the file is not there, period.

If SAS runs on a remote server, it cannot see your local c: drive.

[Reeza]

If you find the file in Windows, hold down SHIFT+CTRL and right click the file. Select Copy as Path. 

Post that path into your PROC IMPORT statement.

Should that period be a slash?

C:\Users\Shula\Documents\Yaffa Rose.PAP_done_undup2.xlsx

---

@sminsky wrote:

this is my program, I tried all sorts of things, and now it says the file does not exist, but it does....

107 PROC IMPORT DATAFILE="C:\Users\Shula\Documents\Yaffa
107! Rose.PAP_done_undup2.xlsx"
108 DBMS=xlsx
109 OUT=YR_papdone REPLACE;
110 SHEET='papdone';
111 RUN;

ERROR: Physical file does not exist, C:\Users\Shula\Documents\Yaffa
Rose.PAP_done_undup2.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

---

[sminsky]

Thanks all. there were several errors. one was the missing slash, another
was that SAS did not want the suffix (sas7dat) \. it finally worked.

[SASKiwi · Accepted solution]

Can you mark the post as answered then please?

[sminsky]

I don't know how to do this. This was my first connection with the site...
sorry.