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
Can you mark the post as answered then please?
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?
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.
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
Can you mark the post as answered then please?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.