So my problem is this:
I have a stringvariable with 69 unique values that tells me the position in the household (head of household, child of the head, aunt of the head, spouse of the head, servant of the head, etc. )
i also have a variable that tells me the household number for each individual.
I have already created dummy-variables for head of house, for wife of head, and for child of head.
I want to create a variable that is grouped by household, that contains all the households with a head of household, a child and a spouse ( a nuclear family if you will).
How do i create this variable making sure that families that contain more than a head, a wife and children are not counted also? And also making sure that the household contains all of their children.
So in short: I want to find out how many families ONLY contain a head of household, a wife, and their children.
I really hope that one you brilliant minds out there can help me! I only started learning Stata some months ago, and its a very steap learning curve.
I have a stringvariable with 69 unique values that tells me the position in the household (head of household, child of the head, aunt of the head, spouse of the head, servant of the head, etc. )
i also have a variable that tells me the household number for each individual.
I have already created dummy-variables for head of house, for wife of head, and for child of head.
I want to create a variable that is grouped by household, that contains all the households with a head of household, a child and a spouse ( a nuclear family if you will).
How do i create this variable making sure that families that contain more than a head, a wife and children are not counted also? And also making sure that the household contains all of their children.
So in short: I want to find out how many families ONLY contain a head of household, a wife, and their children.
I really hope that one you brilliant minds out there can help me! I only started learning Stata some months ago, and its a very steap learning curve.
Comment