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
Panal Data copying missing characteristic dataHey guys, I'm using unbalenced panal data and want to copy missing values for "date of birth". In t…
consecutive failures in panel dataHi, I was hoping to get some advice on identifying consecutive failures in panel data. I am lookin…
Advice on interpretation of prtest (two sample test of proportion)Hello everybody, As a student assignment, we are conducting research on how different interventions…
First differencing and fixed effects?Dear all, I am working with a cross-section cross-time panel dataset with N = 15 (country) and T = …
Problem with capture confirm fileI have a folder containing some 70,000 systematically named files which I am going to merge into few…
Subscribe to:
Post Comments (Atom)
0 Response to replace missing data with the mean of a subscale
Post a Comment