Sticky-note

Sort data set NEW and update data set TEMP with the mapping information. The data set NEW must be sorted by the FROM variable before its observations can be used to update data set TEMP.

proc sort data=new;
   by from;
data temp;
   update temp new;
   by from;
run;