Verifying correct construct of motherhood variable | Harmonized BHPS-UKHL
Dear User Support Staff,
I am a master's student using the harmonized BHPS-UKHL dataset, merged according to the resources provided on the website.
My main concern is that I am not sure whether the main sample of my research is constructed correctly: motherhood.
I have seen Gundi's answer in answer #584 on how to create motherhood. However, motherhood does not seem given in BHPS. Therefore, I have constructed it in the following manner:
From the variable “agechy" (=age of the youngest child in HH), I kept only children with age 0 (keep if agechy==0), therefore indicating that they are newborn in the household.
Afterward, mothers are basically those female respondents that have indicated having a child with age 0 in the HH.
Is that the simple correct construct?
My doubt stems from some incongruences in the descriptive statistics. In fact, it might be that my procedure might be overestimating the sample because I might be indicating all females in the household with a child age 0 as a mother.
My research is focused on analyzing the effect of maternity leave on the propensity of mothers to transition towards self-employment, a growing phenomenon also known as ‘Mompreneurship’. Consequently, I need to define mothers, and from here who among them have become self-employed with maternity leave.
Please find attached the simplified version of my do-file.
Looking forward to your answer,
Thank you very much!
Updated by Annette Pasotti 9 months ago
- Status changed from New to Feedback
- Assignee set to Gundi Knies
- % Done changed from 0 to 10
- Private changed from Yes to No
Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.
We aim to respond to simple queries within 48 hours and more complex issues within 7 working days. While we will aim to keep to this response times due to the current coronavirus (COVID-19) related situation it may take us longer to respond.
Updated by Gundi Knies 9 months ago
- Category set to Data analysis
- Assignee changed from Gundi Knies to Francesco Bolzonella
- Priority changed from High to Normal
- Target version set to BHPS
we do not comment on individual analyses or vet Stata programmes. Having said that, there are different ways to go about generating a motherhood indicator, and what is best will depend on your research question. From your reference to my response to a previous query it seems you want to derive the UKHLS variable _newmum for the BHPS cohort.
For this you'd be using the information stored in _newhy & _hgbiom in the indall records: _newhy equals 1 if a new entrant to the household is a new baby. _hgbiom reports the PNO of the biological mother of that new entrant baby. You want to assign a value of 1 to the record of that biological mother and there may be multiple mothers and multiple new babies in the household.
So, the most generic way to tag the new mums is:
use br_hidp br_hgbiom br_newhy if br_newhy==1 using br_indall, clear
rename br_hgbiom br_pno
duplicates drop br_hidp br_pno, force
merge 1:1 br_hidp br_pno using br_indall
replace br_newmum=1 if _merge==3
To check this did the trick:
bysort br_hidp: egen newbaby=sum(br_newhy==1)
sort br_hidp br_pno
li br_hidp br_pno br_newhy br_hgbiom br_newmum if newbaby>0, sepby(br_hidp) noobs
Hope this helps.