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
teffects - predict pscore, psI estimated the following model before estimating. I need to check the predicted propensity score mo…
Probit regression coefficientsDear all, I have conducted a double-bounded contingent valuation study and analysed it in Stata with…
Assign a label of a variable to a different variable Code: gen x = 1 label var x "this is x" gen y = 2 label var y "this is x" // <- how to automat…
elasticity- price, income etc. do i use a log-log model or employ mfx-eyex?Hi, I am very new to Stata so I apologise for the amateur-ness of my question. How do I calculate pr…
cumulative sum that restarts at 0, if observe "0" in the original column.Hi, I have a simple question. I would like to have a cumulate sum that restarts if observing 0 in th…
Subscribe to:
Post Comments (Atom)
0 Response to Mi merge problem
Post a Comment