Hello,
I found a post on this subject but the solutions posted do not work for me.
My master data set has 276 variables and 41,000 observations. Two of the variables are an MFIID and MFIName, however these are the same for multiple observations but with different fiscal years.
My secondary dataset has 5 variables and 3115 observations. It also has the variables MFIID and MFIName but has a single observation for each one (to show the country and region of the institution).
I am attempting to combine the two datasets so that each observation in my master dataset includes the corresponding data for country and region from my secondary dataset. I have tried merge 1:m, merge 1:1 and merge m:1 but I always receive the same error message: r(459); variables MFIID MFIName do not uniquely identify observations in the using data.
Is there a way to merge datasets without having a unique identifier?
Thank you
Related Posts with Merging datasets without uniquely identified observations
Infix problem (using invalid varname)Hello, I am trying to read in fixed width data from a .txt file. I am following the documentation f…
How to generate group mean variables for each time?My data is as now code pool time price a1 j1 20190101 1 a1 j1 20190102 2 a1 j2 20180101 …
Store numeric values into memory to use them to create new data setsI have been reading the Statalist for years and I am thrilled to finally join this forum and potenti…
Precision issues with rounding of a variableHello Statalist, I am using Stata 15.1 and would like to request advice regarding a precision issue…
Interpretation when dependent and independent variables are percentagesDear all, I have a problem with the interpretation of my dependent variables. My dependent variable…
Subscribe to:
Post Comments (Atom)
0 Response to Merging datasets without uniquely identified observations
Post a Comment