i am importing an txt file using infile which contains 1st line header and last line footer
i am removing header but how to remove footer form last row
data example;
infile path.txt" firstobs=2
dlm='|' dsd missover ;
attrib name length=$50. informat=$50. format=$50.;
attrib sal length=8 informat=20. format=comma20.2;
input name no;
run;
how to remove footer from that text
data example;
infile path.txt" firstobs=2 end=eof
dlm='|' dsd missover ;
attrib name length=$50. informat=$50. format=$50.;
attrib sal length=8 informat=20. format=comma20.2;
input name no;
if not eof then output;
run;
data example;
infile path.txt" firstobs=2 end=eof
dlm='|' dsd missover ;
attrib name length=$50. informat=$50. format=$50.;
attrib sal length=8 informat=20. format=comma20.2;
input name no;
if not eof then output;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.