Hi All,
I want records that are 0 before 1 and should not delete 0 after 1, how can I proceed?
Please check below data.
sub | dt | |
1 | 3/8/2022 | 0 |
1 | 3/9/2022 | 0 |
1 | 3/10/2022 | 1 |
1 | 3/11/2022 | 1 |
1 | 3/12/2022 | 0 |
I think this is what you want.
I added an extra sub to make it suitable for by group processing.
data have;
input sub dt :mmddyy10. dummy;
format dt mmddyy10.;
datalines;
1 3/8/2022 0
1 3/9/2022 0
1 3/10/2022 1
1 3/11/2022 1
1 3/12/2022 0
2 3/8/2022 0
2 3/9/2022 0
2 3/10/2022 1
2 3/11/2022 1
2 3/12/2022 0
;
data want;
set have;
by sub;
if first.sub then _iorc_ = 0;
if dummy then _iorc_ = 1;
if _iorc_;
run;
Result
sub dt dummy 1 03/10/2022 1 1 03/11/2022 1 1 03/12/2022 0 2 03/10/2022 1 2 03/11/2022 1 2 03/12/2022 0
Do you want to keep or delete records with 0 before 1?
Do you want this logic to work by ID (sub) ?
either way, delete or flagging both are fine
I think this is what you want.
I added an extra sub to make it suitable for by group processing.
data have;
input sub dt :mmddyy10. dummy;
format dt mmddyy10.;
datalines;
1 3/8/2022 0
1 3/9/2022 0
1 3/10/2022 1
1 3/11/2022 1
1 3/12/2022 0
2 3/8/2022 0
2 3/9/2022 0
2 3/10/2022 1
2 3/11/2022 1
2 3/12/2022 0
;
data want;
set have;
by sub;
if first.sub then _iorc_ = 0;
if dummy then _iorc_ = 1;
if _iorc_;
run;
Result
sub dt dummy 1 03/10/2022 1 1 03/11/2022 1 1 03/12/2022 0 2 03/10/2022 1 2 03/11/2022 1 2 03/12/2022 0
Thank you very much and it's working well.
Anytime 🙂
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.