How to make a single household variable given same household codes with family members with unique id's

[Zain Ali]

I have household codes with unique family id's given by idc. The household code remains the same for all household members The last column "counting" is no of children ages 13 years old or younger. I want to transform/create this to household-level data/variable where I have just the household code and corresponding information on how many children are aged 13 years or younger.
hhcode counting
1102100101 3
1102100102 3
1102100103 2

[Zain Ali]

this is how the original data looks like
hhcode idc counting
1 1 3
1 2 3
1 3 3
2 1 1
2 2 1
2 3 1
2 4 1

[Hunduma Dinsa]

Dear Sir/Madam, Good afternoon
I used for my meta analysis, the command "metaprop case samplesize,random lcols(Author Year) astext(60) by (region) xsize(10) ysize(8)" for subgroup analysis but it comes with I² =. and P=. however when I use "Openmeta analyst" for subgroup analysis I² and P comes with specific value for each group. How can I solve the problem