HI @Solly7 . Felt my solution will be more simplified and this worked. you can try this. Data Have ; input policy_no amount ; cards; 1 -500 1 -500 1 500 2 -1000 3 -700 3 700 3 100 ; run; proc sort data=have nodup; by policy_no amount; run; data want; set have; by policy_no amount; if first.policy_no ne last.policy_no; output; run;   ... View more

data new ; input inst firmid age; cards; 1 1 29 1 1 29 2 1 29 2 1 29 3 2 16 3 2 32 4 2 21 4 2 21 ; run; proc sql; create table new1 as select distinct firmid ,inst as nwork, age as total_age from new group by firmid; run; proc sql; create table new2 as select distinct firmid ,count(inst) as cnt, sum(age)as tot from new group by firmid; run;   output is  firmid  cnt  tot 1         2    58 2        3     69   hope this will help. ... View more