Select only the first observation within a string of similar observations

Accepted Solution Solved
Reply
Contributor
Posts: 73
Accepted Solution

Select only the first observation within a string of similar observations

[ Edited ]

Capture.PNG

 

In the above table, I now have variables Account, Day and Alert, and would like to obtain Alert_Real. The logic is that for each account, if alerts appear on consecutive days, only the first day of that string of successive alerts is marked in Alert_real, whereas the following days are recorded as no alert. Such cases are highlighted in read. And I would like to do so for each account. Hope I made myself clear. Thanks a lot.


Accepted Solutions
Solution
‎01-20-2016 11:52 AM
Super User
Posts: 5,369

Re: Select only the first observation within a string of similar observations

Assuming your data set is sorted by ACCOUNT:

 

data want;

set have;

by account alert notsorted;

if first.alert then alert_real = alert;

else alert_real=0;

run;

View solution in original post


All Replies
Solution
‎01-20-2016 11:52 AM
Super User
Posts: 5,369

Re: Select only the first observation within a string of similar observations

Assuming your data set is sorted by ACCOUNT:

 

data want;

set have;

by account alert notsorted;

if first.alert then alert_real = alert;

else alert_real=0;

run;

Contributor
Posts: 73

Re: Select only the first observation within a string of similar observations

Thanks, that takes care of it. The by statement with "notsorted" was what's needed.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 276 views
  • 1 like
  • 2 in conversation