topic Re: importing xlsx files to sas9.4 in SAS Programming

importing xlsx files to sas9.4

sminsky — Tue, 26 Feb 2019 18:04:14 GMT

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

Re: importing xlsx files to sas9.4

Reeza — Tue, 26 Feb 2019 18:12:04 GMT

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

Re: importing xlsx files to sas9.4

sminsky — Tue, 26 Feb 2019 18:51:47 GMT

I am using my own personal computer.

Re: importing xlsx files to sas9.4

SASKiwi — Tue, 26 Feb 2019 19:04:12 GMT

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?

Re: importing xlsx files to sas9.4

Kurt_Bremser — Tue, 26 Feb 2019 19:59:39 GMT

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.

Re: importing xlsx files to sas9.4

Reeza — Tue, 26 Feb 2019 20:44:30 GMT

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

Re: importing xlsx files to sas9.4

sminsky — Tue, 26 Feb 2019 20:55:47 GMT

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

Re: importing xlsx files to sas9.4

SASKiwi — Tue, 26 Feb 2019 21:07:59 GMT

Can you mark the post as answered then please?

Re: importing xlsx files to sas9.4

sminsky — Wed, 27 Feb 2019 04:11:47 GMT

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