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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.