Support #1897

Birth year and birth order of all ever child

Added by Luca Giangregorio 5 months ago. Updated 5 months ago.

Data management
Start date:
% Done:



Dear Support Team,
I aim to derive for each women the birth year, age and birth order of all her child ever had i.e., even before the start of the panel. I would like to do this for both BHPS and UKHLS, although I can use them as cross-sectional, so that it is not necessary to keep the corresponding hhorig values to link the two panels.

However, for my understandings, in both panels does not exist a variable showing the total number of child an individual have had (in UKHLS there's nchild_dv, but it refers to how many children in the household). So, is it necessary to derive it?
Furthermore, to link the birth year and age of child to the corresponding mothers, I can both use INDALL with mndip or INDALL + EGOALT exploiting the relationship (correct?). But in this case, I cannot observe all possible child, so I need to use also the NATCHILD file and the lchdoby variable, right? But what about the BHPS? I cannot find a way to identify all possible children/birth ever had, as it seems there's no information about the non-resident births.

Lastly, I wonder why there are so many inapplicable cases in the newborn file. How can I identify a "birth-event" if there are so many inapplicable cases with no information about year of birth of the supposed new-birth?

Many thanks for your support!

Luca Giangregorio


Updated by Understanding Society User Support Team 5 months ago

  • Category set to Data management
  • Status changed from New to Feedback
  • % Done changed from 0 to 80
  • Private changed from Yes to No

Hi Luca,

I'd suggest the following steps:
1) using xhhrel file to identify all resident children,
2) linking the information on their birth year using pidp,
3) using lchdoby from w_natchild to identify the birth year of non-resident children,
4) deriving the birth order.

It is also worth to have a look at this thread:

We will check the missing values in newborn file.

Best wishes,
UKHLS User Support

Also available in: Atom PDF