topic Re: reading only the obs from text file except the string in SAS Programming

reading only the obs from text file except the string

deleted_user — Fri, 17 Oct 2008 10:55:57 GMT

Hi,

The below is my text file and I would like to read all the observations except the string "NB: There are 5 observations inserted"

there could be any number of observations and any number of blanks between the last obs and the string

sample.txt

1 2 3 4
4 5 6 8
.
.
2 3 4 5
......
...

NB: There are 5 observations inserted

Revert me back if any doubts on question
Thanks and Regards
sam

Re: reading only the obs from text file except the string

LinusH — Fri, 17 Oct 2008 11:14:25 GMT

Just do a subsetting IF together with SUBSTR(). It could be convenient to use the _INFILE_= option ont INFILE statement.

/Linus

Re: reading only the obs from text file except the string

GertNissen — Mon, 20 Oct 2008 11:58:51 GMT

data test;
infile datalines;
input @;
if substr(_infile_,1,2) = 'NB' then delete;
input a b c e;
datalines;
1 2 3 4
4 5 6 8
2 3 4 5
NB: There are 5 observations inserted
;
run;