03-30-2017 02:51 AM
I am getting the below error, when i try to excecute infile statement.
I have also set up a shared folder
ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\SASUniversityEdition\Myfolder\name.csv.
Attached is the snap shot.
Kindly help me. I am using windows.
03-30-2017 03:37 AM
Please provide the FILENAME statement if used or the INFILE statement.
The most likely problem is a typo in the path or filename, or if using a macro the resolved macro filename or infile has a problem.
03-30-2017 04:16 AM
I changed the code as said and below is the same.
infile 'C:/SASUniversityEdition/Myfolder/name.csv' dlm=' ' dsd missover firstobs=2;
input Name $ Age;
but still i get the below error in the log file
ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:/SASUniversityEdition/Myfolder/name.csv.
03-30-2017 04:54 AM
because your version of SAS University Edition is looking for the file *INSIDE* the virtual machine. that location in pink above is the "inside the VM" default path. So SAS is appending your INFILE location with the "inside" location. You used an INCORRECT infile statement and so, SAS had no choice but to look *INSIDE* the VM for the file.
please goi through bellow link . it will help u.
03-30-2017 08:32 AM
I tried, but i am getting the same error. below is the code:
%let path= C:/SASUniversityEdition/Myfolder;
infile "&path/name.csv" dlm=' ' dsd missover firstobs=2;
input Name $ Age;
Also attached is the snap shot of the configuration done in vm Virtual box for the shared folder.
thanks in advance
03-30-2017 08:50 AM
Go back and read that post from Cynthia, line by line please.
The instrructuons are there. Or search out multiple posts like this in Analytics U forum - and I'll move your question there as well.
03-30-2017 09:32 AM - edited 03-30-2017 09:35 AM
SAS UE is running in a virtual Unix machine. Because if this it cannot see your Windows paths.
When you installed SAS UE you told your virtual machine software to map your Windows path
to this location in the Unix file system.
So in your SAS code you need to use the Unix path to the files.
%let path= /folders/myfolders ; data getdata; infile "&path/name.csv" truncover firstobs=2; input Name $ Age; run;