DATA Step, Macro, Functions and more

File Path error "variable is not an object"

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

File Path error "variable is not an object"

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.


Accepted Solutions
Solution
2 weeks ago
Trusted Advisor
Posts: 1,374

Re: File Path error "variable is not an object"

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.

View solution in original post


All Replies
Solution
2 weeks ago
Trusted Advisor
Posts: 1,374

Re: File Path error "variable is not an object"

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 48 views
  • 0 likes
  • 2 in conversation