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
STATA or other chat / IRC / live realtime help resource? Codementor?Hi all, I am a newcomer to STATA and diving in to the manuals tutorials helpfiles. and now recently …
dataset description that appears with 'describe' commandHi again folks, the describe command generates an overview of the dataset as well as "a brief descri…
bar graph over two variables: unable to adjust the color of barsHi experts; I am plotting a bar graph that has two variables. My code looks like below: #delimit ;…
Post estimation - dplot - sneopDear stata users, I have been trying to replicate Stewart, M.B., 2004. Semi-nonparametric estimatio…
executing an external programI sometimes send a program to other people. It consists of an ado file that writes out a character f…
Subscribe to:
Post Comments (Atom)
0 Response to Mi merge problem
Post a Comment