sasactivity.blogspot.com >>

Dataset ankit1

data ankit1;
input name $ age emp_id  salary manager_id;
datalines;
ankit 20 1 20000 1
ankit1 21 2 30000 1
amit2 20 4 40000 2
amit 21 3 50000 3
anil 22 5 60000 3
ansu 23 6 70000 3
;
run;
                                                                          Dataset ankit
data ankit;
input name $ age;
datalines;
ankit 23
ankit1 24
amit2 25
amit 25 
ans 12
ansu 13
;
run;



Find out sum of salary  group by each manager (where emp_id = manager_id);


proc sql;
create table t as
select distinct sum(salary) as salary,
       manager_id 
       from ankit1
group by manager_id;
select distinct ankit1.name,t.salary from t,ankit1
where t.manager_id=ankit1.emp_id ;
quit;