topic Re: adjust recovery against non-zero amount in SAS Programming

adjust recovery against non-zero amount

Decay2020 — Thu, 10 Nov 2022 06:38:56 GMT

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!

Re: adjust recovery against non-zero amount

PeterClemmensen — Thu, 10 Nov 2022 12:09:25 GMT

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

Re: adjust recovery against non-zero amount

Decay2020 — Fri, 11 Nov 2022 04:41:59 GMT

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.

Re: adjust recovery against non-zero amount

PeterClemmensen — Fri, 11 Nov 2022 09:49:07 GMT

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.

Re: adjust recovery against non-zero amount

Decay2020 — Fri, 11 Nov 2022 12:33:49 GMT

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