Merge in Stata help needed
$10-30 USD
Paid on delivery
I am merging two datasets in Stata and need help. This data is yearly country-directed dyadic disputes. So there are two sides. If the US fights Germany in 1941, 1942, 1943, 1944, and 1945, there are 10 observations for this (US-Ger 1941, US-Ger 1942, and so on as well as Ger-US 1941, Ger-US 1942, and so on). I then have two datasets that I want to merge onto the master data. This is the kilometers distance between pairs of national capitals (say, between Washington, DC and Berlin) and then another dataset that merges a dummy variable indicator onto if there was a civil war in any country within a given year. These should both be a many to many merge ({merge m:m ccode1 ccode 2 year using "pathway"} and {merge m:m ccode1 ccode2 using "pathway"}). The issue is that when I am doing it and dropping those observations that do not merge into the master dataset (directed dyadic yearly observations), it is creating new observations somehow and I don't know how to identify and drop those new observations that are somehow getting created. It should be a pretty straightforward problem but I'll need the code to see how to deal with this in the future.
I have attached the files below. The master dataset that needs everytheing merged into it is called "20202jcrdata".
Project ID: #23554845
About the project
Awarded to:
Hi. I am an expert in Stata and can assist you. Please send a message so that we can discuss more regarding your project.
7 freelancers are bidding on average $31 for this job
Hello, I can help you with your project - Merge in Stata help needed I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed seve More
Hello there, I am an expert STATA statistician and would gladly accept your offer for this project. My professionalism is unmatched and thus you should expect nothing but A+ work. Please consider me, regards.
Hi, I am Ibrahim and I am a data scientist, I have experience in stata and statistics is one of my favorite domains. Please elaborate on the task. Regards, Ibrahim Anjum
hello; "I have read your job - "" "" and understood the requirments. I would be a fantastic fit for this job. Let’s discuss the details of the project, I’m ready and available . Please send me a message so that I ca More
i have knowledge in statistics and excel.i will do this at the earliest. please allocate to me,will complete asap
i am interesting your job ,i will make sure definitely you like my job ,before dead line i will complete my job Thanks & Regards Gangadharan
