Hi family,
I have a data set that the individual household member's information is presented in the wide format instead of the expected long format(row per every household member with repeated hhID if same household).
I tried my best by using the command reshape wide mid1, i(otherhh_id) j(hhnumber) but it didn't work out.
Any help?.
I attached the dataset for your perusal.

Thank you.
Sham