Groups | Search | Server Info | Login | Register

Groups > comp.soft-sys.sas > #943

Re: Imputation using the adjacent timepoints data

Show all headers | View raw

First you create a dataset where each record contain the current value, the 
one before, and one after.  If current value is missing, then you populate 
it with the average of adjacent values.

What do you want to do if two consecutive time points are missing?

"Learner"  wrote in message 
news:c707b472-cefb-4e51-877e-007d9b52de3e@r35g2000prj.googlegroups.com...

I have large data with the scores recorded at different time points in
10 days. But there are intermittent missing scores for some time
points and I need to impute the scores based on the average of the
available scores from adjacent time points. Can some one help me in
coding please?

Thanks 

Back to comp.soft-sys.sas | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Imputation using the adjacent timepoints data Learner <pradev@gmail.com> - 2011-06-16 07:31 -0700
  Re: Imputation using the adjacent timepoints data "Kenneth M. Lin" <kenneth_m_lin@sbcglobal.net> - 2011-06-16 07:43 -0700
    Re: Imputation using the adjacent timepoints data Learner <pradev@gmail.com> - 2011-06-16 07:50 -0700

csiph-web