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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.