Hello, I’m trying to match my ‘treatment’ dataset with two control datasets – control1 and control2. Here are the rules: I match treatment firms against control firms based on SIC2, fyear and the closest asset. Each treatment firm must have one match in 'control1' AND one match in 'control2'. In other words, matched treatment firms must have 2 control firms, selected from two groups. Any unmatched firm (even if it has one control from either group) should be deleted. My final result should append matched observations from all three groups (treatment, control1, and control2). In addition, there should be three columns indicating whether the observation is from treatment, control1 or control2. In the attachment, I’ve some sample data along with my expected result. I highly appreciate your cooperation.
... View more