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
[putdocx] problem about tostring with comma, table fontHello. I am making some report using -putdocx- command. My data is like following result table. C…
How to get the standard errors for marginal effects that is calculated based on estimated coefficients and a spatial matrix?I am calculated the long-run and short-run marginal effects of a variable in a spatial dynamic panel…
Saving intermediate matrices from a loop using post?Dear Stata community, I want to save matrices from each iteration of an r-class program which I am …
Getting end date of the monthDear all, Suppose I have the following dataset Code: clear input str8 yearmonth "1960m1" "1960m2…
CrosstabulationsHi- Why does the sample size need to be larger if the table is bigger than a 2x2 for cross tabulatio…
Subscribe to:
Post Comments (Atom)
0 Response to Mi merge problem
Post a Comment