data test;
input familyid individualid spend;
cards;
1 1 11
1 2 14
1 3 23
1 4 25
1 5 27
2 1 26
2 2 13
2 3 15
;
run;
proc sql;
create table temp as
select FamilyId,individualid,spend,SUM(spend) as inpatientexpfamily
from test
group by familyid order by familyid,individualid;
quit;