Dear everyone,

I really hope to get your advice. I am merging two dta files using command: merge 1:1 country1 year using Data Statalist Using, keep(match master)
There was no error message after the merge, however when I check the merged data, many of the merged data are wrong. For example the data for country A is put under country B. I try to search online, I guess the problem lies in the format of my id variable “country1”. I create variable country1 using: encode country, gen(country1). However I still don’t know how to fix it. Your help is greatly appreciated. Thank you.