age at first child

[Yara Issa]

Hello,
I am looking at childless men in the UK and I am using panel data which has 9 waves. childlessness is defined as not having a biological children at age (x). I need to create the dependent variable which is (childless) and that is those men who have not had a biological child by age x. one way to get the age cut off is to look at the age of first child and then deiced the age cut off of childlessness.

I have my panel as this
wave pidp (individual id) hidp (household id) (varlist)

I have these variables in my dataset:
year of first child
fathers'birthday
men

I did this command:
gen ageatfirst= year of first child -fathers'birthday

i think I need to use the hidp to do this command is that right? any advice please

[Sergiy Radyakin]

Much depends on the exact definitions of variables and the organization of the data.

clear all
input wave pidp age yearchild1
1 1 19 .
2 1 24 .
3 1 29 27
4 1 34 27
1 2 30 22
2 2 35 22
3 2 40 22
4 2 45 22
1 3 60 .
2 3 65 .
1 4 40 18
2 4 45 18
3 4 50 18
4 4 55 18
end

list, sepby(pidp)
// keep only males that were childless at age X
local X=25
drop if yearchild1<`X'
contract pidp
drop _freq

display "Persons with these PIDs were childless at age `X':"
list

Results in :

Persons with these PIDs were childless at age 25:
     +------+
     | pidp |
     |------|
  1. |    1 |
  2. |    3 |
     +------+

[Scarlett Scott]

Yara Issa Hello! I was just wondering what variable you used in the Understanding Society Data set for 'year of first child' ? or is this one you have generated yourself - if so, how did you go about doing this? Thanks so much

[Yara Issa]

Scarlett Scott Hello, In the previous post, I wanted to know what is the age cut off to define childlessness in my research. To do so, I have created the variabel "father's age at first child". I have used the following varibles:
gen father's_age_child=lchby4-birthy
where "lchby4" is year of birth - natural child; "birthy" is the responden's year of birth.
I found out that there was only 2% of the sample had their first child after the age of 45; hence this was the age cut off to define childlessness- men who do not have any biological children by age 45.
HIH