adjust recovery against non-zero amount

[Decay2020]

Hi all,

I have below table. I want to adjust my recovery column as per ID against any non-zero amount1.

data have;

infile cards delimeter= "," ;

input ID$ amount1 recovery;

cards;

a,10,0

a,20,0

a,30,40

b,0,0

b,10,5

b,20,40

; run;

data WANT:

ID	amount1	recovery	final
A	10	0	10
A	20	0	10
A	30	40	0
B	0	0	0
B	10	5	0
B	20	40	0

Thanks!

[PeterClemmensen]

I don't understand this. Can you explain the exact logic behind the new variable?

[Decay2020]

I need to deduct recovery from amount1. if recovery is more than amount 1 then the remaining balance needs to be deducted from previous non-zero amount1 till the recovery balance is completely set off against amount1.

[PeterClemmensen]

If recovery > amount1 then you want to subtract recovery from amount1? That still does not make sense to me. Why not just set the new var to zero when this is fulfilled?

Please be very specific about the logic.

[Decay2020]

Apologies for any confusion. let me give you an example of "A".
now when we deduct 30-40, the remaining 10 recovery should get deducted from previous non-zero amount1, that is 20-10 = 10