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
xsmle model not convergingDear statalist, I conducted a spatial durbin model with the following code (the data is available h…
Counting different variable associated with one variableI have a list of patients who have pulmonary nodule treatment with three different types of embolic …
Setting a loop for separate merges - add suffix to tempfiles?I'm currently performing three separate merges and saving the resulting file of each merge as a temp…
Event Study - Multiple Events in Event Window - Calculation of CARDear all, I am currently working on a research project where I am doing an event study on the effec…
Displaying number of observations underneath twoway line plotsHello, I wonder if I could please get advice on how to display the number of observations underneat…
Subscribe to:
Post Comments (Atom)
0 Response to replace missing data with the mean of a subscale
Post a Comment