Merge in Stata help needed

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".

Skills: Statistics, Statistical Analysis, SPSS Statistics, Excel

See more: stata append multiple datasets, stata merge multiple datasets, stata merge duplicate observations, merge wide stata, stata merge if, merge already defined stata, many to one merge stata, stata merge two variables, excel project help needed, getafreelancer message sql query help needed, python projects help needed, marketing help needed, photography portfolio help needed, visual start help needed, programmers help needed, virtuemart help needed, salesforce help needed, help needed readers writers, data entry help needed, joomla help needed

About the Employer:
( 5 reviews ) San Diego, United States

Project ID: #23554845

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.

$20 USD in 1 day
(48 Reviews)

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

$100 USD in 2 days
(332 Reviews)

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.

$20 USD in 7 days
(61 Reviews)

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

$10 USD in 4 days
(33 Reviews)

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

$20 USD in 7 days
(0 Reviews)

i have knowledge in statistics and excel.i will do this at the earliest. please allocate to me,will complete asap

$30 USD in 2 days
(0 Reviews)

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

$14 USD in 7 days
(0 Reviews)