[Devon Smith]

Thanks as always, Clyde!

[Devon Smith]

Clyde, is there a simple way to find each individual's number of siblings in the household?

[Clyde Schechter]

Again, this only partially possible. At the level of the head's generation, the head and any brother/sister form a sibship. At the generation above, barring an incestuous marriage, the father/mother have no siblings in the household. (If there were such, they would be uncle/aunts, but the data has no such category.) At the generation immediately below the head, all son/daughter relationships form a sibship. But it is impossible to know at the next generation down from there: two grandchildren might be siblings, or just cousins. In general we would expect the husband/wife or spouse of son/daughter relationships not to have siblings in the household, but there could be complicated situations where they do. For example, this could happen if two of the head's children marry partners who are themselves siblings, and all live in the head's household.

So, I think the best we can do is:

gen n_siblings = .

by hhold (id), sort: egen sibship = total(inlist(relationship, 1, 7))
replace n_siblings = sibship - 1 if inlist(relationship, 1, 7)
drop sibship

by hhold (id): egen sibship = total(relationship == 3)
replace n_siblings = sibship - 1 if relationship == 3
drop sibship

by hhold (id): replace n_siblings = 0 if relationship == 6

[Devon Smith]

Thanks, Clyde!