Identifying duplicates in Dyad Data (within branch and village)

[danishussalam]

Hi everyone,

I understand this has been discussed before and I have read contributions on this topic by Nick Cox , Romalpa Akzo and David Benson but still didn't seem to get my head around it.

I have survey data on households, each one of which was asked to report up to 3 hhs in their village with whom they borrow food from. There's a possibility that a hh mentioned in someone's food network was also interviewed in the survey and this hh may have mentioned the first hh in his network. Not every hh reports 3 food networks.

For example - In branchid 1 and village 1, hhi (85) mentions borrowing food from hh 76, 77 and 78. There's a possibility that hh 76, 77 or 78 may have mentioned hh 85 if they were interviewed in the survey as well and I would like to identify such networks within a branch and village.

I would have used dataex (still using) to give you guys a subset of my dataset but I'm afraid you won't find any duplicates in the subset. So I'm also attaching the .dta file with over 50k food networks.

Any help in this regard will be highly appreciated.

* Example generated by -dataex-. To install: ssc install dataex
clear
input byte branchid int(village hhi) byte _j int hhj
1  1  46 1  45
1  1  57 1  56
1  1  85 1  77
1  1  85 2  76
1  1  85 3  78
1  1  86 1  77
1  1  87 1  77
1  2   6 1   4
1  2  26 1  23
1  2  26 2  24
1  2  26 3  25
1  2  30 1  31
1  2  36 1  39
1  2  39 1  38
1  2  54 1 210
1  2  54 2 211
1  2  80 1  60
1  3  41 1  36
1  3  41 2  49
1  3  41 3  50
1  3  46 1  49
1  3  46 2  50
1  3  46 3  63
1  3  47 1  48
1  3  47 2  49
1  3  47 3  50
1  3  51 1  53
1  3  51 2  56
1  3  51 3  60
1  3  98 1 101
1  3  98 2 102
1  3  98 3 104
1  4   2 1   6
1  4  12 1  13
1  4  12 2  14
1  4  12 3  15
1  4  17 1  12
1  4  33 1  28
1  4  33 2  24
1  4  33 3  30
1  4  34 1  35
1  4  34 2  36
1  4  44 1  43
1  4  44 3  45
1  4  46 1  43
1  4  46 2  44
1  4  46 3  45
1  4  51 1  53
1  4  51 2  54
1  4  51 3  55
1  4  56 1  57
1  4  56 2  58
1  4  64 1  60
1  4  71 1  74
1  4  78 1  77
1  4  78 2  74
1  4  83 1  82
1  4  83 2  77
1  4  83 3  78
1  4  86 1 118
1  4  90 1  88
1  4 120 1 116
1  4 120 2 117
1  4 130 1 128
1  4 131 1 134
1  4 131 2 135
1  5  32 1  28
1  5  32 2  29
1  5  35 1  36
1  5  35 2  38
1  6   9 1  10
1  6   9 2  28
1  6   9 3   8
1  7  27 1  26
1  7  36 1  34
1  7  36 2  35
1  7  46 1  45
1  7  46 2  41
1  7  61 1  60
1  7  61 2  57
1  7  79 1  76
1  7  88 1  93
1  7  90 1  92
1  8  52 1  50
1  8  62 1  61
1  8  63 1  53
1  9   1 1   3
1  9   8 1   3
1  9   8 2   4
1  9  17 1  20
1  9  19 1  20
1  9  26 1  20
1  9  26 2  21
1  9  26 3  22
1  9  29 1  30
1  9  29 2  31
1  9  51 1  48
1  9  74 1  75
1  9  74 2  76
1  9  81 1  78
1  9  81 2  80
1 11   8 1   0
1 11  63 1  67
1 11  76 1  74
1 12   1 1   2
1 12   1 2   4
1 12   8 1   3
1 12   8 2  10
1 12  15 1   3
1 12  19 1   0
1 12  27 1   1
1 12  27 2  33
1 12  34 1   1
1 12  34 2   2
1 12  45 1  43
1 12  45 2  42
1 12  86 1   1
1 13  13 1   9
1 13  13 2  10
1 13  33 1  32
1 13  33 2  34
1 13  43 1  45
1 13  43 2  48
1 13  53 1   8
1 13  71 1  20
1 13  71 2  68
1 13  72 1  64
1 13  72 2  65
1 13  85 1  83
1 13  85 2  87
1 13  99 1  96
1 13  99 2 100
1 14   3 1   1
1 14   3 2   2
1 14  20 1   2
1 14  29 1  37
1 14  33 1  37
1 14  40 1  38
1 14  50 1  51
1 14  52 1  55
1 14  52 2  58
1 14  55 1  53
1 14  55 2  54
1 14  83 1  84
1 14  90 1  92
1 14  90 2  93
1 14  93 1  91
1 14  93 2  92
1 16   4 1   5
1 16   4 2   6
1 16  10 1   9
1 16  12 1  11
1 16  17 1  16
1 16  21 1  20
1 16  33 1  34
1 16  33 2  35
1 16  38 1  39
1 17   4 1   5
1 17   4 2   6
1 17   8 1   7
1 17  48 1  49
1 17  48 2  50
1 17  58 1  59
1 17  78 1  75
1 17  78 2  76
1 18  43 1  46
1 19   2 1   1
1 19   3 1   5
1 19  22 1  24
1 19  24 1  27
1 19  44 1  40
1 19  51 1  49
1 19  55 1  58
1 19  55 2  59
1 19  60 1  58
1 19  67 1  63
1 19  77 1  75
1 19  77 2  76
1 19  87 1  85
1 19  87 2  86
1 19  97 1  95
1 19  97 2  98
1 19 103 1 104
1 19 108 1 100
1 19 109 1 108
1 19 119 1 118
1 19 120 1 116
1 19 130 1 128
1 21  28 1  24
1 21 112 1   3
1 21 113 1 111
1 24  24 1   2
1 24  24 2  23
1 24  68 1  69
1 24  76 1  73
1 25   2 1   7
1 25  33 1  29
1 25  42 1  45
1 25  42 2  54
1 25  44 1  41
1 25  47 1  48
1 25  59 1  60
1 25  66 1  69
1 25  68 1  70
1 26   3 1   1
1 26  12 1  15
1 26  13 1  16
1 26  16 1  19
1 26  32 1  31
1 26  37 1  37
1 26  47 1  46
1 26  49 1  48
1 26  66 1  65
1 26  66 2  64
1 26  67 1  68
1 26  70 1  69
1 26  80 1  81
1 27  46 1 127
1 27  48 1   2
1 27  58 1  53
1 27  73 1  72
1 28   9 1  10
1 28   9 2   6
1 28  10 1   8
1 28  10 2   9
1 28  20 1  19
1 28  20 2  21
1 28  20 3  23
1 28  30 1  29
1 28  42 1  40
1 28  42 2  34
1 28  43 1  46
1 28  43 2  59
1 28  45 1  56
1 28  46 1  43
1 28  46 2  50
1 28  47 1  60
1 28  47 2  63
1 28  47 3  61
1 28  55 1 205
1 28  55 2 206
1 28  64 1  54
1 28  64 2  65
1 28  66 1  64
1 28  66 2  65
1 28  66 3  57
1 28  77 1  75
1 28  87 1  88
1 28  87 2  99
1 28  88 1  10
1 28  88 2   8
1 29   4 1   7
1 29   4 2   3
1 29   4 3   5
1 29   7 1   3
1 29   7 2   6
1 29   7 3   5
1 29  20 1  21
1 29  20 2  22
1 29  31 1  29
1 29  31 2  30
1 29  34 1  33
1 29  34 2  36
1 29  41 1  42
1 29  41 2  43
1 29  41 3  44
1 29  62 1  60
1 29  62 2  63
1 29  70 1  66
1 29  70 2  67
1 29  71 1  56
1 29  71 2  58
1 29  75 1  73
1 29  75 2  74
1 29  84 1  83
1 29  84 2  85
1 29  94 1  92
1 29 101 1 100
1 29 101 2  99
1 30   1 1   3
1 30   1 2   2
1 30   3 1   2
1 30   3 2   1
1 30  13 1  12
1 30  24 1  22
1 30  28 1  30
1 30  36 1  38
1 30  57 1  60
1 30  62 1  63
1 31   2 1   1
1 32   8 1   7
1 32   8 2  10
1 32   8 3  15
1 32  18 1  19
1 32  18 2  20
1 32  18 3  22
1 32  28 1  28
1 32  28 2  29
1 32  28 3  30
1 32  38 1  39
1 32  38 2  41
1 32  38 3  42
1 32  49 1  47
1 32  49 2  48
1 32  49 3  50
1 32  54 1  51
1 32  54 2  52
1 32  60 1  58
1 32  60 2  59
1 32  60 3  62
1 32  70 1  71
1 32  70 2  72
1 32  70 3  75
1 32  74 1  72
1 32  74 2  73
1 32  74 3  76
1 32  75 1  72
1 32  75 2  73
1 32  77 1  76
1 32  77 2  78
1 32  83 1  81
1 32  83 2  82
1 32  84 1  96
1 32  84 2  92
1 32  89 1  90
1 32  89 2  91
1 32  92 1  93
1 32  92 2  94
1 32  92 3  95
1 32  96 1  93
1 32  96 2  94
1 32  96 3  95
1 33   2 1   4
1 33   7 1   6
1 33  53 1  50
1 34   4 1   2
1 34   7 1   5
1 34  38 1  36
1 34  40 1  39
1 34  47 1  45
1 34  56 1  55
1 34  68 1  69
1 34  68 2  71
1 35   3 1   1
1 35  14 1  13
1 35  14 2  12
1 35  23 1  24
1 35  23 2  25
1 35  23 3  26
1 35  25 1  23
1 35  25 2  24
1 35  35 1  34
1 35  35 2  36
1 35  35 3  38
1 35  37 1  32
1 35  37 2  34
1 35  37 3  36
1 35  47 1  46
1 35  47 2  48
1 35  47 3  50
1 35  57 1  56
1 35  57 2  58
1 35  77 1  75
1 35  77 2  76
1 36  10 1   1
1 36  61 1  60
1 36  62 1 210
1 36  66 1  65
1 38   4 1   6
1 38  16 1  15
1 38  16 2  17
1 38  57 1  50
1 38  57 2  51
1 38  57 3  58
1 38 108 1 109
1 40   3 1   2
1 40  20 1  21
1 40  50 1  48
1 41   8 1   7
1 41   8 2  10
1 41   8 3  11
1 41  18 1  17
1 41  18 2  19
1 41  18 3  20
1 41  28 1  29
1 41  28 2  30
1 41  38 1  37
1 41  38 2  39
1 41  45 1  44
1 41  45 2  46
1 41  49 1  50
1 41  49 2  51
1 41  49 3  52
1 41  57 1  56
1 41  57 2  58
1 41  72 1  70
1 41  72 2  71
1 41  72 3  73
1 41  82 1  89
1 41  85 1  86
1 41  85 2 201
1 43   7 1   8
1 43   7 2   6
1 43   7 3  24
1 43  16 1  60
1 43  16 2  61
1 43  18 1  19
1 43  18 2   4
1 43  26 1   6
1 43  26 2  31
1 43  27 1   6
1 43  27 2  10
1 43  27 3  19
1 43  31 1   9
1 43  31 2 211
1 43  31 3 212
1 43  36 1  34
1 43  42 1  41
1 43  42 2 203
1 43  47 1  52
1 43  47 2  49
1 43  47 3  15
1 43  53 1  50
1 43  53 2  51
1 43  53 3  52
1 43  63 1  61
1 43  63 2  62
1 43  63 3  64
1 43  88 1  84
1 43  88 2  83
1 43  88 3  89
1 43  94 1  84
1 45   8 1  12
1 45   9 1   5
1 45   9 2   6
1 45  21 1  25
1 45  50 1  53
1 45  63 1  65
1 45  63 2  66
1 45  73 1  70
1 45  82 1  75
1 45  94 1  97
1 45  94 2  90
1 45 107 1 100
2  1   4 1   5
2  1  10 1  11
2  1  21 1  17
2  1  21 2  18
2  1  21 3   0
2  1  23 1  28
2  1  44 1  47
2  1  44 2  41
2  1  44 3   0
2  1  45 1  44
2  1  57 1  51
2  1  69 1  78
2  1  69 2  64
2  1  69 3  79
2  1  71 1  72
2  1  73 1  74
2  1  81 1  80
2  1  83 1  84
2  1  83 2  85
2  1  83 3   0
2  1  88 1  86
2  1  88 3   0
2  1  89 1  90
2  1  89 2  86
2  1  89 3  91
2  1  98 1 101
2  2  28 1  27
2  2  28 2  29
2  2  28 3  30
2  2  39 1  37
2  2  39 2  40
2  2  39 3  41
2  2  47 1  50
2  2  49 1  47
2  2  49 2  48
2  2  49 3  46
2  2  53 1  58
2  2  53 2  54
2  2  53 3  55
2  2  55 1  58
2  2  55 2  56
2  2  55 3  57
2  2  59 1  54
2  2  63 1  62
2  2  66 1  64
2  2  66 2  65
2  2  66 3  67
2  2  68 1  69
2  2  75 1  76
2  2  75 2  73
2  2  75 3   0
2  2  79 1  16
2  3   2 1   3
2  3   2 2   8
2  3   2 3   0
2  3   5 1   8
2  3   8 3   0
2  3  16 1  31
2  3  18 1  34
2  3  20 1  21
2  3  20 2  22
2  3  20 3   0
2  3  24 1  22
2  3  26 1  27
2  3  27 1  26
2  3  28 1  26
2  3  28 2  27
2  3  28 3  31
2  3  34 1  33
2  3  40 1  38
2  3  40 2  42
2  3  40 3   0
2  3  43 1  99
2  3  48 1  49
2  3  48 2  50
2  3  48 3   0
2  3  61 1  60
2  4   2 1   3
2  4   2 2   4
2  4   2 3   0
2  4   5 1   6
2  4   6 1   5
2  4   8 1  10
2  4  15 1 206
2  4  22 1   5
2  4  22 2   6
2  4  22 3   0
2  4  23 1  21
2  4  27 1  34
2  4  28 1  34
2  4  38 1  37
2  4  40 1  40
2  4  40 2  41
2  4  40 3   0
2  4  50 1  53
2  4  60 1  62
2  4  60 2  63
2  4  60 3   0
2  4  71 1  72
2  4  71 2  73
2  4  71 3   0
2  4  82 1  83
2  5   4 1   5
2  5  12 1  13
2  5  16 1  15
2  5  18 1  20
2  5  18 2  19
2  5  18 3   0
2  5  21 1  19
2  5  21 2  20
2  5  21 3   0
2  5  29 1  30
2  5  29 2  31
2  5  29 3   0
2  5  33 1  99
2  5  39 3   0
2  5  43 1  41
2  5  43 2  42
2  5  43 3   0
2  5  44 1  42
2  5  44 2  41
2  5  44 3   0
2  5  69 1  67
2  5  69 2  71
2  5  69 3   0
2  5  72 1  99
2  6   1 1   2
2  6   1 2   3
2  6   1 3   4
2  6   4 1   1
2  6   4 2   3
2  6   4 3   2
2  6  10 1  11
2  6  10 2   9
2  6  10 3  12
2  6  11 1  10
2  6  11 2  13
2  6  11 3   0
2  6  22 1  23
2  6  22 2  21
2  6  22 3   0
2  6  30 1  32
2  6  30 2  33
2  6  30 3  31
2  6  43 1  41
2  6  43 2  44
2  6  43 3  45
2  6  59 1  62
2  6  63 1  62
2  6  63 2  59
2  6  63 3   0
2  6  71 1  69
2  6  71 2  70
2  6  71 3   0
2  6  73 1  69
2  6  73 2  70
2  6  73 3  72
2  6  82 1  75
2  6  83 1  75
2  6  83 2  74
2  6  83 3  77
2  6  85 1  78
2  6  85 2  86
2  6  85 3   0
2  6  86 1  84
2  6  86 2  85
2  6  86 3   0
2  6  87 1  69
2  6  87 2  84
2  6  87 3   0
2  7   8 1  12
2  7   8 2  14
2  7  11 1  12
2  7  11 2  14
2  7  11 3  15
2  7  18 1  12
2  7  18 2   6
2  7  18 3   7
2  7  20 1  19
2  7  20 2  21
2  7  21 1  12
2  7  21 2  19
2  7  22 1   7
2  7  22 2  12
2  7  22 3   3
2  7  40 1  41
2  7  44 1  45
2  7  44 2  46
2  7  44 3  47
2  7  49 1  47
2  7  49 2  48
2  7  52 1  46
2  7  52 2  47
2  7  56 1  47
2  7  56 2  48
2  7  73 1  74
2  7  73 2  77
2  7  76 1  77
2  7  76 2  41
2  7  78 1  47
2  7  78 2  50
2  7  83 1  77
2  7  83 2  87
2  7  89 1  87
2  7  89 2  90
2  8   3 1   4
2  8   3 2   1
2  8   3 3   2
2  8   4 1   2
2  8   8 1   6
2  8   8 2   2
2  8  14 1  29
2  8  36 1  37
2  8  40 1  39
2  8  40 2  38
2  8  45 1  44
2  8  54 1  51
2  8  56 1  67
2  8  64 1  67
2  8  64 2  69
2  8  69 1  67
2  8  73 1  74
2  8  76 1  75
2  8  82 1  91
2  8  82 2  92
2  9  10 1   8
2  9  15 1  14
2  9  19 1   5
2  9  19 2  21
2  9  24 1  23
2  9  35 1  34
2  9  35 2  36
2  9  37 1  34
2  9  37 2  35
2  9  47 1  48
2  9  47 2  45
2  9  53 1  54
2  9  53 2  52
2  9  54 1  53
2  9  54 2  55
2  9  58 1  59
2  9  61 1  59
2  9  61 2  58
2  9  75 1  75
2  9  78 1  76
2  9  86 1  85
2 10   1 1   2
2 10   1 2   5
2 10   1 3   7
2 10   7 1   5
2 10   7 2   2
2 10   7 3   4
2 10  18 1   7
2 10  18 2   5
2 10  18 3   4
2 10  19 1  25
2 10  19 2  15
2 10  20 1  15
2 10  20 2  13
2 10  22 1  15
2 10  22 2  16
2 10  22 3  10
2 10  28 1  25
2 10  36 1  38
2 10  36 2  39
2 10  40 1  37
2 10  40 2  38
2 10  41 1  43
2 10  41 2  44
2 10  45 1  46
2 10  45 2  42
2 10  46 1  44
2 10  46 2  32
2 10  46 3  25
2 10  72 1  71
2 10  72 2  77
2 10  76 1  77
2 10  76 2  78
2 10  81 1  83
2 10  81 2  80
2 11   1 1   4
2 11   3 1   2
2 11   6 1   8
2 11   6 2   7
2 11  12 1  13
2 11  12 2  14
2 11  18 1  13
2 11  18 2  14
2 11  19 1  14
2 11  19 2  17
2 11  30 1  36
2 11  42 1  43
2 11  42 2  44
2 11  43 1  42
2 11  43 2  44
2 11  44 1  42
2 11  44 2  44
2 11  68 1  66
2 11  68 2  67
2 11  68 3  71
2 11  71 1  66
2 11  71 2  72
2 11  83 1  80
2 11  83 2  81
2 11  84 1  80
2 11  84 2  81
2 11  86 1  80
2 11  86 2  83
2 11  90 1  88
2 11  90 2  91
2 11  93 1  91
2 11  93 2  92
2 11  94 1  91
2 11  94 2  92
2 11  96 1  93
2 11  96 2  91
2 11  96 3  92
2 12   4 1   0
2 12   4 2  17
2 12   4 3   9
2 12   5 1  17
2 12  12 1  17
2 12  25 1  17
2 12  27 1  17
2 12  27 2  25
2 12  36 1  37
2 12  46 1  47
2 12  56 1  47
2 12  56 2  54
2 12  62 1 201
2 12  62 2  17
2 12  62 3  25
2 12  64 1  52
2 12  64 2  53
2 12  64 3  54
2 13   6 1   0
2 13   6 2  10
2 13   6 3  11
2 13  18 1   0
2 13  21 1   0
2 13  21 2  23
2 13  29 1  35
2 13  37 1   0
2 13  38 1   0
2 13  38 2  37
2 13  39 1   0
2 13  39 2  42
2 13  39 3  43
2 13  42 1   0
2 13  42 2  43
2 13  43 1  42
2 13  48 1   0
2 13  48 2  47
2 13  55 1   0
2 13  55 2  57
2 13  55 3  58
2 13  56 1   0
2 13  56 2  53
2 13  56 3  55
2 13  71 1   0
2 13  71 2  67
2 13  75 1   0
2 13  75 2  73
2 13  75 3  74
2 13  76 1   0
2 13  76 2  73
2 13  76 3  74
2 14   1 1   2
2 14   8 1   5
2 14  13 1  14
2 14  20 1  22
2 14  21 1  20
2 14  29 1  27
2 14  29 2  31
2 14  30 1  28
2 14  30 2  27
2 14  30 3  29
2 14  32 1  33
2 14  32 2  34
2 14  35 1  32
2 14  35 2  33
2 14  35 3  34
2 14  41 1  40
2 14  41 2  42
2 14  41 3  45
2 14  42 1  40
2 14  42 2  43
2 14  45 1  46
2 14  45 2  44
2 14  54 1  55
2 14  54 2  57
2 14  65 1  63
2 14  65 2  64
2 14  73 1  73
2 14  73 2  74
2 14  73 3  77
2 14  75 1  74
2 14  75 2  77
2 14  75 3  73
2 14  78 1  79
2 14  79 1  78
2 14  79 2  86
2 14  84 1  78
2 14  84 2  79
2 14  88 1  89
2 14  88 2  90
2 14  88 3  91
2 14  95 1  96
2 14  95 2  93
2 15   1 1   9
2 15   7 1  11
2 15   7 2  10
2 15  10 1  11
2 15  10 2   9
2 15  12 1  11
2 15  12 2  10
2 15  25 1  23
2 15  25 2  22
2 15  27 1  26
2 15  27 2  33
2 15  29 1  17
2 15  29 2  18
2 15  31 1  36
2 15  31 2  33
2 15  31 3  35
2 15  34 1  36
2 15  34 2  37
2 15  35 1  33
2 15  35 2  34
2 15  35 3  36
2 15  43 1  41
2 15  43 2  42
2 15  46 1  43
2 15  46 2  41
2 15  50 1  52
2 15  55 1  54
2 15  55 2  56
2 15  60 1  57
2 15  60 2  58
2 15  60 3  59
2 15  69 1  68
2 15  69 2  65
2 16   8 1  25
2 16   8 2  26
2 16  24 1  25
2 16  24 2  26
2 16  27 1  29
2 16  27 2  30
2 16  31 1  34
2 16  31 2  35
2 16  34 1  32
2 16  34 2  35
2 16  34 3  36
2 16  35 1  32
2 16  35 2  36
2 16  39 1  38
2 16  39 2  47
2 16  40 1  43
2 16  40 2  41
2 16  46 1  47
2 16  46 2  44
2 16  48 1  49
2 16  48 2  45
2 17   8 1   9
2 17   9 1   8
2 17  10 1  11
2 17  15 1  14
2 17  17 1  14
2 17  23 1  21
2 17  29 1  24
2 17  29 2  25
2 17  38 1  37
2 17  51 1  52
2 17  56 1  58
2 17  56 2  52
2 17  57 1  58
2 17  58 1  57
2 17  61 1  62
2 17  65 1  86
2 17  65 2  87
2 17  74 1  73
2 17  80 1  76
2 17  81 1  76
2 17  85 1  83
2 17  90 1  89
2 17  90 2  91
2 17  94 1  97
2 17  96 1  96
2 17  97 1  96
2 18   5 1   4
2 18   5 2   3
2 18   6 1   3
2 18   6 2   4
2 18   8 1   3
2 18   8 2   4
2 18  23 1  24
2 18  23 2  25
2 18  24 1  25
2 18  24 2  23
2 18  25 1  23
2 18  25 2  24
2 18  26 1  12
2 18  26 2  28
2 18  28 1  26
2 18  28 2  27
2 18  50 1  51
2 18  50 2  49
2 18  56 1  58
2 18  56 2  61
2 18  57 1  63
2 18  57 2  61
2 18  59 1  58
2 18  59 2  61
2 18  65 1  69
2 18  65 2  70
2 18  67 1  69
2 18  67 2  70
2 18  68 1  69
2 18  68 2  70
2 18  73 1  76
2 18  73 2  77
2 18  74 1  73
2 18  74 2  76
2 18  86 1  89
2 18  86 2  84
2 18  88 1  87
2 18  88 2  89
2 18  92 1  93
2 18  92 2  94
2 18  99 1 102
2 18  99 2 107
2 19   5 1   2
2 19   5 2   4
2 19   8 1   6
2 19   9 1  48
2 19  13 1  14
2 19  13 2  15
2 19  18 1  14
2 19  18 2  15
2 19  23 1  36
2 19  23 2  24
2 19  29 1  28
2 19  29 2  30
2 19  30 1  28
2 19  31 1  28
2 19  31 2  30
2 19  37 1  38
2 19  42 1  41
2 19  46 1  44
2 19  49 1  41
2 19  55 1  59
2 19  55 2  56
2 19  57 1  58
2 19  58 1  57
2 19  60 1  59
2 19  61 1  65
2 19  70 1  69
2 19  86 1  80
2 19  92 1  93
2 19  92 2  94
2 19  97 1  98
2 19 104 1 102
2 19 104 2 103
2 19 105 1 102
2 20   8 1   0
2 20   8 2   9
2 20  10 1   0
2 20  10 2  11
2 20  10 3  12
2 20  13 1   0
2 20  13 2  15
2 20  15 1   0
2 20  15 2  16
2 20  18 1   0
2 20  18 2  19
2 20  18 3  17
2 20  21 1   0
2 20  21 2  20
2 20  30 1   0
2 20  30 2  29
2 20  33 1   0
2 20  33 2  32
2 20  37 1   0
2 20  37 2  38
2 20  37 3  39
2 20  46 1   0
2 20  46 2  41
2 20  46 3  43
2 20  47 1   0
2 20  47 2  48
2 20  47 3  49
2 20  50 1   0
2 20  50 2  51
2 20  50 3  53
2 20  55 1   0
2 20  55 2  57
2 20  58 1   0
2 20  58 2  57
2 20  65 1   0
2 20  65 2  62
2 20  65 3  64
2 20  70 1   0
2 20  70 2  69
2 20  71 1   0
2 20  71 2  69
2 21   1 1   2
2 21   1 2   3
2 21   3 1   2
2 21  11 1  12
2 21  13 1  15
2 21  24 1  23
2 21  32 1  33
2 21  32 2  34
2 21  32 3  35
2 21  35 1  33
2 21  35 2  34
2 21  37 1  36
2 21  41 1  42
2 21  47 1  65
2 21  47 2  63
2 21  54 1  55
2 21  54 2  56
2 21  54 3  57
2 21  57 1  54
2 21  57 2  55
2 21  57 3  56
2 21  58 1  54
2 21  58 2  55
2 21  58 3  56
2 21  61 1  59
2 21  61 2  60
2 21  63 1  47
2 21  63 2  65
2 21  65 1  63
2 21  65 2  47
2 21  73 1  71
2 21  73 2  72
2 22  18 1  20
2 22  18 2  19
2 22  19 1  20
2 22  19 2  18
2 22  21 1  22
2 22  21 2  23
2 22  55 1  54
2 22  55 2  51
2 22  69 1  68
2 23   2 1 204
2 23   4 1  12
2 23   7 1   8
2 23  19 1  17
2 23  22 1  21
2 23  25 1  24
2 23  25 2  27
2 23  31 1  29
2 23  31 2  30
2 23  41 1  42
2 23  41 2  43
2 23  41 3  44
2 23  51 1  52
2 23  64 1  55
2 24   4 1  11
2 24   5 1  16
2 24   5 2   4
2 24   7 1  12
2 24  12 1  13
2 24  18 1  17
2 24  19 1  16
2 24  19 2  17
2 24  25 1  24
2 24  33 1  32
2 24  36 1  34
2 24  36 2  35
2 24  43 1  44
2 24  43 2  45
2 24  46 1  45
2 24  49 1  48
2 24  55 1  54
2 24  55 2  56
2 24  65 1  63
2 24  65 2  66
2 24  91 1  92
2 24  99 1  34
2 24  99 2  35
2 24 102 1 105
2 25   1 1   2
2 25   1 2   7
2 25   1 3   5
2 25   4 1   5
2 25   4 2   6
2 25   4 3   7
2 25   8 1   6
2 25   8 2   7
2 25   8 3   9
2 25  12 1   5
2 25  12 2   6
2 25  12 3   7
2 25  23 1  24
2 25  23 2  25
2 25  23 3  26
2 25  25 1  24
2 25  25 2  26
2 25  25 3  27
2 25  36 1  38
2 25  36 2  39
2 25  36 3  40
2 25  46 1  45
2 25  46 2  47
2 25  46 3  48
2 25  57 1  55
2 25  59 1  56
2 25  59 2  58
2 25  59 3  57
2 25  80 1  79
2 25  80 2  81
2 25  80 3  78
2 25  81 1  86
2 25  81 2  87
2 25  84 1  83
2 25  84 2  82
2 25  84 3  85
2 26   7 1   6
2 26   7 2   8
2 26  17 1  16
2 26  17 2  18
2 26  27 1  25
2 26  27 2  26
2 26  27 3  24
2 26  30 1  31
2 26  30 2  32
2 26  33 1  31
2 26  33 2  32
2 26  34 1  35
2 26  34 2  36
2 26  41 1  39
2 26  41 2  40
2 26  43 1  42
2 26  44 1  42
2 26  44 2  43
2 26  54 1  53
2 26  54 2  56
2 26  58 1  53
2 26  58 2  54
2 26  62 1  59
2 26  62 2  60
2 26  62 3  61
2 26  66 1  64
2 26  66 2  65
2 26  66 3  68
2 26  73 1  68
2 26  73 2  70
2 26  80 1  79
2 26  80 2  77
2 27   3 1   2
2 27   3 2   5
2 27  15 1  11
2 27  15 2   2
2 27  35 1  32
2 27  35 2  33
2 27  38 1  33
2 27  38 2  34
2 27  38 3  32
2 27  48 1  49
2 27  48 2  47
2 27  54 1  56
2 27  54 2  55
2 27  58 1  61
2 27  58 2  62
2 27  62 1  60
2 27  62 2  61
2 28   8 1   5
2 28  17 1  15
2 28  20 1  21
2 28  43 1  44
2 28  50 1  49
2 28  50 2  46
2 28  50 3  55
2 28  54 1  53
2 28  64 1  65
2 28  64 2  66
2 28  65 1  66
2 28  65 2  67
2 28  77 1  78
2 28  77 2  81
2 28  79 1  77
2 28  79 2  78
2 28  79 3  81
2 28  80 1  77
2 28  80 2  78
2 28  80 3  81
2 29  10 1  11
2 29  10 2  12
2 29  12 1  11
2 29  12 2  16
2 29  14 1  13
2 29  14 2  14
2 29  15 1  16
2 29  15 2  17
2 29  36 1  32
2 29  36 2  33
2 29  37 1  44
2 29  37 2  49
2 29  37 3   1
2 29  44 1  45
2 29  44 2  46
2 29  47 1  46
2 29  47 2  45
2 29  50 1  52
2 29  50 2  53
2 29  50 3  51
2 29  51 1  50
2 29  51 2  52
2 29  53 1  55
2 29  53 2  56
2 29  54 1  55
2 29  54 2  56
2 29  57 1  55
2 29  57 2  56
2 29  67 1  66
2 29  67 2  70
2 30   3 1   2
2 30   3 2   5
2 30   9 1   8
2 30   9 2   6
2 30  14 1  12
2 30  14 2  13
2 30  23 1  25
2 30  23 2  20
2 30  35 1  31
2 30  35 2  32
2 30  36 1  32
2 30  36 2  35
2 30  39 1  38
2 30  39 2  42
2 30  44 1  42
2 30  44 2  43
2 30  50 1  47
2 30  50 2  48
2 30  50 3  49
2 30  59 1  42
2 30  59 2  55
2 30  60 1  57
2 30  60 2  58
2 30  62 1  63
2 30  62 2  61
2 30  70 1  68
2 30  70 2  69
2 30  70 3  71
2 30  72 1  74
2 30  72 2  75
2 30  73 1  71
2 30  73 2  72
2 30  76 1  74
2 30  76 2  75
2 30  77 1  71
2 30  77 2  75
2 30  78 1  80
2 30  78 2  83
2 30  79 1  80
2 30  79 2  83
2 30  82 1  80
2 30  82 2  75
2 30  83 1  80
2 30  83 2  75
2 31   4 1   2
2 31   4 2   6
2 31  10 1  12
2 31  20 1  25
2 31  22 1  23
2 31  22 2  25
2 31  24 1  22
2 31  24 2  23
2 31  35 1  49
2 31  35 2  50
2 31  45 1  46
2 31  45 2  47
2 31  46 1   5
2 31  46 2  47
2 31  47 1  45
2 31  47 2  46
2 31  49 1  48
2 31  49 2  50
2 31  61 1  59
2 31  61 2  60
2 31  66 2   6
2 32   7 1   8
2 32  17 1  16
2 32  17 2  18
2 32  28 1  27
2 32  28 2  29
2 32  35 1  33
2 32  35 2  36
2 32  36 1  35
2 32  36 2  33
2 32  37 1  33
2 32  37 2  35
2 32  37 3   6
2 32  42 1  41
2 32  44 1  45
2 32  44 2  46
2 32  48 1  38
2 32  48 2  49
2 32  50 1  53
2 32  50 2  51
2 32  50 3  52
2 32  56 1  52
2 32  56 2  54
2 32  56 3  55
2 32  57 1  58
2 32  57 2  59
2 32  65 1  67
2 33   8 1   8
2 33   8 2  10
2 33   9 1   8
2 33  10 1   8
2 33  11 1  10
2 33  11 2  12
2 33  14 1  13
2 33  17 1  15
2 33  22 1  23
2 33  22 2  24
2 33  22 3  25
2 33  32 1  22
2 33  32 2  31
2 33  32 3  38
2 33  42 1  43
2 33  42 2  44
2 33  45 1  46
2 33  45 2  47
2 33  51 1  48
2 33  51 2  52
2 33  57 1  58
2 33  57 2  59
2 33  57 3  60
2 33  70 1  68
2 33  70 2  69
2 34   3 1   1
2 34   3 2   2
2 34   3 3   4
2 34   4 1   1
2 34   4 2   2
2 34   4 3   3
2 34  15 1  16
2 34  15 2  17
2 34  25 1  26
2 34  25 2  24
2 34  27 1  28
2 34  27 2  29
2 34  29 1  27
2 34  29 2  28
2 34  33 1  29
2 34  33 2  36
2 34  38 1  37
2 34  39 1  40
2 34  39 2  41
2 34  45 1  51
2 34  51 1  52
2 34  54 1  53
2 34  61 1  59
2 34  61 2  60
2 34  71 1  70
2 34  71 2  72
2 34  82 1  80
2 34  85 1  84
2 34  85 2  86
2 34  85 3  87
2 34  95 1  96
2 34  95 2  97
2 35  10 1   7
2 35  10 2  11
2 35  13 1  12
2 35  13 2  14
2 35  15 1  14
2 35  15 2  16
2 35  18 1  17
2 35  23 1  24
2 35  25 1  23
2 35  25 2  24
2 35  26 1  23
2 35  26 2  24
2 35  29 1  30
2 35  29 2  31
2 35  29 3  25
2 35  37 1  38
2 35  39 1  36
2 35  39 2  37
2 35  55 1  53
2 35  64 1  63
2 35  78 1  77
2 35  78 2  79
2 35  79 1  77
2 35  79 2  78
2 35  80 1  77
2 35  80 2  78
2 35  80 3  79
2 35  82 1  77
2 35  82 2  78
2 35  82 3  79
2 36   5 1   6
2 36   5 2   7
2 36   7 1   4
2 36   7 2   5
2 36  12 1  14
2 36  12 2  16
2 36  15 1  12
2 36  15 2  14
2 36  15 3  16
2 36  20 1  19
2 36  20 2  21
2 36  22 1  21
2 36  22 2  24
2 36  22 3  25
2 36  23 1  24
2 36  23 2  25
2 36  27 1  24
2 36  27 2  25
2 36  27 3  26
2 36  29 1  31
2 36  29 2  28
2 36  30 1  28
2 36  30 2  29
2 36  30 3  31
2 36  32 1  34
2 36  32 2  33
2 36  32 3  30
2 36  39 1  37
2 36  39 2  38
2 36  40 1  35
2 36  40 2  36
2 36  41 1  36
2 36  41 2  37
2 36  45 1  46
2 36  45 2  47
2 36  46 1  43
2 36  46 2  42
2 36  61 1  63
2 36  61 2  59
2 36  62 1  58
2 36  62 2  59
2 36  62 3  60
2 36  68 1  66
2 36  68 2  67
2 37   3 1   2
2 37   3 2   4
2 37  15 1  14
2 37  21 1  19
2 37  23 1  32
2 37  23 2 208
2 37  24 1  32
2 37  29 1  32
2 37  29 2 203
2 37  31 1  32
2 37  34 1  22
2 37  34 2  30
2 37  46 1  50
2 37  46 2  49
2 37  56 1  57
end

[Clyde Schechter]

gen dyad1 = min(hhi, hhj)
gen dyad2 = max(hhi, hhj)

by branchid village dyad1 dyad2, sort: gen reciprocating = hhi[1] != hhi[_N]