Hi all,
hope somebody can help me.
My problem is that i want to generate a dummy variable which equals 1 if two or more dates and two or more target names are equal to each other and two or more acquiror Names are different.
As an example you can see the simplified data below:
The dummy variable should equal 1 for the case that Target C has the same Date and different acquirors, for the other cases the dummy should be 0.
I hope it is understandable what i am trying to do.
Thanks for your answers in advance!
Best,
Andi
hope somebody can help me.
My problem is that i want to generate a dummy variable which equals 1 if two or more dates and two or more target names are equal to each other and two or more acquiror Names are different.
As an example you can see the simplified data below:
| Date | Target Name | Acquiror Name | Dummy |
| 6.25.04 | A | E | 0 |
| 6.28.04 | B | F | 0 |
| 7.7.04 | C | G | 1 |
| 7.7.04 | C | H | 1 |
| 8.7.04 | D | I | 0 |
I hope it is understandable what i am trying to do.
Thanks for your answers in advance!
Best,
Andi
