Hello everyone!
I have encountered a problem in my analysis for my thesis. Despite having around 2000 observation my regressions indicated only around 1000. I'm working with multiply imputed data and should therefore not have a problem with missing values. I checked anyways to be thorough and found a lot of missing values. This puzzled me a lot since I had checked all my variables along the way. No missing values. After a lot of backtracking I discovered that my data set of mi data where fine. Saved in the "wide" style they showed no missing variables for M=1 to M=5.
Hence, the problem seems to occour during the merge of my data sets (one from 2009 and one from 2010 with different variables). Right after the merge, M=1 through to M=5 showed the same amount of missing values as did M=0, despite showing none before the merge. I'm extremly puzzled and have no idea where I am going wrong.
I used the following commands:
use "file2009.dta", clear
sort respid
mi merge 1:1 respid using "file2010.dta", keep(match)
The 2010 file has also been sorted by respid beforehand. Thank you very much to anyone who can help me.
Greetings Eva
Related Posts with Mi merge problem
Request for help- interpreting results post margins.Hello everyone, I am using probit model in Stata 16.1 to identify [dependent var] whether a firm ch…
separate regression of subgroupsHope you are enjoying the coziness of the weekend or early Monday already!. I have a data set with t…
arellano-bover/blundell-bondHello people, I have a panel data of 9 firms for a period of 11 years with no missing data. In 2017,…
Fixed Effects With Cross Sectional Data - Inconsistent Standard ErrorsDear all I have a cross-sectional dataset organised in three levels Individuals, nested within... …
Free books on Stata programmingHi all, Can anyone recommend free books that provide an introduction to programming with Stata, som…
Subscribe to:
Post Comments (Atom)
0 Response to Mi merge problem
Post a Comment