I am working on an unadjusted mixed effects regression looking at changes in several scale scores from baseline to 6-months follow-up and adjusting for clustering at the participant level using long data.
We have already imputed scores for anyone who had at least 75% of any given scale complete, which has left 1-2 participants with missing data for any given scale at baseline or 6-months. Because of this, in the regression output, there are some groups (i.e., participants) for whom there is one observation (min observations per group = 1) when it should always be two (each time point).
I am wondering if Stata ignores any groups for which there is missing data at one of the time points, or if I need to restrict to drop these rows and if so, would that mean I need to reshape the data to wide in order to restrict to cases where the scale score complete at both time points.
I am already restricting to rows with complete data for the outcome and to participants that we are considering "on study" at baseline AND 6-months (base_and_6mo_complete), but this still allows cases for which the variable is only missing at one time point. The mixed effects code is below:
Thanks in advance for any guidance!
We have already imputed scores for anyone who had at least 75% of any given scale complete, which has left 1-2 participants with missing data for any given scale at baseline or 6-months. Because of this, in the regression output, there are some groups (i.e., participants) for whom there is one observation (min observations per group = 1) when it should always be two (each time point).
I am wondering if Stata ignores any groups for which there is missing data at one of the time points, or if I need to restrict to drop these rows and if so, would that mean I need to reshape the data to wide in order to restrict to cases where the scale score complete at both time points.
I am already restricting to rows with complete data for the outcome and to participants that we are considering "on study" at baseline AND 6-months (base_and_6mo_complete), but this still allows cases for which the variable is only missing at one time point. The mixed effects code is below:
Code:
foreach var of varlist OUTCOMES { mixed `var' i.VISIT || id: if `var' !=. & base_and_6mo_complete==1 }
Thanks in advance for any guidance!
Comment