Hi,
I have the following issure: Attached is a png-file with three variables:
In the first column you can see the year, in the second column is the number of an individual and in the third is a dummy variable whether the individual had an accident in one of the years or not.
You can see, that each number of an individual appears 4 times, consistent to the number of different years. Now I want to generate a dummy that takes the value 1 if the individual had at least one accident in the four years, zero otherwise.
This would be of great help to me.
If you need further information, feel free to tell me.
Cheers
I have the following issure: Attached is a png-file with three variables:
In the first column you can see the year, in the second column is the number of an individual and in the third is a dummy variable whether the individual had an accident in one of the years or not.
You can see, that each number of an individual appears 4 times, consistent to the number of different years. Now I want to generate a dummy that takes the value 1 if the individual had at least one accident in the four years, zero otherwise.
This would be of great help to me.
If you need further information, feel free to tell me.
Cheers
Comment