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.
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.
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.