Dear all,
My data has about 700 observations with missing months of birth and I am trying to fill in those missing values. I am thinking of two options, among others. The first option is to choose 30 June or 1 July for the missing values because those dates are the middle of year. The second one is to assign a random number from 1-12 to the missing values. Any suggestion on how to do the 2nd option in Stata is highly appreciated. Thank you.
Data
My data has about 700 observations with missing months of birth and I am trying to fill in those missing values. I am thinking of two options, among others. The first option is to choose 30 June or 1 July for the missing values because those dates are the middle of year. The second one is to assign a random number from 1-12 to the missing values. Any suggestion on how to do the 2nd option in Stata is highly appreciated. Thank you.
Data
Code:
* Example generated by -dataex-. For more info, type help dataex clear input double id byte mob int yob 42063 . . 38067 . 1982 46079 . 1973 38024 . 1984 31047 . 1977 33118 . 1981 42059 . 1977 42027 . 1975 38010 . 1984 37061 . 1965 38017 . 1979 46038 . 1970 12003 . 1981 33046 . 1988 8098 . 1983 37092 . 1974 33071 . 1986 42038 . 1988 31033 . 1967 42067 . 1975 end
Comment