Hi there,
I was using the syntax foreach var of varlist * {summ `var' replace `var' = r(mean) if missing(`var')}
but this seems to have replaced missing data with the complete mean rather than the subscale mean.
If I have items q6, q7, q8, q12, q18, q19 and item q8 is missing. How do I replace q8 with the subscale mean i.e. can I do q6+q7+q12+q18+q19 divided by 6 to replace q8?
So, for example, if the item scores are:
q6: 4
q7: 3
q8: . (missing)
q12: 3
q18: 1
q19: 4
Can I get Stata to sum the other subscale scores and divide by the total number of scores to leave the mean of 2.5 to replace q8 without me having to do this manually?
Hope I explained that ok?
Many thanks for your help in advance,
Mary-Elaine.
Related Posts with replace missing data with the mean of a subscale
svydescribe for mi set dataI have been hunting around and trying everything I can think of but cannot figure out how to get the…
Panel data preparation and xtreg functionHi I am new to econometrics and stata, and appreciate some help for the following qns related to my…
Triple conditions such as relimp==relat==1 do not do what I expect them to do. Why? Where is this behaviour explained?Working on a problem posed in this thread https://www.statalist.org/forums/for...other-variable I di…
the conclusion for the correlation of variablesHi I am doing with panel data ( N=760. T=8) / When I check the correlation of variables the result a…
How to fix heteroskedasticity and autocorrelation on OLSHi I did OLS test for my panel data ( n= 760 and t=8) and checked heteroskedasticity and autocorrela…
Subscribe to:
Post Comments (Atom)
0 Response to replace missing data with the mean of a subscale
Post a Comment