Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 2
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    vlookup generates same id

    I read the thread on Complicated Vlookup-type problem in a large dataset.

    I am facing a similar problem with my research.
    I was able to generate grandmaid separate from momid. In other words the grandmaid generated is not a duplicate of momid. However when I generate grandpaid. its the same as grandmaid.
    Why does vlookup do that?
    Tags: None
  • #2
    vlookup is from http://www.stata.com/users/kcrow (FAQ Advice #12).

    However when I generate grandpaid. its the same as grandmaid.
    That makes sense if the set of siblings used to create these identifiers consists of full siblings. But does that matter? The values of such identifiers are arbitrary, so you need to explain under what circumstances this will be problematic (assuming these are different variables).
    • 1 like

    Comment

    • #3
      https://www.statalist.org/forums/for...-large-dataset is the link alluded to in #1

      Comment

      • #4
        Originally posted by Andrew Musau View Post
        vlookup is from http://www.stata.com/users/kcrow (FAQ Advice #12).



        That makes sense if the set of siblings used to create these identifiers consists of full siblings. But does that matter? The values of such identifiers are arbitrary, so you need to explain under what circumstances this will be problematic (assuming these are different variables).
        I'm using a longitudinal household survey with a couple of waves. So im trying to see if either of the grandparents moving away from a joint family to a nuclear setup has any effect on the learning outcomes of the grandchild. So the effect of grandma and grandpa moving out is hypothesized to be different.

        Comment

        • #5
          Wrt to this link https://www.statalist.org/forums/for...-large-dataset, if I destring after I create; gen IDPERSON(profileid in that eg)=blankvar, then the momid and grandmaid turns out to be the same.
          If I destring before I create IDPERSON=blankvar, momid and grandmaid are not the same. However, I just found out, in this second case the newvariable blankvar that was supposed to be equal to IDPERSON is in fact not equal to IDPERSON.
          In my eg
          ID_mom is momid and ID_father is fatherid. grandmother is grandmaid .


          * Example generated by -dataex-. To install: ssc install dataex
          clear
          input double IDPERSON float blankvar double ID_mom float grandmother double ID_father float grandfather
          1020110009 1020110016 10201010107 . 10201010169 .
          1020110007 1020110016 102010101 . 102010101 .
          1020120008 1020120000 10201020104 10201020416 10201020103 10201020416
          10201020116 10201020416 102010201 . 102010201 .
          10201030105 10201029632 10201030102 10201029632 10201030101 10201029632
          10201030101 10201029632 10201030175 . 10201030169 .
          10201040105 10201039872 10201040102 10201039872 10201040101 10201039872
          10201040103 10201039872 10201040102 10201039872 10201040101 10201039872
          10201050103 10201050112 102010501 . 10201050101 10201050112
          10201050101 10201050112 10201050175 . 10201050175 .
          10201060110 10201060352 10201060175 . 10201060101 10201060352
          10201060101 10201060352 10201060175 . 10201060175 .
          10201070105 10201070592 10201070102 10201070592 10201070101 10201070592
          10201070107 10201070592 10201070102 10201070592 10201070101 10201070592
          10201080103 10201079808 10201080102 10201079808 10201080101 10201079808
          10201080106 10201079808 10201080102 10201079808 10201080101 10201079808
          10201090201 10201090048 10201090169 . 10201090175 .
          10201090106 10201090048 10201090101 10201090048 10201090175 .
          10201090108 10201090048 10201090201 10201090048 10201090275 .
          10201090101 10201090048 102010902 . 102010902 .
          10201100105 1.02011e+10 10201100113 1.02011e+10 10201100175 .
          10201100101 1.02011e+10 10201100113 1.02011e+10 10201100175 .
          10201110101 10201110528 10201110169 . 10201110175 .
          10201110101 10201110528 10201110169 . 10201110175 .
          10201120103 10201119744 10201120102 10201119744 10201120101 10201119744
          10201120101 10201119744 10201120169 . 10201120169 .
          10201130105 10201129984 10201130102 10201129984 10201130101 10201129984
          10201130107 10201129984 10201130102 10201129984 10201130101 10201129984
          10201140106 10201140224 10201140102 10201140224 10201140101 10201140224
          10201140102 10201140224 102011401 . 102011401 .
          10201160105 10201159680 10201160104 10201159680 10201160103 10201159680
          10201160106 10201159680 10201160104 10201159680 10201160103 10201159680
          10201170104 10201169920 10201170102 10201169920 10201170101 .
          10201170102 10201169920 102011701 . 102011701 .
          10201180112 10201180160 10201180169 . 10201180169 .
          10201180109 10201180160 10201180111 10201180160 10201180175 .
          10201190101 10201190400 10201190169 . 10201190169 .
          10201190106 10201190400 10201190102 10201190400 10201190101 10201190400
          10201200103 1.02012e+10 10201200102 1.02012e+10 10201200101 1.02012e+10
          10201200105 1.02012e+10 10201200104 1.02012e+10 10201200103 1.02012e+10
          10202010101 10202009600 10202010169 . 10202010169 .
          1020210003 1020209984 10202010102 10202009600 10202010101 10202009600
          10202020107 10202019840 10202020102 10202019840 10202020101 10202019840
          1020220007 1020220032 10202020102 10202019840 10202020101 10202019840
          10202030105 10202030080 10202030102 10202030080 10202030101 10202030080
          10202030104 10202030080 10202030102 10202030080 10202030101 10202030080
          10202040104 10202040320 10202040102 10202040320 10202040101 10202040320
          10202040101 10202040320 10202040175 . 10202040175 .
          10202050101 10202050560 102020501 . 102020501 .
          10202050102 10202050560 10202050169 . 10202050169 .
          10202060103 10202059776 10202060102 10202059776 10202060101 10202059776
          10202060106 10202059776 10202060102 10202059776 10202060101 10202059776
          10202070104 10202070016 10202070169 . 10202070169 .
          10202070102 10202070016 10202070175 . 10202070175 .
          10202080103 10202080256 10202080102 10202080256 10202080101 10202080256
          10202080107 10202080256 10202080102 10202080256 10202080101 10202080256
          10202090101 10202090496 10202090175 . 10202090175 .
          10202090103 10202090496 10202090102 10202090496 10202090101 10202090496
          10202100103 1.02021e+10 10202100102 1.02021e+10 10202100101 1.02021e+10
          10202100102 1.02021e+10 102021001 . 102021001 .
          10202110101 10202109952 10202110175 . 10202110175 .
          10202110107 10202109952 10202110102 10202109952 10202110101 10202109952
          10202120206 10202120192 10202120102 10202120192 10202120101 10202120192
          10202120105 10202120192 10202120102 10202120192 10202120101 10202120192
          10202120201 10202120192 10202120275 . 10202120275 .
          10202120102 10202120192 102021202 . 102021202 .
          10202120103 10202120192 10202120302 10202120192 10202120301 10202120192
          10202120301 10202120192 10202120369 . 10202120369 .
          10202130105 10202130432 10202130104 10202130432 10202130103 10202130432
          10202130101 10202130432 10202130175 . 10202130175 .
          10202140105 10202139648 10202140102 10202139648 10202140101 10202139648
          10202140102 10202139648 102021401 . 102021401 .
          10202150105 10202149888 10202150102 10202149888 10202150101 10202149888
          10202150101 10202149888 10202150107 10202149888 10202150175 .
          10202160105 10202160128 10202160102 10202160128 10202160101 10202160128
          10202160102 10202160128 102021601 . 102021601 .
          10202170105 10202170368 10202170102 10202170368 10202170101 10202170368
          10202170102 10202170368 10202170169 . 10202170169 .
          10202180102 10202180608 102021801 . 102021801 .
          10202180104 10202180608 10202180102 10202180608 10202180101 10202180608
          10202190106 10202189824 10202190102 10202189824 10202190101 10202189824
          10202190104 10202189824 10202190102 10202189824 10202190101 10202189824
          10202200105 1.02022e+10 10202200102 1.02022e+10 10202200101 1.02022e+10
          10202200104 1.02022e+10 10202200102 1.02022e+10 10202200101 1.02022e+10
          10203010110 10203010048 102030101 . 102030101 .
          1020310002 1020310016 102030101 . 102030101 .
          10203020102 10203020288 10203020169 . 10203020169 .
          10203020103 10203020288 10203020102 10203020288 10203020101 10203020288
          10203040101 10203039744 10203040175 . 10203040175 .
          10203040106 10203039744 10203040175 . 10203040101 10203039744
          10203050101 10203049984 10203050175 . 10203050175 .
          10203050106 10203049984 10203050102 10203049984 10203050101 10203049984
          10203060107 10203060224 10203060104 10203060224 10203060103 10203060224
          10203060113 10203060224 10203060102 10203060224 10203060101 10203060224
          10203070103 10203070464 10203070102 10203070464 10203070101 10203070464
          10203070107 10203070464 10203070102 10203070464 10203070101 10203070464
          10203080105 10203079680 10203080104 10203079680 10203080103 10203079680
          10203080106 10203079680 10203080104 10203079680 10203080103 10203079680
          10203080201 10203080704 10203080275 . 10203080275 .
          10203080104 10203079680 102030802 . 102030802 .
          end
          [/CODE]
          Last edited by Sara George; 28 Oct 2022, 09:26.

          Comment

          • #6
            See

            Code:
            help precision
            My guess is that you generate variables from these identifiers and are not careful to specify that their values be held in double precision. That is why your wanted variables end up as floats. Try

            Code:
            * Example generated by -dataex-. To install: ssc install dataex
