topic Keep data after the first row having non-missing in SAS Programming

Keep data after the first row having non-missing

hhchenfx — Thu, 23 Feb 2023 05:36:56 GMT

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;

Re: Keep data after the first row having non-missing

Kurt_Bremser — Thu, 23 Feb 2023 06:57:25 GMT

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;

Re: Keep data after the first row having non-missing

hhchenfx — Thu, 23 Feb 2023 18:36:37 GMT

Thank you!

HHC