Dear Statalist,
I am working on a survey type data, i generated a variable of school going children by assigning 0 to none going, 1 to public schools and 2 to private school.
For further analysis i want that the value of this variable appears in the first row of Household or House hold head.
e g data is like this
HHcode member code School
112 Household head .
112 wife .
112 Brother .
112 son 2
and i want it to be like this
HHcode member code School
112 Household head 2
112 wife .
112 Brother .
112 son 2
I have tried a number of options like gen Egen etc as i am new to stata i was unable to figure it out please help me sort out this issue.
I am working on a survey type data, i generated a variable of school going children by assigning 0 to none going, 1 to public schools and 2 to private school.
For further analysis i want that the value of this variable appears in the first row of Household or House hold head.
e g data is like this
HHcode member code School
112 Household head .
112 wife .
112 Brother .
112 son 2
and i want it to be like this
HHcode member code School
112 Household head 2
112 wife .
112 Brother .
112 son 2
I have tried a number of options like gen Egen etc as i am new to stata i was unable to figure it out please help me sort out this issue.
Comment