DATA Step, Macro, Functions and more

date imputation (proc mi or data step)

Posts: 22

date imputation (proc mi or data step)

[ Edited ]

Hi. This is the structure of my data


id dt_admission dt_discharge

1 3/21/2013 3/24/2013

2 3/23/2014   3/25/2014

3 4/22/2014  4/25/2014

4                    4/24/2015

5                    5/1/2015


For the last two dates, I have to impute dt_admission based on dt_discharge. 


I have two thoughts...


imp_dt _admission = dt_discharge -(specific  number of days)  or 

imp_dt_admission = dt_discharge - (avg(dt_discharge - dt admission)) for entire data


Can anyone provide me proc mi procedure or data procedure for imputation of dates?


Frequent Contributor
Posts: 93

Re: proc mi for date imputation

Out of curiosity, why use proc mi?  Why not write data steps based on the logic that you have provided?

Posts: 22

Re: proc mi for date imputation

Posted in reply to thomp7050
Yes.. That's right. But just a thought on proc mi.
Super User
Posts: 13,942

Re: date imputation (proc mi or data step)

One might ask what the resulting set will be used for.  That may have some impact on building rules.


I can see that further information might be useful in considering building rules such as treatment information. Simple broken bones may have a notably shorter period than an open-hear surgery for instance.


And considering we had another question today about indentifying admissions (possibly multiple) of deceased persons then why admission date is missing becomes kind of interesting.

Ask a Question
Discussion stats
  • 3 replies
  • 3 in conversation