topic Re: Error in Reading Text file in SAS University Edition in SAS Programming

Error in Reading Text file in SAS University Edition

Helannivas — Fri, 14 Apr 2017 16:36:33 GMT

Hi,

I am keen to learn Base SAS, so I have downloaded Oracle VM VIrtual Box and Sas University Edition for my Learining and Practical Purpose.

I have confiured the Oracle VM Virtual Box and created a folder in C Drive as "C:\SASUniversityEdition\myfolders\Test" and configured as Shared folder in ORacle VM(Setting---> Shared folder).

I have created a text file(Emp_test) in C:\SASUniversityEdition\myfolders\Test and tried to access through SAS Studio

data emp_test;
infile '/folders/myfolder/Test/emp_test.txt';
input emp_no emp_name $;
run;

proc print data=emp_test;
run;

But the Base SAS code throws an error as

ERROR: Physical file does not exist, /folders/myfolder/Test/emp_test.txt.

Request to help me to overcome this issue. Thanks in advance.

Re: Error in Reading Text file in SAS University Edition

collinelliot — Fri, 14 Apr 2017 17:14:52 GMT

Looks like a case senitivity issue to me. Make sure your path and file are correct in terms of capitalization.

Re: Error in Reading Text file in SAS University Edition

Reeza — Fri, 14 Apr 2017 18:16:56 GMT

Typo.

It's myfolders

You're missing the s.

Re: Error in Reading Text file in SAS University Edition

Helannivas — Fri, 14 Apr 2017 18:27:03 GMT

Even I have changed the code like below

data emp_test10;
infile '/folders/myfolders/Test/Emp_test.txt'
dlm=',';
input emp_no emp_name $;
run;
proc print data=emp_test10;
run;

But still getting the same error

Re: Error in Reading Text file in SAS University Edition

collinelliot — Fri, 14 Apr 2017 18:34:44 GMT

To me that error means that the file is not there, so double check the path and file name and be sure to make sure that the case is correct?

Re: Error in Reading Text file in SAS University Edition

Reeza — Fri, 14 Apr 2017 18:37:58 GMT

Post your full log.

Also, include snapshots of your myfolders and shared folders set up, it's possible something went wrong there.

Did you restart your VM after setting up the shared folders?

Re: Error in Reading Text file in SAS University Edition

Helannivas — Fri, 14 Apr 2017 18:53:37 GMT

Hi,

Herewith attached the log, Shared folder Screenshot and File Resides Path Screenshot.

Even I have restarted the VM.

Re: Error in Reading Text file in SAS University Edition

Reeza — Fri, 14 Apr 2017 19:31:20 GMT

You should set the shared folder to the myfolders not the Test directory, you've set it to the Test directory.

You can use this, but it's a different structure. I suggest setting it to myfolders first to get the basics going.

Your code should work after this is fixed.

Re: Error in Reading Text file in SAS University Edition

Helannivas — Sat, 15 Apr 2017 03:59:13 GMT

Hi Reeza,

Thanks for your help... Now I can able to access External file from SAS Studio.