How to remove records after flag has reached certain value

[UshaLatha]

Hi all,

I have the following data in my input dataset.

loan_id period DEFAULT_FLAG..

1234     144     0

1234     145     0

1234     146     0

1234     147     0

1234     148     1

1234     149     0

1234     150     1

1234     151     0

In this example, loan_id 1234 and one row for each period. I need only the records until the first time default_flag has value 1.

Following is the expected output:

loan_id period DEFAULT_FLAG..

1234     144     0

1234     145     0

1234     146     0

1234     147     0

1234     148     1

The data is sorted on loan_id and period.

Can anyone please help me achieve this.

Thanks

[PaigeMiller · Accepted solution]

UNTESTED CODE

data want;
    set have;
    by loan_id period;
    if first.loan_id then sum_flag=0;
    sum_flag+default_flag;
    if sum_flag=0 or (sum_flag=1 and default_flag=1) then output;
run;

[UshaLatha]

Thanks very much !!!

the code is working perfectly