BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
hhchenfx
Rhodochrosite | Level 12

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;
1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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;

View solution in original post

2 REPLIES 2
Kurt_Bremser
Super User

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
Rhodochrosite | Level 12

Thank you!

HHC

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1170 views
  • 6 likes
  • 2 in conversation