topic How to remove records after flag has reached certain value in SAS Programming

How to remove records after flag has reached certain value

UshaLatha — Tue, 21 Nov 2017 14:42:46 GMT

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

Re: How to remove records after flag has reached certain value

PaigeMiller — Tue, 21 Nov 2017 14:51:51 GMT

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;

Re: How to remove records after flag has reached certain value

UshaLatha — Tue, 21 Nov 2017 15:39:51 GMT

Thanks very much !!!

the code is working perfectly