- proc sort data=fund_1;
- by fundno lipper_obj_cd;
- run;
- proc sort data=fund_1(keep=fundno lipper_obj_cd) out=fund_2 nodupkey;
- by fundno lipper_obj_cd;
- where lipper_obj_cd NE '';
- run;
- data fund_end;
- merge
- fund_1(in=a)
- fund_2(rename=(lipper_obj_cd=lipper_obj_cd_temp));
- by fundno;
- if a;
- if lipper_obj_cd = '' then lipper_obj_cd = lipper_obj_cd_temp;
- drop lipper_obj_cd_temp;
- run;