I'm trying to convert birth year written as '11jun1965' to age variable in Stata. With the following code, I could not generate the current age

Question

I used the following code but all I got was '.' for all age categories

gen agenew=int((birthyear)/365.25)
gen agenew = date("7/16/2020", "MDY") - date("birthyear", "MDY")
replace agenew=agenew/365.25
replace agenew=floor(agenew)```

Please give examples of the values of the variable `birthyear`, — Nick Cox, Jul 16 '21 at 16:20
That is, is `birthyear` a string variable or a numeric variable with daily date display format? — Nick Cox, Jul 16 '21 at 16:33

score 1 · Answer 1 · answered Jul 16 '21 at 18:54

Making a lot of assumptions as you have not included a lot of details about the format of the data you have and not about the format of age you want, but you should be able to modify this code to make it work:

* Example generated by -dataex-. For more info, type help dataex
clear
input str9 birthyear
"11jun1965"
end

*Convert varialbe from string to date variable
gen birthyear_dateformat = date(birthyear, "DMY")
format birthyear_dateformat %td

*Get the year of birth
gen year = year(birthyear_dateformat)

*Get the age from the year of birth variable
gen age = 2021 - year

I'm trying to convert birth year written as '11jun1965' to age variable in Stata. With the following code, I could not generate the current age

1 Answers1