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 🙂
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.