This is my data in the text file.
MPG WEIGHT PRICE
----------------------
22 2930 4099
17 3350 4749
22 2640 3799
20 3250 4816
15 4080 7827
I want to use do loop and array to generate the dadaset. But I am not sure how to deal with the second line, which is dash line. I want to skip it.
This will work as we are trying to read the data from third observation
data have;
infile 'F:\new.txt' firstobs=3 missover;
input MPG WEIGHT PRICE;
run;
This will work as we are trying to read the data from third observation
data have;
infile 'F:\new.txt' firstobs=3 missover;
input MPG WEIGHT PRICE;
run;
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.