Dear colleagues,
I am working with a large amount of panel data. However, I noted that I have a large amount of farmers who have the same ID (variable a3) such as in the 2 examples below. I would like to give all these farmers a unique ID.
Problem 1:
- a3 = the ID of the farmer. This ID should be unique, but in the example below, you can see that 3 farmers, from different NUTS3 regions, all have the same ID.
Is there a way to give these 3 farmers a unique ID in an automatic way, distinguishing them by looking at NUTS3?
Problem 2:
- in the next picture in appendix, you can see again that the ID is not unique, and that I clearly have 2 different farmers here. However, this time, you can not distinguish the two farmers by the variable NUTS3, but only by the variable b48 (which is the amount of hectares they own). However, this variable might change slightly over the years. Could there also be a way to give these 2 farmers an unique ID in an automatic way?
Thank you very much for your attention and time!
Janka Vanschoenwinkel
I am working with a large amount of panel data. However, I noted that I have a large amount of farmers who have the same ID (variable a3) such as in the 2 examples below. I would like to give all these farmers a unique ID.
Problem 1:
- a3 = the ID of the farmer. This ID should be unique, but in the example below, you can see that 3 farmers, from different NUTS3 regions, all have the same ID.
Is there a way to give these 3 farmers a unique ID in an automatic way, distinguishing them by looking at NUTS3?
Problem 2:
- in the next picture in appendix, you can see again that the ID is not unique, and that I clearly have 2 different farmers here. However, this time, you can not distinguish the two farmers by the variable NUTS3, but only by the variable b48 (which is the amount of hectares they own). However, this variable might change slightly over the years. Could there also be a way to give these 2 farmers an unique ID in an automatic way?
Thank you very much for your attention and time!
Janka Vanschoenwinkel
Comment