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
Stata Command "myqreg2" exists?I found a do file online where a very renowned economist used "myqreg2" command while estimating qua…
Danish MP's political responsiveness - help with statistical significanceHello everyone Me and a fellow student are currently working on an assignment investigating politic…
Define a dummy with overlapping periodsDear All, I have this dataset Code: * Example generated by -dataex-. To install: ssc install dataex…
Parallel trends graph for staggered difference-in-differencesMost papers that use staggered difference-in-differences seem to use regression evidence instead of …
sample size for test accuracyIs there a preferred method for estimating the required sample size for testing the accuracy of a go…
Subscribe to:
Post Comments (Atom)
0 Response to Merging datasets without uniquely identified observations
Post a Comment