how to assign super boss

[thanikondharish]

data s ;
length emp $ 10 boss $ 10 ;
input emp $ boss ;
cards ;
harish ashok
ashok siva
siva madhavarao
madhavarao ramaya
;

by using above dataset assign super boss like see below

emp              boss                                   superboss

harish            ashok                                 siva
ashok             siva                                    madhavarao                                  
siva                madhavarao                        ramaya
madhavarao   ramaya
;

[PeterClemmensen]

Do like this

data s ;
length emp $ 10 boss $ 10 ;
input emp $ boss ;
cards ;
harish ashok
ashok siva
siva madhavarao
madhavarao ramaya
;

data want;
   merge s s(firstobs=2 rename=(boss=superboss) keep=boss);
run;

[Ksharp]

data s ;
length emp $ 10 boss $ 10 ;
input emp $ boss ;
cards ;
harish ashok
ashok siva
siva madhavarao
madhavarao ramaya
;

proc sql ;
create table want as
 select a.*	,b.boss as super_boss
  from s as a left join s as b
   on a. boss=b.emp;
quit;

[Reeza]

Answer depends on how many levels you need to look up. In the end this is a tree based look up problem. If it's only two levels to define the superboss then it's a trivial double join. If it's more then it's more complicated. PROC BOM will do that though.