data import in sas studio / sas-on-demand

[MaryA_Marion]

Hello,

I think I have control of data import and then as now I find I do not know it as well as I would like.

The enclosed snapshot shows the location of the input file.

The log is given below:

75         *classes.txt is in myfolders in SAS STUDIO;
 76         filename gpa "/folders/myfolders/classes2.txt";
 78         options linesize=140 pagesize=5000;
 84         data gpa; infile gpa delimiter=';' truncover dsd;
 92         input
 . . .
 106        run;
 
 ERROR: Physical file does not exist, /folders/myfolders/classes2.txt.
 NOTE: The SAS System stopped processing this step because of errors.
 WARNING: The data set WORK.GPA may be incomplete.  When this step was stopped there were 0 observations and 12 variables.
 WARNING: Data set WORK.GPA was not replaced because this step was stopped.

How to fix?  Thanks.

MM

[mkeintz · Accepted solution]

The PDF you posted shows classes2.txt to be a file in your home directory, which commonly can be represented by a tilde (~).

So try changing 

filename gpa "/folders/myfolders/classes2.txt";

to

filename gpa "~/classes2.txt";

Your home directory, in absolute terms, is probably something like   /home/odaws01-usw2, which (if correct) would require you to use

filename gpa "/home/odaws01-usw2/classes2.txt";

It's a lot easier to use the ~ symbol.