Keep data after the first row having non-missing

[hhchenfx]

Hi,

I want to keep all row after the first non-missing value row (including this first non-missing row)

For the data below, I want to keep:

3 1 2
4 1 .
5 1 3

and

2 2 2
3 2 .

Can you please help?

Thank you,

HHC

data have;
input date id value;
datalines;
1 1 .
2 1 .
3 1 2
4 1 .
5 1 3
1 2 .
2 2 2
3 2 .
;run;

[Kurt_Bremser · Accepted solution]

Use a RETAINed flag:

data want;
set have;
by id;
retain flag;
if first.id then flag = 0;
if value ne . then flag = 1; /* alternatively: flag = flag or (value ne .) */
if flag;
drop flag;
run;

[hhchenfx]

Thank you!

HHC