This way, assuming your data is sorted by id and time: data have; input Id     time     award; datalines; 1       1           . 1        2          . 1       3           1 1       4           . 1        5           . ; data want; do until(last.id);   set have; by id;   gotIt = coalesce(gotIt, award);   award = gotIt;   output;   end; drop gotIt; run; proc print data=want noobs; run; PG ... View more

I did....still have not figured out how to do it....Any ideas? ... View more