CODEWITHSUNDEEP
sas
Deborah_Watson
Deborah_Watson

Reputation: 307

Error in reading SAS files

I am just playing around with SAS, writing the following code

options nocenter nonumber;

data vag;
infile "C:\Users\Deborah\Desktop\School\STA 318\book\veggies.txt";
input Name $ Code $ Days Number Price;
CostPerSeed = Price / Number;
run;

The location of the file is correct, but the error I am getting ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\Deborah\Desktop\School\STA 318\book\veggies.txt.

What can I do to fix this?

Upvotes: 2

Views: 1278

Answers (1)

Vasilij Nevlev
Vasilij Nevlev

Reputation: 1449

You are working on Unix server, not you local PC. While you are running a local client on your PC (like SAS EG), you can't actually access local resources on your local PC because these resources needs to be made available to Unix box itself.

You have four options: 1. Use an import Wizard in SAS EG. It will generate a data step and will use hidden SAS EG methods to convert your text file and move it as a data set to Unix server where you then can create variables that you want. enter image description here

  1. See if your file system is available to you in SAS EG. Expand your workspace server. You should see "files". Expand to the folder that you are allowed to use and drag&drop your text file into there. enter image description here

  2. Upload files to the unix server using whatever file transfer method is available. Usually you would have some sort of FTP server running.

  3. Also, as Joe suggested, you can install this custom task http://blogs.sas.com/content/sasdummy/2012/12/06/copy-files-in-sas-eg/ It can do a lot better job that step 2 or 3 because it can be part of your process, resolve macro variables and fix file formatting issues between Windows and Unix. Thanks Joe!!

Upvotes: 4

Related Questions