topic Re: how to assign super boss in SAS Programming

how to assign super boss

thanikondharish — Mon, 29 Oct 2018 12:16:25 GMT

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
;

Re: how to assign super boss

PeterClemmensen — Mon, 29 Oct 2018 12:18:48 GMT

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;

Re: how to assign super boss

Ksharp — Mon, 29 Oct 2018 13:09:36 GMT

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;

Re: how to assign super boss

Reeza — Mon, 29 Oct 2018 17:30:50 GMT

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.