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!
Related Posts with Combine cases, but keep values from each.
Create an index- Interpreting results: 1-standard-deviation increase in an explanatory variable
- Detrending in Dynamic Panel Data regression
- Interpreting impulse response with log percentage as dependent variable and first difference of share as independent one
- Help with two way fixed effect and event study?
Subscribe to:
Post Comments (Atom)
0 Response to Combine cases, but keep values from each.
Post a Comment