I'd like to combine cases, but in an unusual way -- by keeping values from each.
For example, start with:
id1 id2 date amount
80072 1 7/10/2015 4500
80072 1R 2/24/2013 3600

And end up with:
id1 id2 date amount
80072 2/24/2013 4500

I care less about where I end up with the id1/id2 numbers (they'll eventually be eliminated once I get all interrelated cases down to a single row). But I need to keep the date from one case and the amount from the other, and end up with one row. Help, please? Thanks!