Hello,

I have a dataset that is collected at village (group) level with randomly selected households that have more than one child (observations). Many of the responses on demographic variables are the same. However, information on child-related variables are not the same for each child.

How can I create new observation for additional child within a same household at a same village in stata?
The dataset has village number, village tract number, township code, geographic zone number, region/state number, year, and household number.

Please help.

Thank you.