BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
abak
Obsidian | Level 7

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Shmuel
Garnet | Level 18

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

1 REPLY 1
Shmuel
Garnet | Level 18

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.

SAS Innovate 2025: Register Today!

 

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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