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.
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;
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;
Thanks, that takes care of it. The by statement with "notsorted" was what's needed.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.