merging data

[JEBESSA ZELEKE]

Hallo everyone.! i am trying to merge my data set in to make it ready for analysis. in doing so one of my data set has 2 unique ID and the second data set has 3 unique ID. then when i merge it says ''this unique ID can not uniquely identify observations in the using data". so what should i do to solve this problem?

[Clyde Schechter]

It's anybody's guess what you should do when you don't show us what the data sets are like. Please post back with example data from both data sets, using the -dataex- command to do so.* And please say which variables are the ID variables in each data set, and explain which of them you expect to match across the two data sets.

*If you are running version 18, 17, 16 or a fully updated version 15.1 or 14.2, -dataex- is already part of your official Stata installation. If not, run -ssc install dataex- to get it. Either way, run -help dataex- to read the simple instructions for using it. -dataex- will save you time; it is easier and quicker than typing out tables. It includes complete information about aspects of the data that are often critical to answering your question but cannot be seen from tabular displays or screenshots. It also makes it possible for those who want to help you to create a faithful representation of your example to try out their code, which in turn makes it more likely that their answer will actually work in your data.