Hello,
I have two datasets:
1) Survey data with birth date info and interview date info
2) ACLED data with conflict date
I want to calculate the number of conflicts in a respondents life, but I am struggling with figuring out a way to do this.Any ideas?
Basically, I need to link two datasets that do not share any commonalities, and this seems annoying in stata because I can't merge or append them.
I need to create an empty conflict_events column in my survey data (conflict_events == 0), Then I need to like run a loop which is like if conflict_date. (in the other dataset) is between birth and interview date (both in the survey data), then add that to conflict_events column in the survey data? But I do not see how I can do that? Any tips would be appreciated! Thanks so much!
I have two datasets:
1) Survey data with birth date info and interview date info
2) ACLED data with conflict date
I want to calculate the number of conflicts in a respondents life, but I am struggling with figuring out a way to do this.Any ideas?
Basically, I need to link two datasets that do not share any commonalities, and this seems annoying in stata because I can't merge or append them.
I need to create an empty conflict_events column in my survey data (conflict_events == 0), Then I need to like run a loop which is like if conflict_date. (in the other dataset) is between birth and interview date (both in the survey data), then add that to conflict_events column in the survey data? But I do not see how I can do that? Any tips would be appreciated! Thanks so much!
Comment