Hi @novinosrin Thank you so much for the codes. It does the trick. After running the code on my original data, there came another issue. Due to entry errors, there are some negative payments which cannot be matched with positive payments. In such case, the current codes will not report these unmatched negative payments in the output. Is there a way to still show these unmatched negative payments? For example, if a dataline " 1 230 -1500 " is added to data a and a dataline " 1 231 1400" is added to data b, the current output is id seqnum pay 1 231 1400 Is there a way to show the output as id seqnum pay 1 230 -1500 1 231 1400 Thanks!
... View more