topic Re: Excluding last row when importing a file in SAS Programming

Excluding last row when importing a file

dwish — Wed, 21 Dec 2011 23:24:59 GMT

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 — Wed, 21 Dec 2011 23:40:53 GMT

data want ;

infile 'myfile' end=eof ;

input @ ;

if eof then delete ;

input .... ;

run;

dwish — Wed, 21 Dec 2011 23:51:27 GMT

Thanks Tom!

MikeZdeb — Thu, 22 Dec 2011 20:05:26 GMT

hi ... another idea ...

data new;

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

input a b c;

if ^last;

run;

Tom — Fri, 23 Dec 2011 02:14:43 GMT

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.