Hello, new here. I know that there are variables for youngest and oldest children in a household. I’m wondering whether there’s a way for me to determine number of children in a household born after, say, 2003.
Is the following possible?
(1) Group persons into households, which seems possible because data is rectangularized.
(2) Make a new variable that indicates whether person was born after 2003 (year of survey - age will give me year born, and from there I can determine Yes/No born before 2003)
(3) Make a new variable again, summing up the number of persons born after 2003
Should this work?
Thanks for any insight!