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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.