Hi,
Can anyone help me calculating household size by household ID (not repeated hhsize by repeated hhid as below) from the below date example:
Here 'hhid' means 'household ID' and 'pid' means 'person ID'
clear
input float hhsize double hhid float pid
4 1 1
4 1 1
4 1 2
4 1 3
4 1 4
3 2 1
3 2 2
3 2 3
4 3 1
4 3 2
4 3 3
end
Thank you so much, Rumana
Can anyone help me calculating household size by household ID (not repeated hhsize by repeated hhid as below) from the below date example:
Here 'hhid' means 'household ID' and 'pid' means 'person ID'
clear
input float hhsize double hhid float pid
4 1 1
4 1 1
4 1 2
4 1 3
4 1 4
3 2 1
3 2 2
3 2 3
4 3 1
4 3 2
4 3 3
end
Thank you so much, Rumana
Comment