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

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

Ddormer — Sat, 09 Dec 2017 22:42:03 GMT

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.

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

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

73 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

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

Patrick — Sun, 10 Dec 2017 00:41:22 GMT

@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?

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

Reeza — Sun, 10 Dec 2017 04:29:41 GMT

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

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

Ddormer — Sun, 10 Dec 2017 14:52:22 GMT

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!