Generating Household Number using Sequential household member data

[Fariha Zaman]

Hi! I am also using HIES data for my research, but I do not have the variable household number. Can anyone suggest how can I generate it? I have id_Code of household members. In other words, I have sequence of household members, but I do not have the household number, I have added a picture for reference. How can I generate it.

[Fariha Zaman]

S1AQ00 is the id_code or the sequence of household member

[Nick Cox]

If you don't get a good answer please follow https://www.statalist.org/forums/help#stata and give a data example using dataex, not a screenshot.

[Fariha Zaman]

My problem was solved.
[[gen head = S1AQ00 == 1]
[gen hhold = 1000 + sum(head == 1 & head[_n-1] == 0) + 1
[replace hhold = hhold[_n-1] if missing(hhold)]