topic Re: ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/car.dat. in SAS Studio

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/car.dat.

Anthonytien — Thu, 28 Jan 2016 07:12:27 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 data work.car;

57 infile 'car.dat';

58 input @ 1 Size $3.

59 @ 4 City $15.

60 @19 Country $15.;

61 run;

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/car.dat.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.car may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.00 seconds

63 proc print data=work.car;

64 run;

NOTE: No observations in data set WORK.car.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

68 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Anyone knows how to fixed it? by the way, I use mac. I follow the guide to set up and add to myfolder to a share folder.

Re: ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/car.dat.

Kurt_Bremser — Thu, 28 Jan 2016 07:39:26 GMT

Your INFILE statement specifies only a relative filename, so the SAS process automatically looks for the file in its working directory, which is the location where the SAS process was started.

In a BI server environment, this is a place in the "configuration tree".

To avoid this, you need to specify an absolute pathname, starting with a / (meaning that the path starts in the root directory and includes all subdirectory names up to where the file resides).

Now, if you work with Enterprise Guide and the file resides locally on your PC, you either need to use the import wizard of EG (which automatically transfers the file to the server before running the import data step), or you need to transfer the file yourself to a suitable location on the server (most often your home directory).

To be more specific in helping you, we need further information about your SAS setup.

Re: ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/car.dat.

Reeza — Thu, 28 Jan 2016 16:27:06 GMT

If you set up the myfolders properly, you would not see a warning on the SAS Studio start up page, otherwise you see a warning. You should also be able to navigate to it on the left hand Folders menu.

Assuming the above is true, you can change your infile statement as follows:

 infile '/folders/myfolders/car.dat';

PS. It has to be myfolders, with the s, and I believe its also case sensitive.