Hi, This is missing imputation by average of surrounded values. I had this situation like this before for my analysis. 1. sort by year Retain the non - missing values in a new variable 2. Sort descending year create a another new variable with retain values 3. use the Mean function and replace the missing values using the 2 newly created variables This will work 100% I did it. Sudhakar ... View more

data t;      set dt;      by child disposition;      if first.disposition then seq=1;      else seq+1; run; proc transpose data=t out=trans;      by child disposition ;      var date;      id seq; run; now you will get al the date variables next to next variables so you can compare easily. ... View more

take all mean values to respective Macro variables. Then in the next step use symget or simple if condition to replace the values. Data _null_;      set mean_data;      call symput("Mscore", strip(put(mean_score)));      call symput("Mforum", strip(put(mean_forum)));      call symput("Msubs", strip(put(mean_subs))); run; data hh;      set values;      if score=. then score=&mean_score;      else score=score;      ....      ....      .... run; do the same for other variables, Hope this helps ... View more