clear
input double IDPERSON float blankvar double ID_mom float grandmother double ID_father float grandfather
1020110009 1020110016 10201010107 . 10201010169 .
1020110007 1020110016 102010101 . 102010101 .
1020120008 1020120000 10201020104 10201020416 10201020103 10201020416
10201020116 10201020416 102010201 . 102010201 .
10201030105 10201029632 10201030102 10201029632 10201030101 10201029632
10201030101 10201029632 10201030175 . 10201030169 .
10201040105 10201039872 10201040102 10201039872 10201040101 10201039872
10201040103 10201039872 10201040102 10201039872 10201040101 10201039872
10201050103 10201050112 102010501 . 10201050101 10201050112
10201050101 10201050112 10201050175 . 10201050175 .
10201060110 10201060352 10201060175 . 10201060101 10201060352
10201060101 10201060352 10201060175 . 10201060175 .
10201070105 10201070592 10201070102 10201070592 10201070101 10201070592
10201070107 10201070592 10201070102 10201070592 10201070101 10201070592
10201080103 10201079808 10201080102 10201079808 10201080101 10201079808
10201080106 10201079808 10201080102 10201079808 10201080101 10201079808
10201090201 10201090048 10201090169 . 10201090175 .
10201090106 10201090048 10201090101 10201090048 10201090175 .
10201090108 10201090048 10201090201 10201090048 10201090275 .
10201090101 10201090048 102010902 . 102010902 .
10201100105 1.02011e+10 10201100113 1.02011e+10 10201100175 .
10201100101 1.02011e+10 10201100113 1.02011e+10 10201100175 .
10201110101 10201110528 10201110169 . 10201110175 .
10201110101 10201110528 10201110169 . 10201110175 .
10201120103 10201119744 10201120102 10201119744 10201120101 10201119744
10201120101 10201119744 10201120169 . 10201120169 .
10201130105 10201129984 10201130102 10201129984 10201130101 10201129984
10201130107 10201129984 10201130102 10201129984 10201130101 10201129984
10201140106 10201140224 10201140102 10201140224 10201140101 10201140224
10201140102 10201140224 102011401 . 102011401 .
10201160105 10201159680 10201160104 10201159680 10201160103 10201159680
10201160106 10201159680 10201160104 10201159680 10201160103 10201159680
10201170104 10201169920 10201170102 10201169920 10201170101 .
10201170102 10201169920 102011701 . 102011701 .
10201180112 10201180160 10201180169 . 10201180169 .
10201180109 10201180160 10201180111 10201180160 10201180175 .
10201190101 10201190400 10201190169 . 10201190169 .
10201190106 10201190400 10201190102 10201190400 10201190101 10201190400
10201200103 1.02012e+10 10201200102 1.02012e+10 10201200101 1.02012e+10
10201200105 1.02012e+10 10201200104 1.02012e+10 10201200103 1.02012e+10
10202010101 10202009600 10202010169 . 10202010169 .
1020210003 1020209984 10202010102 10202009600 10202010101 10202009600
10202020107 10202019840 10202020102 10202019840 10202020101 10202019840
1020220007 1020220032 10202020102 10202019840 10202020101 10202019840
10202030105 10202030080 10202030102 10202030080 10202030101 10202030080
10202030104 10202030080 10202030102 10202030080 10202030101 10202030080
10202040104 10202040320 10202040102 10202040320 10202040101 10202040320
10202040101 10202040320 10202040175 . 10202040175 .
10202050101 10202050560 102020501 . 102020501 .
10202050102 10202050560 10202050169 . 10202050169 .
10202060103 10202059776 10202060102 10202059776 10202060101 10202059776
10202060106 10202059776 10202060102 10202059776 10202060101 10202059776
10202070104 10202070016 10202070169 . 10202070169 .
10202070102 10202070016 10202070175 . 10202070175 .
10202080103 10202080256 10202080102 10202080256 10202080101 10202080256
10202080107 10202080256 10202080102 10202080256 10202080101 10202080256
10202090101 10202090496 10202090175 . 10202090175 .
10202090103 10202090496 10202090102 10202090496 10202090101 10202090496
10202100103 1.02021e+10 10202100102 1.02021e+10 10202100101 1.02021e+10
10202100102 1.02021e+10 102021001 . 102021001 .
10202110101 10202109952 10202110175 . 10202110175 .
10202110107 10202109952 10202110102 10202109952 10202110101 10202109952
10202120206 10202120192 10202120102 10202120192 10202120101 10202120192
10202120105 10202120192 10202120102 10202120192 10202120101 10202120192
10202120201 10202120192 10202120275 . 10202120275 .
10202120102 10202120192 102021202 . 102021202 .
10202120103 10202120192 10202120302 10202120192 10202120301 10202120192
10202120301 10202120192 10202120369 . 10202120369 .
10202130105 10202130432 10202130104 10202130432 10202130103 10202130432
10202130101 10202130432 10202130175 . 10202130175 .
10202140105 10202139648 10202140102 10202139648 10202140101 10202139648
10202140102 10202139648 102021401 . 102021401 .
10202150105 10202149888 10202150102 10202149888 10202150101 10202149888
10202150101 10202149888 10202150107 10202149888 10202150175 .
10202160105 10202160128 10202160102 10202160128 10202160101 10202160128
10202160102 10202160128 102021601 . 102021601 .
10202170105 10202170368 10202170102 10202170368 10202170101 10202170368
10202170102 10202170368 10202170169 . 10202170169 .
10202180102 10202180608 102021801 . 102021801 .
10202180104 10202180608 10202180102 10202180608 10202180101 10202180608
10202190106 10202189824 10202190102 10202189824 10202190101 10202189824
10202190104 10202189824 10202190102 10202189824 10202190101 10202189824
10202200105 1.02022e+10 10202200102 1.02022e+10 10202200101 1.02022e+10
10202200104 1.02022e+10 10202200102 1.02022e+10 10202200101 1.02022e+10
10203010110 10203010048 102030101 . 102030101 .
1020310002 1020310016 102030101 . 102030101 .
10203020102 10203020288 10203020169 . 10203020169 .
10203020103 10203020288 10203020102 10203020288 10203020101 10203020288
10203040101 10203039744 10203040175 . 10203040175 .
10203040106 10203039744 10203040175 . 10203040101 10203039744
10203050101 10203049984 10203050175 . 10203050175 .
10203050106 10203049984 10203050102 10203049984 10203050101 10203049984
10203060107 10203060224 10203060104 10203060224 10203060103 10203060224
10203060113 10203060224 10203060102 10203060224 10203060101 10203060224
10203070103 10203070464 10203070102 10203070464 10203070101 10203070464
10203070107 10203070464 10203070102 10203070464 10203070101 10203070464
10203080105 10203079680 10203080104 10203079680 10203080103 10203079680
10203080106 10203079680 10203080104 10203079680 10203080103 10203079680
10203080201 10203080704 10203080275 . 10203080275 .
10203080104 10203079680 102030802 . 102030802 .
end

