topic Re: not reading text file in New SAS User

not reading text file

zemaxlight — Wed, 03 Oct 2018 14:41:32 GMT

Hello,

I'm trying to read a simple text file; see below

Data Toads;
	Infile 'C:\SASUniversityEdition\myfolders\ToadJump.txt' dlm=' ';
	Input Toadname $ Weight Jump1 Jump2 Jump3;
Proc print data=toads;
	Title 'SAS Data Set Toads';
run;

I get back a message in the error log that it isn't reading the file.

Why is the path so different from what I put in?

Thanks

Zemaxlight

Re: not reading text file

RW9 — Wed, 03 Oct 2018 14:45:36 GMT

SAS University Edition runs on a virtual machine, which is separate to your actual computer. You need to move the file to the shared folder, where this is depends on if your running virtual machine of Amazon:

https://support.sas.com/software/products/university-edition/faq/SAS_accessdata_Excel.htm

And shared folder:

https://support.sas.com/software/products/university-edition/faq/shared_folder_whatis.htm

Re: not reading text file

Kurt_Bremser — Wed, 03 Oct 2018 14:59:55 GMT

SAS UE is a virtual machine with a small UNIX operating system. To access files, you need to use UNIX-style syntax, and absolute (starting at the root) pathnames.

In order to get access to your desktop storage, you defined the shared folder, and this is found in UNIX as /folder/myfolders.

Your infile statement therefore has to be:

infile '/folders/myfolders/ToadJump.txt' dlm=' ';

Note that UNIX filesystems are case-sensitive.

Re: not reading text file

zemaxlight — Wed, 03 Oct 2018 21:15:03 GMT

Kurt,

Thanks very much, that revised line did the trick. Was really annoying banging my head against the wall trying to figure out what the right solution was without help.

Zemaxlight