Getting an ERROR: Physical file does not exist

[Patro]

Hi, I am using the university edition but I have linked the file to the virtual folder Myfolders which has a subfolder "sasuser.v94" which then contains the file speedsas.xlsx .  I am running on a Mac

I am just new at using this and running out of ideas - I am guessing somehow it is not linked properly

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

72

73 /** Import an XLSX file. **/

74

75 PROC IMPORT DATAFILE="<speedsas.xlsx>"

76 OUT=WORK.MYEXCEL

77 DBMS=XLSX

78 REPLACE;

79 RUN;

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp//<speedsas.

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

[Kurt_Bremser]

I extracted your question from the 2-year old thread that is pretty dead by now.

Don't post your question in other people's old thread, open your own.

You obviously work with University Edition, which runs in a Linux virtual machine on your Mac. You have to use an absolute path for your file that starts at the system root of the virtual machine, otherwise the program will look for your file on the current working directory, where it won't find it.

Also do not put anything into the sasuser.v94 directory, it is the place for the SASUER library and nothing else.

So move your Excel file to your myfolders with the Mac Finder, and then use this code:

proc import
  datafile="/folders/myfolders/speedsas.xlsx"
  out=work.myexcel
  dbmes=xlsx
  replace
;
run;

Make sure that your spelling of the filename is correct, as the UNIX systems of your Mac and the VM are case sensitive.