Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Identifying Parents and Children in Household Data

    Hello all,

    I have merged a longitudinal panel data set, so now I have informations for each individual and their household data. I want to identify the spouse for each individual if they have one and also their children, after which I want to find out their year and month of birth, so that I can find newly born children for each wave, to classify as a new dummy variable for BIRTHOFCHILD.

    For context I am using RLMS data.

    The relationship variable between each individual is constructed in a 'matrix' where the text in red is the variable for each relationship in the matrix. I also attach the family roster, and that is what I am trying to use to identify children. The survey is conducted between September of a given year up until January of the next, so I guess I could calculate their age relative to the date of the survey to see if they were born in between the previous and current survey wave. Any feedback, help or comments would be much appreciated. Thank you
    Click image for larger version

Name:	Family Roster.png
Views:	1
Size:	295.3 KB
ID:	1757339
    Click image for larger version

Name:	Family Relationships.png
Views:	4
Size:	300.4 KB
ID:	1757342



    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input double(id_w idind id_i id_h h5 nfm b1_1 idind1 b1_2_1 b1_2_2 b1_1_23 b1_2_23 b1_3 b1_4 b1_5 b1_8)
    5   1 100101 1001 2 2 1  1 . . . . 11 2 1973 2
    5   2 100102 1001 1 2 1  1 . . . . 11 2 1973 2
    5   3 100201 1002 2 4 1  3 . . . . 12 2 1955 3
    5   4 100202 1002 1 4 1  3 . . . . 12 2 1955 3
    5   5 100203 1002 2 4 1  3 . . . . 12 2 1955 3
    5   6 100204 1002 1 4 1  3 . . . . 12 2 1955 3
    5   7 100301 1003 2 1 1  7 . . . . 12 2 1944 3
    5   8 100401 1004 2 1 1  8 . . . . 12 2 1968 1
    5   9 100501 1005 2 2 1  9 . . . . 12 2 1946 2
    5  10 100502 1005 1 2 1  9 . . . . 12 2 1946 2
    5  11 100601 1006 2 3 1 11 . . . . 12 2 1970 2
    5  12 100602 1006 1 3 1 11 . . . . 12 2 1970 2
    5  13 100603 1006 2 3 1 11 . . . . 12 2 1970 2
    5  14 100701 1007 1 2 1 14 . . . .  9 1 1944 3
    5  15 100702 1007 2 2 1 14 . . . .  9 1 1944 3
    5  16 100801 1008 2 2 1 16 . . . . 12 2 1938 2
    5  17 100802 1008 1 2 1 16 . . . . 12 2 1938 2
    5  18 100901 1009 2 4 1 18 . . . . 12 2 1954 2
    5  19 100902 1009 1 4 1 18 . . . . 12 2 1954 2
    5  20 100903 1009 1 4 1 18 . . . . 12 2 1954 2
    5  21 100904 1009 2 4 1 18 . . . . 12 2 1954 2
    5  22 101201 1012 2 4 1 22 . . . . 12 2 1961 2
    5  23 101202 1012 1 4 1 22 . . . . 12 2 1961 2
    5  24 101203 1012 2 4 1 22 . . . . 12 2 1961 2
    5  25 101204 1012 1 4 1 22 . . . . 12 2 1961 2
    5  26 101301 1013 2 2 1 26 . . . . 12 2 1931 4
    5  27 101302 1013 1 2 1 26 . . . . 12 2 1931 4
    5  28 101401 1014 1 3 1 28 . . . . 12 1 1968 2
    5  29 101402 1014 2 3 1 28 . . . . 12 1 1968 2
    5  30 101403 1014 1 3 1 28 . . . . 12 1 1968 2
    5  31 101501 1015 2 1 1 31 . . . . 12 2 1920 4
    5  32 101601 1016 1 4 1 32 . . . . 12 1 1958 3
    5  33 101602 1016 2 4 1 32 . . . . 12 1 1958 3
    5  34 101603 1016 1 4 1 32 . . . . 12 1 1958 3
    5  35 101604 1016 1 4 1 32 . . . . 12 1 1958 3
    5  36 101701 1017 2 4 1 36 . . . . 12 2 1954 2
    5  37 101702 1017 1 4 1 36 . . . . 12 2 1954 2
    5  38 101703 1017 1 4 1 36 . . . . 12 2 1954 2
    5  39 101704 1017 2 4 1 36 . . . . 12 2 1954 2
    5  40 101801 1018 2 3 1 40 . . . . 12 2 1973 2
    5  41 101802 1018 1 3 1 40 . . . . 12 2 1973 2
    5  42 101803 1018 1 3 1 40 . . . . 12 2 1973 2
    5  43 101901 1019 2 3 1 43 . . . . 12 2 1953 2
    5  44 101903 1019 1 3 1 43 . . . . 12 2 1953 2
    5  45 102001 1020 2 4 1 45 . . . . 12 2 1962 2
    5  46 102002 1020 1 4 1 45 . . . . 12 2 1962 2
    5  47 102003 1020 2 4 1 45 . . . . 12 2 1962 2
    5  48 102004 1020 1 4 1 45 . . . . 12 2 1962 2
    5  49 102101 1021 1 1 1 49 . . . . 12 1 1927 4
    5  50 102201 1022 1 2 1 50 . . . .  4 1 1972 2
    5  51 102202 1022 2 2 1 50 . . . .  4 1 1972 2
    5  52 102401 1024 2 2 1 52 . . . . 12 2 1948 2
    5  53 102402 1024 1 2 1 52 . . . . 12 2 1948 2
    5  54 102501 1025 2 1 1 54 . . . . 12 2 1924 4
    5  55 102601 1026 2 2 1 55 . . . . 12 2 1946 2
    5  56 102602 1026 1 2 1 55 . . . . 12 2 1946 2
    5  57 102801 1028 2 2 1 57 . . . . 12 2 1953 2
    5  58 102802 1028 1 2 1 57 . . . . 12 2 1953 2
    5  59 103001 1030 1 5 1 59 . . . . 12 1 1964 2
    5  60 103002 1030 2 5 1 59 . . . . 12 1 1964 2
    5  61 103003 1030 2 5 1 59 . . . . 12 1 1964 2
    5  62 103004 1030 1 5 1 59 . . . . 12 1 1964 2
    5  63 103005 1030 2 5 1 59 . . . . 12 1 1964 2
    5  64 200101 2001 2 5 1 64 . . . . 12 2 1965 2
    5  65 200102 2001 1 5 1 64 . . . . 12 2 1965 2
    5  66 200103 2001 1 5 1 64 . . . . 12 2 1965 2
    5  67 200104 2001 1 5 1 64 . . . . 12 2 1965 2
    5  68 200105 2001 1 5 1 64 . . . . 12 2 1965 2
    5  69 200201 2002 2 2 1 69 . . . . 12 2 1938 2
    5  70 200202 2002 1 2 1 69 . . . . 12 2 1938 2
    5  71 200301 2003 2 1 1 71 . . . . 12 2 1914 1
    5  72 200401 2004 2 3 1 72 . . . . 12 2 1939 2
    5  73 200402 2004 1 3 1 72 . . . . 12 2 1939 2
    5  74 200403 2004 2 3 1 72 . . . . 12 2 1939 2
    5  75 200601 2006 2 5 1 75 . . . . 12 2 1961 2
    5  76 200602 2006 1 5 1 75 . . . . 12 2 1961 2
    5  77 200603 2006 2 5 1 75 . . . . 12 2 1961 2
    5  78 200604 2006 2 5 1 75 . . . . 12 2 1961 2
    5  79 200605 2006 1 5 1 75 . . . . 12 2 1961 2
    5  80 200701 2007 2 2 1 80 . . . . 12 2 1931 1
    5  81 200801 2008 1 2 1 81 . . . . 12 1 1925 2
    5  82 200802 2008 2 2 1 81 . . . . 12 1 1925 2
    5  83 200901 2009 1 2 1 83 . . . . 12 1 1933 2
    5  84 200902 2009 2 2 1 83 . . . . 12 1 1933 2
    5  85 201001 2010 2 4 1 85 . . . . 12 2 1959 2
    5  86 201002 2010 1 4 1 85 . . . . 12 2 1959 2
    5  87 201003 2010 2 4 1 85 . . . . 12 2 1959 2
    5  88 201004 2010 1 4 1 85 . . . . 12 2 1959 2
    5  89 300101 3001 2 3 1 89 . . . . 12 2 1942 2
    5  90 300102 3001 1 3 1 89 . . . . 12 2 1942 2
    5  91 300103 3001 2 3 1 89 . . . . 12 2 1942 2
    5  92 300201 3002 2 7 1 92 . . . . 12 2 1958 2
    5  93 300202 3002 1 7 1 92 . . . . 12 2 1958 2
    5  94 300203 3002 1 7 1 92 . . . . 12 2 1958 2
    5  95 300204 3002 2 7 1 92 . . . . 12 2 1958 2
    5  96 300205 3002 1 7 1 92 . . . . 12 2 1958 2
    5  97 300206 3002 2 7 1 92 . . . . 12 2 1958 2
    5  98 300207 3002 1 7 1 92 . . . . 12 2 1958 2
    5  99 300301 3003 2 3 1 99 . . . . 12 2 1953 4
    5 100 300302 3003 1 3 1 99 . . . . 12 2 1953 4
    end
    label values id_w id_w
    label def id_w 5 " 1994", modify
    label values h5 h5
    label def h5 1 "MALE", modify
    label def h5 2 "FEMALE", modify
    label values b1_1 b1_1
    label def b1_1 1 "HAS AN INDIVIDUAL QUESTIONNAIRE", modify
    label values b1_2_1 b1_2_1
    label values b1_2_2 b1_2_2
    label values b1_1_23 b1_1_23
    label values b1_2_23 b1_2_23
    label values b1_3 b1_3
    label values b1_4 b1_4
    label def b1_4 1 "Male", modify
    label def b1_4 2 "Female", modify
    label values b1_5 b1_5
    label values b1_8 b1_8
    label def b1_8 1 "Has never been married", modify
    label def b1_8 2 "Married", modify
    label def b1_8 3 "Divorced and not married", modify
    label def b1_8 4 "Widower (widow)", modify
    Attached Files
Working...
X