topic File Path error "variable is not an object" in SAS Programming

File Path error "variable is not an object"

abak — Mon, 31 Jul 2017 18:29:25 GMT

A rather new SAS user when it comes to pulling in data. Here is the code:

LIBNAME yi 'path';

data test;

infile = yi.filename TERMSTR = LF;

length Year $6;

input Year ForecastOut F25 T25;

run;

Error: Variable yi is not an object

The file is a csv file exported from excel. I would use excel directly but it doesn't seem to work. SAS 9.2 on a unix server.

If I type the path directly it tells me the file cannot be found.

Shmuel — Mon, 31 Jul 2017 18:43:33 GMT

LIBNAME is used to define library of SAS datasets.

INFILE is used without the equal (=) sign to assign external file to read.

When you write 'infile=...' it is as if you want to assign value to a variable called infile.

So, you have matched 3 different tools.

I assume you menat to do:

filename yi  'path/filename'; 
 
data test; 
    infile  yi  TERMSTR = LF;
    length Year $6;
    input Year ForecastOut F25 T25; 
run;

Try to run it. In case of issues post your full log.