data import in sas studio / sas-on-demand

MaryA_Marion — Sun, 17 Jan 2021 22:49:33 GMT

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.

Re: data import in sas studio / sas-on-demand

mkeintz — Wed, 20 Jan 2021 03:38:15 GMT

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";

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.

topic Re: data import in sas studio / sas-on-demand in New SAS User

data import in sas studio / sas-on-demand

Re: data import in sas studio / sas-on-demand