--- "Daniel Sepulveda-Adams" wrote:
> I'm having trouble finding the proper command to impute values in a
> given row of data. Hoping someone could direct me appropriately.
>
> Consider a row of data as follows
>
> obs x1 x2 x3 x4 x5
> -- -- -- -- -- --
> 1 2 4 . 5 1
> 2 . 4 1 3 0
> 3 1 . . . 1
>
> What I want to do is to fill-in the missing values as a function of
> the surrounding row/variable values. I presume I want to average a
> given missing-value's surrounding +-3 values and impute accordingly.
Imputing values with a mean is generally not a good idea, a discussion
as to why can be found here:
http://www.stata.com/statalist/archive/2007-12/msg00504.html
In this post you can also find that one alternative is -ice- by Patrick
Royston. You can read more about this in the following Stata Journal
aricles (which you can get from
http://www.stata-journal.com/archives.html )
Royston, P. 2004. Multiple imputation of missing values. Stata Journal
4(3): 227�241.
Royston, P. 2005. Multiple imputation of missing values: update. Stata
Journal 5(2): 188�201.
Royston, P. 2005. Multiple imputation of missing values: Update of ice.
Stata Journal 5(4): 527-536.
Hope this helps,
Maarten
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
__________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
