topic Re: ERROR: Physical file does not exist in New SAS User

ERROR: Physical file does not exist

INuha — Wed, 20 Mar 2019 19:54:15 GMT

Hello all,

I am a new user of SAS university edition. I face this issue when I run the code.

What I should do?

Re: ERROR: Physical file does not exist

PaigeMiller — Wed, 20 Mar 2019 20:01:24 GMT

The place where you told SAS to look for the file is a place where the file does not exist, or the place does not exist.

Please show us the entire SAS log as text (not screen capture), pasted into the window that appears when you click on the {i} icon. Do NOT paste the SAS log text directly into the reply window, click on the {i} icon.

Re: ERROR: Physical file does not exist

INuha — Wed, 20 Mar 2019 20:08:37 GMT

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         DATA mydata;
 74         
 75             INFILE "\\Desktop\SASUniversityEdition\myfolders\students.csv"
 76         
 77             DELIMITER = ","
 78         
 79             MISSOVER DSD
 80         
 81             FIRSTOBS=2;
 82         
 83             /*LRECL=32767;*/
 84         
 85         
 86         
 87             INPUT Gender Age Weghit   Height      BMI   H_status    Married     Ethnicity      Education   Nutr_Prog   Major
 87       ! Dietery_Recom     Food_groups Heathly_choices      Diet_disease      Fiber_recom
 88         
 89         ;
 90         
 91         RUN;
 
 ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/\\Desktop\SASUniversityEdition\myfolders\students.csv.
 NOTE: The SAS System stopped processing this step because of errors.
 WARNING: The data set WORK.MYDATA may be incomplete.  When this step was stopped there were 0 observations and 16 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.01 seconds
       cpu time            0.00 seconds
       
 
 92         
 93         
 94         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 106

Thank you Paige Miller for reply. you can see log text above.

Re: ERROR: Physical file does not exist

jklaverstijn — Wed, 20 Mar 2019 20:14:25 GMT

This looks like the classic confusion between the server responsible for running the SAS code (a Linux host) and the client running SAS Enterprise Guide (a Windows machine).

Server and client do not share their file as is illustrated by the resulting path name containing both forward and back slahses.

If you want to run your code on a file residing on your PC first bring it to the client. There a several ways: use a file transfer tool like Filezilla, WinSCP or use the EG Import Data task to do this. The latter allows you get your file straight into a table as a bonus.

Hope this helps,

-- Jan.

Re: ERROR: Physical file does not exist

Kurt_Bremser — Wed, 20 Mar 2019 20:26:41 GMT

Use /folders/myfolders/students.csv as your path to the file. UE runs in a virtual machine with UNIX (Linux).

Re: ERROR: Physical file does not exist

Reeza — Wed, 20 Mar 2019 22:11:54 GMT

SAS UE runs on the virtual machine you installed and doesn't have access to your entire computer and you don't have access to SAS installation.

To share files between the two OS you need to set up shared drives, which was part of the installation instructions. You called it myfolders.

To work with files, especially at the beginning, place the files in the myfolders folder and access them using the following path:

/folders/myfolders/myFileName.extension

Re: ERROR: Physical file does not exist

INuha — Thu, 21 Mar 2019 20:44:17 GMT

I did this when I installed the SAS UE. I created a UniversityEdition folder/myfolder.

Re: ERROR: Physical file does not exist

Reeza — Thu, 21 Mar 2019 20:47:22 GMT

@INuha wrote:

I did this when I installed the SAS UE. I created a UniversityEdition folder/myfolder.

yes, but you didn't use the path correctly.

You used it as you would see it from the C drive, not how SAS running on the VM see's it.

It's more like working with a file on AWS or a SAS Server.

Instead of:

 "\\Desktop\SASUniversityEdition\myfolders\students.csv"

Use:

"/folders/myfolders/students.csv"

Re: ERROR: Physical file does not exist

Armand_B — Mon, 29 Jun 2020 01:59:55 GMT

@jklaverstijn

Hello sir

i m a new comer starting SAS just 2 hours ago, well after setting up UniversityEdition on my W7 laptop, i tried to type my first SAS program. I end up with the "Physical file does not exist" error..I read all what was suggested on SAS community regarding the issue...It did not help...I saw you advising using a FileTransfer tool (like Filezila) could you tell me more...How to handle it ( save all my files in a folder that SASUniversity edition will access with no troubles)

Regards

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data Demographic;

74 infile "C:\Users\user\VirtualBox VMs\SAS University Edition\F\Mydata.txt";

75 input Gender $ Age Height Weight;

76 run;

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\user\VirtualBox VMs\SAS University

Edition\F\Mydata.txt.

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

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

NOTE: DATA statement a utilisé (Durée totale du traitement) :

real time 0.00 seconds

cpu time 0.00 seconds

77 title "Gender Frequencies";

78 proc freq data=Demographic;

79 tables Gender;

80 run;

NOTE: No observations in data set WORK.DEMOGRAPHIC.

NOTE: PROCEDURE FREQ a utilisé (Durée totale du traitement) :

real time 0.00 seconds

cpu time 0.00 seconds

81 title "Summary Statistics";

82 proc means data=Demographic;

83 var Age Height Weight;

84 run;

NOTE: No observations in data set WORK.DEMOGRAPHIC.

NOTE: PROCEDURE MEANS a utilisé (Durée totale du traitement) :

real time 0.07 seconds

cpu time 0.02 seconds

86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: ERROR: Physical file does not exist

Reeza — Mon, 29 Jun 2020 02:44:47 GMT

Solution is exactly the same as above the file has to be in your myfolders that you set up during the installation and then the path should be the following and is likely case sensitive.

infile "/folders/myfolders/Mydata.txt"