topic Import txt file into SAS Web Editor in SAS Programming

Import txt file into SAS Web Editor

lbrennan — Thu, 10 Jul 2014 17:39:21 GMT

I cannot figure out why my code isn't working. I want to use a txt file that is saved on my computer as my data set. This is my code:

data water;

infile 'C:\Users\Laura\Desktop\Household_Consumption.txt'

DLM='09'x;

input #1 address $

persons

housetype $

#2 poweruse

#3 wateruse;

run;

The error that keeps popping up is "Physical file does not exist, /pbr/biconfig/930/Lev1/SASApp/C:\Users\Laura\Desktop\Household_Consumption.txt.

Do I have to save my data set within SAS Web Editor? How?_

Re: Import txt file into SAS Web Editor

Reeza — Thu, 10 Jul 2014 17:45:26 GMT

You say web editor. Can you clarify what type of SAS you're using? Is the the SAS University Edition?

Or are you on a server somewhere?

Re: Import txt file into SAS Web Editor

jakarman — Thu, 10 Jul 2014 17:46:15 GMT

See all other posts on this as you are using Unix not Windows and must definine a connection in your virtual machine to Windows while using in SAS Unix naming.

Re: Import txt file into SAS Web Editor

ballardw — Thu, 10 Jul 2014 17:46:28 GMT

Yet another server related issue. The path

/pbr/biconfig/930/Lev1/SASApp/C:\Users\Laura\Desktop\Household_Consumption.txt

tells you that it is looking at the SERVER which is UNIX of some flavor and not your

windows machine.

You need to tell the server to look at your drive not its.

Re: Import txt file into SAS Web Editor

lbrennan — Thu, 10 Jul 2014 17:47:54 GMT

I'm using SAS On Demand for Academics Web Editor

Re: Import txt file into SAS Web Editor

lbrennan — Thu, 10 Jul 2014 17:50:31 GMT

How do I change my code in order to tell the server to look at my drive?

Re: Import txt file into SAS Web Editor

Reeza — Thu, 10 Jul 2014 17:52:40 GMT

I believe you need to upload your file to the server instead.

Re: Import txt file into SAS Web Editor

lbrennan — Thu, 10 Jul 2014 17:57:33 GMT

That's what I suspected I would need to do, but I am not sure how to do it. Do I need to upload the txt file via code?

Re: Import txt file into SAS Web Editor

Reeza — Thu, 10 Jul 2014 18:02:15 GMT

No, you use FTP.

http://support.sas.com/ondemand/pdf/StoringandAccessingSASFiles.pdf

Re: Import txt file into SAS Web Editor

jakarman — Thu, 10 Jul 2014 18:15:41 GMT

The SAS on demand for academics is a closed environment for students. Only an instructor, the person setting up your course, is allowed to do some uploads (limited space).
You could possible store some data in a location like your Unix-homedir (aside SASUSER). In all cases any Windows naming like your desktop will work.