About Decay2020

Decay2020 · ‎05-30-2023

Thanks Ksharp. I will surely try this. but is there any way of doing this witthout sorting as the data have millions of rows.

Decay2020 · ‎05-30-2023

please ignore he last column or you can name that column as final. we have date, name, amount_due, paid. amount_due is the amount due in each month and paid is the amount a person paid. we want to subtract the paid amount from amount_due and get the final due amount as given in column 'Final'

Decay2020 · ‎05-29-2023

In row 4, SAM owed 40 (amount due) which got adjusted from what he paid in row 5. In row 5, he owed 50 (amount due) but he paid 100 so this excess amount i.e. 60 (100-40) gets adjusted in row 4. and further the rest that is 20 (60-40) gets adjusted in row 3 And for Sally, in may22, she owed 0 so the final amount is 0. as stated multiple times, we need to adjust the excessive amount to only non-zero previous dues.

Decay2020 · ‎05-29-2023

please ignore the space in the variable name. past months due mean - amount_due in previous months. So you see, in may-22, SAM paid 100, and only 50 was due.. so the extra 50 should get adjusted in the previous months. and likewise. I hope, this makes any sense to you.

Decay2020 · ‎05-29-2023

please feel free to take any date as an example, it hardly matters. we just need see how much a person paid extra and adjust this excessive amount in the past months due (i.e. previous non-zero value).

Decay2020 · ‎05-29-2023

Okay, in essence we are computing 'amount_due - paid'. but if the person has paid more than he due for that month, then the excessive amount gets adjusted in past months due.

Decay2020 · ‎05-29-2023

Hi all, I have the below month wise dataset 'have'. I want data 'final' such that the column 'paid' gets completely netted off (adjust) against non-zero column 'amount_due' and we arrive at coloumn 'final' as shown below in 'final data'. For Example:- In may-22, SAM paid 100, this amount should get distributed to non-zero value in 'amount_due' previous months (amount_due - paid). data Have; infile cards delimiter = ","; input date name$ amount_due paid; cards; 44592,Sam,10,0,10 44620,Sam,20,0,20 44651,Sam,30,0,20 44681,Sam,40,0,0 44712,Sam,50,100,0 44592,Sally,30,0,30 44620,Sally,40,0,40 44651,Sally,50,0,50 44681,Sally,60,0,30 44712,Sally,0,10,0 44742,Sally,20,40,0 ; run; Final data :- Date Name Amount due Paid Final January-22 Sam 10 0 10 February-22 Sam 20 0 20 March-22 Sam 30 0 20 April-22 Sam 40 0 0 May-22 Sam 50 100 0 January-22 Sally 30 0 30 February-22 Sally 40 0 40 March-22 Sally 50 0 50 April-22 Sally 60 0 30 May-22 Sally 0 10 0 June-22 Sally 20 40 0 I hope, I am able to explain the problem. Thanks in advance.

Decay2020 · ‎11-11-2022

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

Decay2020 · ‎11-10-2022

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.

Decay2020 · ‎11-10-2022

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!

Decay2020 · ‎07-21-2022

No, I need to do it using integrity contraints, like primary key or something. not just appending.

Decay2020 · ‎07-21-2022

DATA PRIMARY; INFILE cards delimiter=","; input key$ version$; cards; a,v1 b,v1 c,v1 d,v1 ; run; DATA Secondary; INFILE cards delimiter=","; input key$ version$; cards; a,v1 b,v1 c,v2 d,v2 ; run; Hi guys, I have 2 datasets as above. Now, i need to set integrity constraint on the data 'primary' such that 'version' does not get repeated after appending the data 'secondary'. and if the same version is there then no new rows should get append. Also, i want to display a message for rejected records. So after appending 'secondary' data, the final data should look like below: Data Want; KEY Version A V1 B V1 C V1 D V1 C V2 D V2 Thanks.

Decay2020 · ‎06-29-2022

Oops, thank you.

Decay2020 · ‎06-29-2022

I want to use a macro variable in place of directory name in dcreate function. Can you please let me know how to do it. i use the following command : data _null_; newdirectory =dcreate(‘&mv.’, ‘pathname’); run; but instead of resolving that macro it creates new directory as &mv.

Decay2020 · ‎02-07-2022

Thank you @RobPratt.. this solution works perfectly. But can we update the constraint: sum {i in OBS} col5[i] * col3[i] = sum {i in OBS} col2[i] * col3[i]; into : sumproduct(col5, col3)/sum(col3) = sumproduct(col2,col3)/sum(col3) somehow? as we need to divide the sumproduct with sum of col3. I understand it wont impact the result as it is cancelling out, but still needed.

Online Status	Offline
Date Last Visited	‎05-30-2023 12:17 PM

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Need to adjust the paid amount from non-zero values

Re: adjust recovery against non-zero amount

Re: adjust recovery against non-zero amount

adjust recovery against non-zero amount

Re: getting the values by changing it to reach the target

Re: calculate the values as per the given statement by changing a give...

Re: calling a value using row and column.

Re: mapping different values on basis of row and column

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Re: Need to adjust the paid amount from non-zero values

Need to adjust the paid amount from non-zero values

Re: adjust recovery against non-zero amount

Re: adjust recovery against non-zero amount

adjust recovery against non-zero amount

Re: create integrity constraints

create integrity constraints

Re: Use a macro variable in dcreate function

Use a macro variable in dcreate function

Re: calculate the values as per the given statement by changing a give...