Hi there!
I am having trouble trying to xtset my dta file in stata. My data looks something like this:
Panel_id web_id year other_variables,,,
4 123 2006 5
4 245 2010 6
6 354 2006 9
6 685 2010 10
. 657 2010 10
. 654 2006 9
I have been trying to find a solution to this for the past 3 days and I cannot seem to get it. What am I doing wrong? I know the panel_id is a duplicate and that is where the problem lies. But, how to eliminate the duplicate panel_ id, and what do I do for those missing panel_id that have a another web_id. For clarification, panel_id tell me whether the same firm was surveyed in 2006 and 2010. The web_id does not tell me that.
Thanks for your help!!
I am having trouble trying to xtset my dta file in stata. My data looks something like this:
Panel_id web_id year other_variables,,,
4 123 2006 5
4 245 2010 6
6 354 2006 9
6 685 2010 10
. 657 2010 10
. 654 2006 9
I have been trying to find a solution to this for the past 3 days and I cannot seem to get it. What am I doing wrong? I know the panel_id is a duplicate and that is where the problem lies. But, how to eliminate the duplicate panel_ id, and what do I do for those missing panel_id that have a another web_id. For clarification, panel_id tell me whether the same firm was surveyed in 2006 and 2010. The web_id does not tell me that.
Thanks for your help!!
Comment