format IDPERSON ID_mom ID_father %13.0f
drop blankvar grandmother grandfather

foreach p in mom father{
     frame put IDPERSON ID_`p', into(grand`p')
     frame grand`p': rename (IDPERSON ID_`p') (ID_`p' ID_grand`p')
     frame grand`p': duplicates drop *, force
     frlink m:1 ID_`p', frame(grand`p')
     frget ID_grand`p', from(grand`p')
     frame drop grand`p'
}
drop grandmom grandfather
            Res.:

            Code:
            . l, sep(0)

     +---------------------------------------------------------------------+
     |    IDPERSON        ID_mom     ID_father   ID_grandmom   ID_grandf~r |
     |---------------------------------------------------------------------|
  1. |  1020110009   10201010107   10201010169             .             . |
  2. |  1020110007     102010101     102010101             .             . |
  3. |  1020120008   10201020104   10201020103             .             . |
  4. | 10201020116     102010201     102010201             .             . |
  5. | 10201030105   10201030102   10201030101             .   10201030169 |
  6. | 10201030101   10201030175   10201030169             .             . |
  7. | 10201040105   10201040102   10201040101             .             . |
  8. | 10201040103   10201040102   10201040101             .             . |
  9. | 10201050103     102010501   10201050101             .   10201050175 |
 10. | 10201050101   10201050175   10201050175             .             . |
 11. | 10201060110   10201060175   10201060101             .   10201060175 |
 12. | 10201060101   10201060175   10201060175             .             . |
 13. | 10201070105   10201070102   10201070101             .             . |
 14. | 10201070107   10201070102   10201070101             .             . |
 15. | 10201080103   10201080102   10201080101             .             . |
 16. | 10201080106   10201080102   10201080101             .             . |
 17. | 10201090201   10201090169   10201090175             .             . |
 18. | 10201090106   10201090101   10201090175     102010902             . |
 19. | 10201090108   10201090201   10201090275   10201090169             . |
 20. | 10201090101     102010902     102010902             .             . |
 21. | 10201100105   10201100113   10201100175             .             . |
 22. | 10201100101   10201100113   10201100175             .             . |
 23. | 10201110101   10201110169   10201110175             .             . |
 24. | 10201110101   10201110169   10201110175             .             . |
 25. | 10201120103   10201120102   10201120101             .   10201120169 |
 26. | 10201120101   10201120169   10201120169             .             . |
 27. | 10201130105   10201130102   10201130101             .             . |
 28. | 10201130107   10201130102   10201130101             .             . |
 29. | 10201140106   10201140102   10201140101     102011401             . |
 30. | 10201140102     102011401     102011401             .             . |
 31. | 10201160105   10201160104   10201160103             .             . |
 32. | 10201160106   10201160104   10201160103             .             . |
 33. | 10201170104   10201170102   10201170101     102011701             . |
 34. | 10201170102     102011701     102011701             .             . |
 35. | 10201180112   10201180169   10201180169             .             . |
 36. | 10201180109   10201180111   10201180175             .             . |
 37. | 10201190101   10201190169   10201190169             .             . |
 38. | 10201190106   10201190102   10201190101             .   10201190169 |
 39. | 10201200103   10201200102   10201200101             .             . |
 40. | 10201200105   10201200104   10201200103             .   10201200101 |
 41. | 10202010101   10202010169   10202010169             .             . |
 42. |  1020210003   10202010102   10202010101             .   10202010169 |
 43. | 10202020107   10202020102   10202020101             .             . |
 44. |  1020220007   10202020102   10202020101             .             . |
 45. | 10202030105   10202030102   10202030101             .             . |
 46. | 10202030104   10202030102   10202030101             .             . |
 47. | 10202040104   10202040102   10202040101             .   10202040175 |
 48. | 10202040101   10202040175   10202040175             .             . |
 49. | 10202050101     102020501     102020501             .             . |
 50. | 10202050102   10202050169   10202050169             .             . |
 51. | 10202060103   10202060102   10202060101             .             . |
 52. | 10202060106   10202060102   10202060101             .             . |
 53. | 10202070104   10202070169   10202070169             .             . |
 54. | 10202070102   10202070175   10202070175             .             . |
 55. | 10202080103   10202080102   10202080101             .             . |
 56. | 10202080107   10202080102   10202080101             .             . |
 57. | 10202090101   10202090175   10202090175             .             . |
 58. | 10202090103   10202090102   10202090101             .   10202090175 |
 59. | 10202100103   10202100102   10202100101     102021001             . |
 60. | 10202100102     102021001     102021001             .             . |
 61. | 10202110101   10202110175   10202110175             .             . |
 62. | 10202110107   10202110102   10202110101             .   10202110175 |
 63. | 10202120206   10202120102   10202120101     102021202             . |
 64. | 10202120105   10202120102   10202120101     102021202             . |
 65. | 10202120201   10202120275   10202120275             .             . |
 66. | 10202120102     102021202     102021202             .             . |
 67. | 10202120103   10202120302   10202120301             .   10202120369 |
 68. | 10202120301   10202120369   10202120369             .             . |
 69. | 10202130105   10202130104   10202130103             .             . |
 70. | 10202130101   10202130175   10202130175             .             . |
 71. | 10202140105   10202140102   10202140101     102021401             . |
 72. | 10202140102     102021401     102021401             .             . |
 73. | 10202150105   10202150102   10202150101             .   10202150175 |
 74. | 10202150101   10202150107   10202150175             .             . |
 75. | 10202160105   10202160102   10202160101     102021601             . |
 76. | 10202160102     102021601     102021601             .             . |
 77. | 10202170105   10202170102   10202170101   10202170169             . |
 78. | 10202170102   10202170169   10202170169             .             . |
 79. | 10202180102     102021801     102021801             .             . |
 80. | 10202180104   10202180102   10202180101     102021801             . |
 81. | 10202190106   10202190102   10202190101             .             . |
 82. | 10202190104   10202190102   10202190101             .             . |
 83. | 10202200105   10202200102   10202200101             .             . |
 84. | 10202200104   10202200102   10202200101             .             . |
 85. | 10203010110     102030101     102030101             .             . |
 86. |  1020310002     102030101     102030101             .             . |
 87. | 10203020102   10203020169   10203020169             .             . |
 88. | 10203020103   10203020102   10203020101   10203020169             . |
 89. | 10203040101   10203040175   10203040175             .             . |
 90. | 10203040106   10203040175   10203040101             .   10203040175 |
 91. | 10203050101   10203050175   10203050175             .             . |
 92. | 10203050106   10203050102   10203050101             .   10203050175 |
 93. | 10203060107   10203060104   10203060103             .             . |
 94. | 10203060113   10203060102   10203060101             .             . |
 95. | 10203070103   10203070102   10203070101             .             . |
 96. | 10203070107   10203070102   10203070101             .             . |
 97. | 10203080105   10203080104   10203080103     102030802             . |
 98. | 10203080106   10203080104   10203080103     102030802             . |
 99. | 10203080201   10203080275   10203080275             .             . |
100. | 10203080104     102030802     102030802             .             . |
     +---------------------------------------------------------------------+

            Comment

            • #7
              Thank you very much.
              There are two issues though

              This frame command, frgrt and frlink commands arent working. What package am I supposed to be looking for after I type finddit-?

              after I destring and then create
              gen IDPERSON=blankvar, why isn't blankvar same as IDPERSON, the values are different. Is that also an issue with format specification?

              Comment

              • #8
                Im using Stata 14.0 MP

                Comment

                • #9
                  I understand frame commands are only available from Stata16. Could I get help on coding this in Stata14 please.

                  Comment

                  • #10
                    Originally posted by Sara George View Post
                    after I destring and then create
                    gen IDPERSON=blankvar, why isn't blankvar same as IDPERSON, the values are different. Is that also an issue with format specification?
                    I suggested that you read the documentation on precision in #6 which would have answered your question. Your values are too large to be held as floats, and the default storage type in Stata is float. You need to explicitly tell Stata to hold the values in double precision.

                    Code:
                    g double blankvar= IDPERSON

                    Could I get help on coding this in Stata14 please.
                    For your future posts, you need to state your version of Stata if it is not the current version (presently, Version 17). Please provide a data example before destringing as your posts above do not make it clear what is the original individual identifier.

                    Comment

                    • #11
                      Before destringing
                      Code:
                      
	
                      Code:
                      
	
                      
	
                      Code:
                      
	
                      * Example generated by -dataex-. To install: ssc install dataex
clear
input str12(IDPERSON ID_mom ID_father)
"01020101003"  "010201001002" "010201001001"
"01020101005"  "010201001002" "010201001001"
"01020101006"  "010201001002" "010201001001"
"01020102003"  "010201002002" "010201002001"
"01020102005"  "010201002004" "010201002003"
"01020102006"  "010201002004" "010201002003"
"01020102007"  "010201002004" "010201002003"
"01020102008"  "010201002002" "010201002001"
"01020102010"  "010201002009" "010201002008"
"01020102011"  "010201002009" "010201002008"
"01020102012"  "010201002002" "010201002001"
"01020102014"  "010201002013" "010201002012"
"01020103003"  "010201003002" "010201003001"
"01020103004"  "010201003002" "010201003001"
"01020103005"  "010201003002" "010201003001"
"01020103006"  "010201003002" "010201003001"
"01020103007"  "010201003002" "010201003001"
"01020104003"  "010201004002" "010201004001"
"01020104004"  "010201004002" "010201004001"
"01020104005"  "010201004002" "010201004001"
"01020105002"  "010201005075" "010201005001"
"01020105006"  "010201005003" "010201005002"
"01020105007"  "010201005003" "010201005002"
"01020105008"  "010201005003" "010201005002"
"01020105009"  "010201005003" "010201005002"
"01020105010"  "010201005003" "010201005002"
"01020106012"  "010201006075" "010201006001"
"01020106013"  "010201006075" "010201006001"
"01020106015"  "010201006075" "010201006001"
"01020107003"  "010201007002" "010201007001"
"01020107004"  "010201007002" "010201007001"
"01020107006"  "010201007002" "010201007001"
"01020107007"  "010201007002" "010201007001"
"01020107008"  "010201007002" "010201007001"
"01020107009"  "010201007002" "010201007001"
"01020108003"  "010201008002" "010201008001"
"01020108004"  "010201008002" "010201008001"
"01020108005"  "010201008002" "010201008001"
"01020108006"  "010201008002" "010201008001"
"01020109003"  "010201009002" "010201009001"
"01020109004"  "010201009002" "010201009001"
"01020109005"  "010201009002" "010201009001"
"01020109006"  "010201009002" "010201009001"
"01020109007"  "010201009002" "010201009001"
"01020109008"  "010201009002" "010201009001"
"01020109009"  "010201009002" "010201009001"
"01020110001"  "010201010111" "010201010175"
"01020110003"  "010201010111" "010201010175"
"01020110004"  "010201010111" "010201010175"
"01020110005"  "010201010111" "010201010175"
"01020110006"  "010201010111" "010201010175"
"01020110008"  "010201010107" "010201010169"
"01020110009"  "010201010107" "010201010169"
"01020110010"  "010201010107" "010201010169"
"01020112003"  "010201012002" "010201012001"
"01020112004"  "010201012002" "010201012001"
"01020113003"  "010201013002" "010201013001"
"01020113004"  "010201013002" "010201013001"
"01020113005"  "010201013002" "010201013001"
"01020113006"  "010201013002" "010201013001"
"01020113007"  "010201013002" "010201013001"
"01020114003"  "010201014002" "010201014001"
"01020114004"  "010201014002" "010201014001"
"01020114005"  "010201014002" "010201014001"
"01020114006"  "010201014002" "010201014001"
"01020114007"  "010201014002" "010201014001"
"01020116003"  "010201016002" "010201016001"
"01020116005"  "010201016004" "010201016003"
"01020116006"  "010201016004" "010201016003"
"01020116007"  "010201016004" "010201016003"
"01020116008"  "010201016002" "010201016001"
"01020117002"  "010201017001" "010201017050"
"01020117003"  "010201017001" "010201017050"
"01020117004"  "010201017001" "010201017050"
"01020117005"  "010201017001" "010201017050"
"01020118003"  "010201018002" "010201018001"
"01020118004"  "010201018002" "010201018001"
"01020118006"  "010201018005" "010201018004"
"01020118007"  "010201018005" "010201018004"
"01020118008"  "010201018005" "010201018004"
"01020118009"  "010201018002" "010201018001"
"01020119003"  "010201019002" "010201019001"
"01020119004"  "010201019002" "010201019001"
"01020119005"  "010201019002" "010201019001"
"01020119006"  "010201019002" "010201019001"
"010201020102" "010201020175" "010201020101"
"01020120003"  "010201020102" "010201020101"
"010201020104" "010201020103" "010201020102"
"01020120005"  "010201020104" "010201020103"
"010201020106" "010201020103" "010201020102"
"010201020107" "010201020175" "010201020101"
"01020120008"  "010201020104" "010201020103"
"010201020109" "010201020108" "010201020107"
"010201020110" "010201020108" "010201020107"
"010201020112" "010201020175" "010201020101"
"010201020114" "010201020113" "010201020112"
"010201030101" "010201030175" "010201030169"
"010201030103" "010201030102" "010201030101"
"010201030104" "010201030102" "010201030101"
"010201030105" "010201030102" "010201030101"
end
                      Last edited by Sara George; 29 Oct 2022, 07:19.

                      Comment

                      • #12
                        Code:
                        * Example generated by -dataex-. To install: ssc install dataex
clear
input str12(IDPERSON ID_mom ID_father)
"01020101003"  "010201001002" "010201001001"
"01020101005"  "010201001002" "010201001001"
"01020101006"  "010201001002" "010201001001"
"01020102003"  "010201002002" "010201002001"
"01020102005"  "010201002004" "010201002003"
"01020102006"  "010201002004" "010201002003"
"01020102007"  "010201002004" "010201002003"
"01020102008"  "010201002002" "010201002001"
"01020102010"  "010201002009" "010201002008"
"01020102011"  "010201002009" "010201002008"
"01020102012"  "010201002002" "010201002001"
"01020102014"  "010201002013" "010201002012"
"01020103003"  "010201003002" "010201003001"
"01020103004"  "010201003002" "010201003001"
"01020103005"  "010201003002" "010201003001"
"01020103006"  "010201003002" "010201003001"
"01020103007"  "010201003002" "010201003001"
"01020104003"  "010201004002" "010201004001"
"01020104004"  "010201004002" "010201004001"
"01020104005"  "010201004002" "010201004001"
"01020105002"  "010201005075" "010201005001"
"01020105006"  "010201005003" "010201005002"
"01020105007"  "010201005003" "010201005002"
"01020105008"  "010201005003" "010201005002"
"01020105009"  "010201005003" "010201005002"
"01020105010"  "010201005003" "010201005002"
"01020106012"  "010201006075" "010201006001"
"01020106013"  "010201006075" "010201006001"
"01020106015"  "010201006075" "010201006001"
"01020107003"  "010201007002" "010201007001"
"01020107004"  "010201007002" "010201007001"
"01020107006"  "010201007002" "010201007001"
"01020107007"  "010201007002" "010201007001"
"01020107008"  "010201007002" "010201007001"
"01020107009"  "010201007002" "010201007001"
"01020108003"  "010201008002" "010201008001"
"01020108004"  "010201008002" "010201008001"
"01020108005"  "010201008002" "010201008001"
"01020108006"  "010201008002" "010201008001"
"01020109003"  "010201009002" "010201009001"
"01020109004"  "010201009002" "010201009001"
"01020109005"  "010201009002" "010201009001"
"01020109006"  "010201009002" "010201009001"
"01020109007"  "010201009002" "010201009001"
"01020109008"  "010201009002" "010201009001"
"01020109009"  "010201009002" "010201009001"
"01020110001"  "010201010111" "010201010175"
"01020110003"  "010201010111" "010201010175"
"01020110004"  "010201010111" "010201010175"
"01020110005"  "010201010111" "010201010175"
"01020110006"  "010201010111" "010201010175"
"01020110008"  "010201010107" "010201010169"
"01020110009"  "010201010107" "010201010169"
"01020110010"  "010201010107" "010201010169"
"01020112003"  "010201012002" "010201012001"
"01020112004"  "010201012002" "010201012001"
"01020113003"  "010201013002" "010201013001"
"01020113004"  "010201013002" "010201013001"
"01020113005"  "010201013002" "010201013001"
"01020113006"  "010201013002" "010201013001"
"01020113007"  "010201013002" "010201013001"
"01020114003"  "010201014002" "010201014001"
"01020114004"  "010201014002" "010201014001"
"01020114005"  "010201014002" "010201014001"
"01020114006"  "010201014002" "010201014001"
"01020114007"  "010201014002" "010201014001"
"01020116003"  "010201016002" "010201016001"
"01020116005"  "010201016004" "010201016003"
"01020116006"  "010201016004" "010201016003"
"01020116007"  "010201016004" "010201016003"
"01020116008"  "010201016002" "010201016001"
"01020117002"  "010201017001" "010201017050"
"01020117003"  "010201017001" "010201017050"
"01020117004"  "010201017001" "010201017050"
"01020117005"  "010201017001" "010201017050"
"01020118003"  "010201018002" "010201018001"
"01020118004"  "010201018002" "010201018001"
"01020118006"  "010201018005" "010201018004"
"01020118007"  "010201018005" "010201018004"
"01020118008"  "010201018005" "010201018004"
"01020118009"  "010201018002" "010201018001"
"01020119003"  "010201019002" "010201019001"
"01020119004"  "010201019002" "010201019001"
"01020119005"  "010201019002" "010201019001"
"01020119006"  "010201019002" "010201019001"
"010201020102" "010201020175" "010201020101"
"01020120003"  "010201020102" "010201020101"
"010201020104" "010201020103" "010201020102"
"01020120005"  "010201020104" "010201020103"
"010201020106" "010201020103" "010201020102"
"010201020107" "010201020175" "010201020101"
"01020120008"  "010201020104" "010201020103"
"010201020109" "010201020108" "010201020107"
"010201020110" "010201020108" "010201020107"
"010201020112" "010201020175" "010201020101"
"010201020114" "010201020113" "010201020112"
"010201030101" "010201030175" "010201030169"
"010201030103" "010201030102" "010201030101"
"010201030104" "010201030102" "010201030101"
"010201030105" "010201030102" "010201030101"
end

foreach var in IDPERSON ID_mom ID_father{
    destring `var', replace
}
foreach p in mom father{
     preserve
     tempfile grand`p'
     keep IDPERSON ID_`p'
     rename (IDPERSON ID_`p') (ID_`p' ID_grand`p')
     duplicates drop *, force
     save `grand`p''
     restore
     merge m:1 ID_`p' using `grand`p'', keep(master match) nogen
}
format IDPERSON ID_mom ID_father ID_grand* %13.0f
                        Res.:

                        Code:
                        . l, sep(0)

     +---------------------------------------------------------------------+
     |    IDPERSON        ID_mom     ID_father   ID_grandmom   ID_grandf~r |
     |---------------------------------------------------------------------|
  1. |  1020101005   10201001002   10201001001             .             . |
  2. |  1020101006   10201001002   10201001001             .             . |
  3. |  1020101003   10201001002   10201001001             .             . |
  4. |  1020102012   10201002002   10201002001             .             . |
  5. |  1020102003   10201002002   10201002001             .             . |
  6. |  1020102008   10201002002   10201002001             .             . |
  7. |  1020102006   10201002004   10201002003             .             . |
  8. |  1020102007   10201002004   10201002003             .             . |
  9. |  1020102005   10201002004   10201002003             .             . |
 10. |  1020102010   10201002009   10201002008             .             . |
 11. |  1020102011   10201002009   10201002008             .             . |
 12. |  1020102014   10201002013   10201002012             .             . |
 13. |  1020103005   10201003002   10201003001             .             . |
 14. |  1020103006   10201003002   10201003001             .             . |
 15. |  1020103004   10201003002   10201003001             .             . |
 16. |  1020103003   10201003002   10201003001             .             . |
 17. |  1020103007   10201003002   10201003001             .             . |
 18. |  1020104003   10201004002   10201004001             .             . |
 19. |  1020104004   10201004002   10201004001             .             . |
 20. |  1020104005   10201004002   10201004001             .             . |
 21. |  1020105002   10201005075   10201005001             .             . |
 22. |  1020105009   10201005003   10201005002             .             . |
 23. |  1020105010   10201005003   10201005002             .             . |
 24. |  1020105007   10201005003   10201005002             .             . |
 25. |  1020105006   10201005003   10201005002             .             . |
 26. |  1020105008   10201005003   10201005002             .             . |
 27. |  1020106015   10201006075   10201006001             .             . |
 28. |  1020106012   10201006075   10201006001             .             . |
 29. |  1020106013   10201006075   10201006001             .             . |
 30. |  1020107003   10201007002   10201007001             .             . |
 31. |  1020107007   10201007002   10201007001             .             . |
 32. |  1020107008   10201007002   10201007001             .             . |
 33. |  1020107004   10201007002   10201007001             .             . |
 34. |  1020107006   10201007002   10201007001             .             . |
 35. |  1020107009   10201007002   10201007001             .             . |
 36. |  1020108005   10201008002   10201008001             .             . |
 37. |  1020108004   10201008002   10201008001             .             . |
 38. |  1020108006   10201008002   10201008001             .             . |
 39. |  1020108003   10201008002   10201008001             .             . |
 40. |  1020109007   10201009002   10201009001             .             . |
 41. |  1020109008   10201009002   10201009001             .             . |
 42. |  1020109006   10201009002   10201009001             .             . |
 43. |  1020109009   10201009002   10201009001             .             . |
 44. |  1020109004   10201009002   10201009001             .             . |
 45. |  1020109003   10201009002   10201009001             .             . |
 46. |  1020109005   10201009002   10201009001             .             . |
 47. |  1020110010   10201010107   10201010169             .             . |
 48. |  1020110009   10201010107   10201010169             .             . |
 49. |  1020110008   10201010107   10201010169             .             . |
 50. |  1020110001   10201010111   10201010175             .             . |
 51. |  1020110003   10201010111   10201010175             .             . |
 52. |  1020110004   10201010111   10201010175             .             . |
 53. |  1020110005   10201010111   10201010175             .             . |
 54. |  1020110006   10201010111   10201010175             .             . |
 55. |  1020112003   10201012002   10201012001             .             . |
 56. |  1020112004   10201012002   10201012001             .             . |
 57. |  1020113005   10201013002   10201013001             .             . |
 58. |  1020113003   10201013002   10201013001             .             . |
 59. |  1020113007   10201013002   10201013001             .             . |
 60. |  1020113004   10201013002   10201013001             .             . |
 61. |  1020113006   10201013002   10201013001             .             . |
 62. |  1020114004   10201014002   10201014001             .             . |
 63. |  1020114005   10201014002   10201014001             .             . |
 64. |  1020114006   10201014002   10201014001             .             . |
 65. |  1020114003   10201014002   10201014001             .             . |
 66. |  1020114007   10201014002   10201014001             .             . |
 67. |  1020116003   10201016002   10201016001             .             . |
 68. |  1020116008   10201016002   10201016001             .             . |
 69. |  1020116007   10201016004   10201016003             .             . |
 70. |  1020116006   10201016004   10201016003             .             . |
 71. |  1020116005   10201016004   10201016003             .             . |
 72. |  1020117002   10201017001   10201017050             .             . |
 73. |  1020117004   10201017001   10201017050             .             . |
 74. |  1020117005   10201017001   10201017050             .             . |
 75. |  1020117003   10201017001   10201017050             .             . |
 76. |  1020118004   10201018002   10201018001             .             . |
 77. |  1020118003   10201018002   10201018001             .             . |
 78. |  1020118009   10201018002   10201018001             .             . |
 79. |  1020118007   10201018005   10201018004             .             . |
 80. |  1020118008   10201018005   10201018004             .             . |
 81. |  1020118006   10201018005   10201018004             .             . |
 82. |  1020119006   10201019002   10201019001             .             . |
 83. |  1020119005   10201019002   10201019001             .             . |
 84. |  1020119003   10201019002   10201019001             .             . |
 85. |  1020119004   10201019002   10201019001             .             . |
 86. | 10201020112   10201020175   10201020101             .             . |
 87. | 10201020102   10201020175   10201020101             .             . |
 88. |  1020120003   10201020102   10201020101   10201020175             . |
 89. | 10201020107   10201020175   10201020101             .             . |
 90. | 10201020104   10201020103   10201020102             .   10201020101 |
 91. | 10201020106   10201020103   10201020102             .   10201020101 |
 92. |  1020120008   10201020104   10201020103   10201020103             . |
 93. |  1020120005   10201020104   10201020103   10201020103             . |
 94. | 10201020109   10201020108   10201020107             .   10201020101 |
 95. | 10201020110   10201020108   10201020107             .   10201020101 |
 96. | 10201020114   10201020113   10201020112             .   10201020101 |
 97. | 10201030105   10201030102   10201030101             .   10201030169 |
 98. | 10201030103   10201030102   10201030101             .   10201030169 |
 99. | 10201030104   10201030102   10201030101             .   10201030169 |
100. | 10201030101   10201030175   10201030169             .             . |
     +---------------------------------------------------------------------+

.

                        Comment

                        • #13
                          Thank you very much. Appreciate your time and help !

                          Comment

                          • #14
                            In the above example, fathers fathers id and mothers mothers id is created, how will I create fathers mothers id and mothers fathers id, using the data above.

                            Comment

                            • #15
                              *EDITED

                              Code:
                              * Example generated by -dataex-. To install: ssc install dataex
clear
input str12(IDPERSON ID_mom ID_father)
"01020101003"  "010201001002" "010201001001"
"01020101005"  "010201001002" "010201001001"
"01020101006"  "010201001002" "010201001001"
"01020102003"  "010201002002" "010201002001"
"01020102005"  "010201002004" "010201002003"
"01020102006"  "010201002004" "010201002003"
"01020102007"  "010201002004" "010201002003"
"01020102008"  "010201002002" "010201002001"
"01020102010"  "010201002009" "010201002008"
"01020102011"  "010201002009" "010201002008"
"01020102012"  "010201002002" "010201002001"
"01020102014"  "010201002013" "010201002012"
"01020103003"  "010201003002" "010201003001"
"01020103004"  "010201003002" "010201003001"
"01020103005"  "010201003002" "010201003001"
"01020103006"  "010201003002" "010201003001"
"01020103007"  "010201003002" "010201003001"
"01020104003"  "010201004002" "010201004001"
"01020104004"  "010201004002" "010201004001"
"01020104005"  "010201004002" "010201004001"
"01020105002"  "010201005075" "010201005001"
"01020105006"  "010201005003" "010201005002"
"01020105007"  "010201005003" "010201005002"
"01020105008"  "010201005003" "010201005002"
"01020105009"  "010201005003" "010201005002"
"01020105010"  "010201005003" "010201005002"
"01020106012"  "010201006075" "010201006001"
"01020106013"  "010201006075" "010201006001"
"01020106015"  "010201006075" "010201006001"
"01020107003"  "010201007002" "010201007001"
"01020107004"  "010201007002" "010201007001"
"01020107006"  "010201007002" "010201007001"
"01020107007"  "010201007002" "010201007001"
"01020107008"  "010201007002" "010201007001"
"01020107009"  "010201007002" "010201007001"
"01020108003"  "010201008002" "010201008001"
"01020108004"  "010201008002" "010201008001"
"01020108005"  "010201008002" "010201008001"
"01020108006"  "010201008002" "010201008001"
"01020109003"  "010201009002" "010201009001"
"01020109004"  "010201009002" "010201009001"
"01020109005"  "010201009002" "010201009001"
"01020109006"  "010201009002" "010201009001"
"01020109007"  "010201009002" "010201009001"
"01020109008"  "010201009002" "010201009001"
"01020109009"  "010201009002" "010201009001"
"01020110001"  "010201010111" "010201010175"
"01020110003"  "010201010111" "010201010175"
"01020110004"  "010201010111" "010201010175"
"01020110005"  "010201010111" "010201010175"
"01020110006"  "010201010111" "010201010175"
"01020110008"  "010201010107" "010201010169"
"01020110009"  "010201010107" "010201010169"
"01020110010"  "010201010107" "010201010169"
"01020112003"  "010201012002" "010201012001"
"01020112004"  "010201012002" "010201012001"
"01020113003"  "010201013002" "010201013001"
"01020113004"  "010201013002" "010201013001"
"01020113005"  "010201013002" "010201013001"
"01020113006"  "010201013002" "010201013001"
"01020113007"  "010201013002" "010201013001"
"01020114003"  "010201014002" "010201014001"
"01020114004"  "010201014002" "010201014001"
"01020114005"  "010201014002" "010201014001"
"01020114006"  "010201014002" "010201014001"
"01020114007"  "010201014002" "010201014001"
"01020116003"  "010201016002" "010201016001"
"01020116005"  "010201016004" "010201016003"
"01020116006"  "010201016004" "010201016003"
"01020116007"  "010201016004" "010201016003"
"01020116008"  "010201016002" "010201016001"
"01020117002"  "010201017001" "010201017050"
"01020117003"  "010201017001" "010201017050"
"01020117004"  "010201017001" "010201017050"
"01020117005"  "010201017001" "010201017050"
"01020118003"  "010201018002" "010201018001"
"01020118004"  "010201018002" "010201018001"
"01020118006"  "010201018005" "010201018004"
"01020118007"  "010201018005" "010201018004"
"01020118008"  "010201018005" "010201018004"
"01020118009"  "010201018002" "010201018001"
"01020119003"  "010201019002" "010201019001"
"01020119004"  "010201019002" "010201019001"
"01020119005"  "010201019002" "010201019001"
"01020119006"  "010201019002" "010201019001"
"010201020102" "010201020175" "010201020101"
"01020120003"  "010201020102" "010201020101"
"010201020104" "010201020103" "010201020102"
"01020120005"  "010201020104" "010201020103"
"010201020106" "010201020103" "010201020102"
"010201020107" "010201020175" "010201020101"
"01020120008"  "010201020104" "010201020103"
"010201020109" "010201020108" "010201020107"
"010201020110" "010201020108" "010201020107"
"010201020112" "010201020175" "010201020101"
"010201020114" "010201020113" "010201020112"
"010201030101" "010201030175" "010201030169"
"010201030103" "010201030102" "010201030101"
"010201030104" "010201030102" "010201030101"
"010201030105" "010201030102" "010201030101"
end

foreach var in IDPERSON ID_mom ID_father{
    destring `var', replace
}
foreach p in mom father{
     preserve
     tempfile grand`p'
     rename (IDPERSON ID_mom ID_father) (ID_`p' ID_mom_`p' ID_father_`p')
     duplicates drop *, force
     save `grand`p''
     restore
     merge m:1 ID_`p' using `grand`p'', keep(master match) nogen
}
format IDPERSON *_mom *_father %13.0f
                              Res.:

                              Code:
                              . l, sep(0)

     +-------------------------------------------------------------------------------------------------+
     |    IDPERSON        ID_mom     ID_father    ID_mom_mom   ID_father~m   ID_mom_fa~r   ID_father~r |
     |-------------------------------------------------------------------------------------------------|
  1. |  1020101006   10201001002   10201001001             .             .             .             . |
  2. |  1020101005   10201001002   10201001001             .             .             .             . |
  3. |  1020101003   10201001002   10201001001             .             .             .             . |
  4. |  1020102008   10201002002   10201002001             .             .             .             . |
  5. |  1020102003   10201002002   10201002001             .             .             .             . |
  6. |  1020102012   10201002002   10201002001             .             .             .             . |
  7. |  1020102007   10201002004   10201002003             .             .             .             . |
  8. |  1020102005   10201002004   10201002003             .             .             .             . |
  9. |  1020102006   10201002004   10201002003             .             .             .             . |
 10. |  1020102010   10201002009   10201002008             .             .             .             . |
 11. |  1020102011   10201002009   10201002008             .             .             .             . |
 12. |  1020102014   10201002013   10201002012             .             .             .             . |
 13. |  1020103005   10201003002   10201003001             .             .             .             . |
 14. |  1020103003   10201003002   10201003001             .             .             .             . |
 15. |  1020103004   10201003002   10201003001             .             .             .             . |
 16. |  1020103007   10201003002   10201003001             .             .             .             . |
 17. |  1020103006   10201003002   10201003001             .             .             .             . |
 18. |  1020104003   10201004002   10201004001             .             .             .             . |
 19. |  1020104005   10201004002   10201004001             .             .             .             . |
 20. |  1020104004   10201004002   10201004001             .             .             .             . |
 21. |  1020105002   10201005075   10201005001             .             .             .             . |
 22. |  1020105009   10201005003   10201005002             .             .             .             . |
 23. |  1020105008   10201005003   10201005002             .             .             .             . |
 24. |  1020105010   10201005003   10201005002             .             .             .             . |
 25. |  1020105006   10201005003   10201005002             .             .             .             . |
 26. |  1020105007   10201005003   10201005002             .             .             .             . |
 27. |  1020106015   10201006075   10201006001             .             .             .             . |
 28. |  1020106012   10201006075   10201006001             .             .             .             . |
 29. |  1020106013   10201006075   10201006001             .             .             .             . |
 30. |  1020107008   10201007002   10201007001             .             .             .             . |
 31. |  1020107009   10201007002   10201007001             .             .             .             . |
 32. |  1020107004   10201007002   10201007001             .             .             .             . |
 33. |  1020107007   10201007002   10201007001             .             .             .             . |
 34. |  1020107006   10201007002   10201007001             .             .             .             . |
 35. |  1020107003   10201007002   10201007001             .             .             .             . |
 36. |  1020108005   10201008002   10201008001             .             .             .             . |
 37. |  1020108004   10201008002   10201008001             .             .             .             . |
 38. |  1020108006   10201008002   10201008001             .             .             .             . |
 39. |  1020108003   10201008002   10201008001             .             .             .             . |
 40. |  1020109007   10201009002   10201009001             .             .             .             . |
 41. |  1020109008   10201009002   10201009001             .             .             .             . |
 42. |  1020109003   10201009002   10201009001             .             .             .             . |
 43. |  1020109009   10201009002   10201009001             .             .             .             . |
 44. |  1020109006   10201009002   10201009001             .             .             .             . |
 45. |  1020109005   10201009002   10201009001             .             .             .             . |
 46. |  1020109004   10201009002   10201009001             .             .             .             . |
 47. |  1020110009   10201010107   10201010169             .             .             .             . |
 48. |  1020110008   10201010107   10201010169             .             .             .             . |
 49. |  1020110010   10201010107   10201010169             .             .             .             . |
 50. |  1020110006   10201010111   10201010175             .             .             .             . |
 51. |  1020110004   10201010111   10201010175             .             .             .             . |
 52. |  1020110005   10201010111   10201010175             .             .             .             . |
 53. |  1020110001   10201010111   10201010175             .             .             .             . |
 54. |  1020110003   10201010111   10201010175             .             .             .             . |
 55. |  1020112004   10201012002   10201012001             .             .             .             . |
 56. |  1020112003   10201012002   10201012001             .             .             .             . |
 57. |  1020113004   10201013002   10201013001             .             .             .             . |
 58. |  1020113005   10201013002   10201013001             .             .             .             . |
 59. |  1020113006   10201013002   10201013001             .             .             .             . |
 60. |  1020113003   10201013002   10201013001             .             .             .             . |
 61. |  1020113007   10201013002   10201013001             .             .             .             . |
 62. |  1020114006   10201014002   10201014001             .             .             .             . |
 63. |  1020114007   10201014002   10201014001             .             .             .             . |
 64. |  1020114004   10201014002   10201014001             .             .             .             . |
 65. |  1020114005   10201014002   10201014001             .             .             .             . |
 66. |  1020114003   10201014002   10201014001             .             .             .             . |
 67. |  1020116003   10201016002   10201016001             .             .             .             . |
 68. |  1020116008   10201016002   10201016001             .             .             .             . |
 69. |  1020116005   10201016004   10201016003             .             .             .             . |
 70. |  1020116007   10201016004   10201016003             .             .             .             . |
 71. |  1020116006   10201016004   10201016003             .             .             .             . |
 72. |  1020117002   10201017001   10201017050             .             .             .             . |
 73. |  1020117003   10201017001   10201017050             .             .             .             . |
 74. |  1020117005   10201017001   10201017050             .             .             .             . |
 75. |  1020117004   10201017001   10201017050             .             .             .             . |
 76. |  1020118009   10201018002   10201018001             .             .             .             . |
 77. |  1020118003   10201018002   10201018001             .             .             .             . |
 78. |  1020118004   10201018002   10201018001             .             .             .             . |
 79. |  1020118007   10201018005   10201018004             .             .             .             . |
 80. |  1020118008   10201018005   10201018004             .             .             .             . |
 81. |  1020118006   10201018005   10201018004             .             .             .             . |
 82. |  1020119005   10201019002   10201019001             .             .             .             . |
 83. |  1020119004   10201019002   10201019001             .             .             .             . |
 84. |  1020119006   10201019002   10201019001             .             .             .             . |
 85. |  1020119003   10201019002   10201019001             .             .             .             . |
 86. | 10201020112   10201020175   10201020101             .             .             .             . |
 87. | 10201020107   10201020175   10201020101             .             .             .             . |
 88. |  1020120003   10201020102   10201020101   10201020175   10201020101             .             . |
 89. | 10201020102   10201020175   10201020101             .             .             .             . |
 90. | 10201020104   10201020103   10201020102             .             .   10201020175   10201020101 |
 91. | 10201020106   10201020103   10201020102             .             .   10201020175   10201020101 |
 92. |  1020120005   10201020104   10201020103   10201020103   10201020102             .             . |
 93. |  1020120008   10201020104   10201020103   10201020103   10201020102             .             . |
 94. | 10201020109   10201020108   10201020107             .             .   10201020175   10201020101 |
 95. | 10201020110   10201020108   10201020107             .             .   10201020175   10201020101 |
 96. | 10201020114   10201020113   10201020112             .             .   10201020175   10201020101 |
 97. | 10201030104   10201030102   10201030101             .             .   10201030175   10201030169 |
 98. | 10201030103   10201030102   10201030101             .             .   10201030175   10201030169 |
 99. | 10201030105   10201030102   10201030101             .             .   10201030175   10201030169 |
100. | 10201030101   10201030175   10201030169             .             .             .             . |
     +-------------------------------------------------------------------------------------------------+
                              Last edited by Andrew Musau; 24 Feb 2023, 07:11.

                              Comment

                              Previous 1 2 Next
                              Working...
                              X