I have created testing code as per your requirement. Please find the below testing code. Data test1; input id day1 :mmddyy10. day2 :mmddyy10. day3 :mmddyy10. day4 :mmddyy10. day5 :mmddyy10. ; format day1 day2 day3 day4 day5 mmddyy10. ; datalines ; 1 10/12/2013 10/11/2013 10/10/2013 10/09/2013 10/08/2013 2 11/09/2013 11/08/2013 11/07/2013 11/06/2013 11/05/2013 ; run; proc sort data=test1; by id; run; proc transpose data=test1 out=test1_t; by id; var day1 day2 day3 day4 day5; run; Data test1_t(drop=col1); set test1_t; date_n=col1; day_d=_name_; format date_n date9. ; run; proc sort data=test1_t; by date_n; run; Data test2; input x date :mmddyy10. value ; format date mmddyy10. ; datalines ; 1 10/07/2013 5 1 10/08/2013 10 1 10/09/2013 3 1 10/10/2013 7 ; run; Data test2_(drop=x date ); set test2; date_n=date; format date_n date9. ; run; proc sort data=test2_; by date_n; run; Data test_fin; merge test1_t(in=a) test2_(in=b); by date_n; if a; run; Proc sort data=test_fin; by id; run; *** Transpose the dataset and cretae dataset for date ***; proc transpose data=test_fin out=test_fint1(drop=_name_); by id; var date_n; id day_d; run; *** Transpose the dataset and cretae dataset for value ***; proc transpose data=test_fin out=test_fint2(drop=_name_) suffix=val; by id; var value; id day_d; run; *** Merge Date and value datasets ******; Data test_all; merge test_fint1(in=a) test_fint2(in=b); by id; run;
... View more