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