ERROR: Physical file does not exist. Trying to import an Excel file using University Edition

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

ERROR: Physical file does not exist. Trying to import an Excel file using University Edition

Hi,

 

I'm trying to import an Excel file into SAS University Edition running on Oracle VirtualBox on a Windows 10 PC.  I've read and tried quite a few posts and solutions, but haven't found the problem.  I've shared myfolder in Windows and set it up in VM.  I can see the folders and files in the Files and Folders tab in SAS Studio.  I have no trouble accessing other files in the shared folder for training exercises.  I've tried placing the input file in both "myfolders" and in a sub directory.  It must be some rookie mistake. 

 

From the Error message, it appears that I have a problem with the shared folder.  Looking for assistance.

 

Thanks in advance for your assistance.

 

Below is my log:

 

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
NOTE: ODS statements in the SAS Studio environment may disable some output features.
62
63 %let path=/folders/myfolders/BRFSS15;
64 libname Food "&path";
NOTE: Libref FOOD refers to the same physical library as ORION.
WARNING: Library FOOD does not exist.
NOTE: Libref FOOD was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders/BRFSS15
65
66 Proc Import datafile='folders/myfolders/BRFSS15/foodsecuritydatafile2017.xlsx'
67 Out=work.food
68 DBMS=XLSx
69 Replace;
70 Run;
 
ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/folders/myfolders/BRFSS15//foodsecuritydatafile2017.xlsx.
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
 
71
72
73 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
86
 

 


Accepted Solutions
Solution
‎12-10-2017 09:52 AM
Respected Advisor
Posts: 4,284

Re: ERROR: Physical file does not exist. Trying to import an Excel file using University Edition

@Ddormer

There is potentially more than one issue you have to deal with.

 

The first one:

You're using a relative path in your Proc Import syntax -  datafile='folders/my....' . I guess that's a typo and you just will have to add the beginning slash or you could also use something like: datafile="&path/foodsecuritydatafile2017.xlsx"

 

The second one:

WARNING: Library FOOD does not exist.

That kind of indicates that the path as such doesn't exist. Does library ORION work when you try to access data from it?

View solution in original post


All Replies
Solution
‎12-10-2017 09:52 AM
Respected Advisor
Posts: 4,284

Re: ERROR: Physical file does not exist. Trying to import an Excel file using University Edition

@Ddormer

There is potentially more than one issue you have to deal with.

 

The first one:

You're using a relative path in your Proc Import syntax -  datafile='folders/my....' . I guess that's a typo and you just will have to add the beginning slash or you could also use something like: datafile="&path/foodsecuritydatafile2017.xlsx"

 

The second one:

WARNING: Library FOOD does not exist.

That kind of indicates that the path as such doesn't exist. Does library ORION work when you try to access data from it?

Occasional Contributor
Posts: 11

Re: ERROR: Physical file does not exist. Trying to import an Excel file using University Edition

Thanks to @Patrick and @Reeza:  I didn't "see" the leading "/".  Then, as Patrick suggested, I had screwed up the shared files settings in my efforts to fix things.  Resetting shared files and adding the back-slash solved the problem.

 

This is my first time using the community.  I am impressed and grateful with the prompt and accurate responses.  Feeling very encouraged.

 

Thank you both!

Super User
Posts: 21,546

Re: ERROR: Physical file does not exist. Trying to import an Excel file using University Edition

You forgot the / in front of folders in the datafile option. 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 178 views
  • 0 likes
  • 3 in conversation