Excluding last row when importing a file

[dwish]

Hi all,

Hopefully a simple question - what's the best way to exclude the last row of a raw file from being imported into SAS?

I know I can simply take the number of observations minus 1 after importing the data, but would rather condense into one data step if possible.

Thanks!

[Tom · Accepted solution]

data want ;

   infile 'myfile' end=eof ;

   input @ ;

   if eof then delete ;

  input .... ;

run;

[dwish]

Thanks Tom!

[MikeZdeb]

hi ... another idea ...

data new;

infile 'z:\test.txt' end=last;

input a b c;

if ^last;

run;

[Tom]

Now if the last row is being excluded because it is a footnote instead of data you will get a lot of error messages about invalid data on your log.