Hello Fellow SAS Developers, I am trying to merge two tables:- Loss table which consists of two columns i.e ID and Loss amount ID Loss_amount 100 10,000 100 15,000 100 5,000 Recovery Table which consists of two columns i.e ID and recovery amount ID Recovery_amount 100 20,000 I need to combine both the tables and the output should be in such a manner that recovery amount is the maximum of loss amount and the remaining amount is passed on to the next record. For eg:- ID Loss_amount Recovery_amount 100 10,000 10,000 100 15,000 10,000 100 5,000 0
... View more