Hi Rahul   below can do the trick   data abc1; retain score; set abc(rename=(score=score2)); if score2 ne . then score=score2; drop score2; run; ... View more

Hi try below code, from your output exsample I think this will work. data test; input start end_o id d1 d2 d3 ; informat start date9. end_o date9. ; format start date9. end_o date9. ; datalines; 1jan95 20sep95 10 23 11 13 10feb96 21may98 10 9 8 10 20jan95 30apr95 10 11 17 16 1jan95 30dec95 10 23 11 43 3jan95 20may95 10 12 13 9 3feb10 28apr12 11 9 8 10 10feb99 21may00 11 9 8 10 20jan95 30apr00 11 11 17 16 1jan95 30dec95 11 23 11 43 ; proc print; run; proc sort data=test; by start end_o id; run; proc transpose data=test out=test1(rename=(col1=director)); by start end_o id; var d:; run; proc sort data=test1 out=test2(drop=_name_); by id director start end_o id; run; ... View more