Hello, One solution: data have; input ID (Date1-Date4) (:mmddyy10.) ; format date1-date4 date9.; datalines; 1 01/05/2014 . . 02/02/2014 2 . . 03/08/2013 . ; run; data want; set have; array newdate{4}; array date{4}; do i=1 to 4; if not(missing(date{i})) then do; j=sum(j,1); newdate{j}=date{i}; end; end; drop date: i j; format newdate: date9.; run;
... View more
