How to create a binary variable from repeated surveys

[Charles Ackah]

Hi everyone,
I am working with panel data consisting of a survey of respondents(pid) across 3 waves (3, 4, and 5). How can I generate a binary variable that takes the value of 1 if a respondent(pid) appears in all 3 waves and 0 otherwise. Thanks.

* Example generated by -dataex-. To install: ssc install dataex
clear
input long pid float wave
301072 3
302124 3
303433 3
303536 3
304653 3
306632 3
306683 3
306683 4
307009 3
307105 3
307184 3
309889 3
309959 3
310765 3
314107 3
314119 3
314164 3
314873 3
315305 3
315366 3
315413 3
315918 3
315956 3
315979 3
316319 3
316564 3
316566 3
318376 3
318618 3
318635 3
318678 3
318679 3
318927 3
319396 3
319689 3
319941 3
321447 3
321485 3
321777 3
321785 3
322077 3
322526 3
381022 3
401011 3
401011 4
401011 5
401012 3
401013 3
401013 4
401013 5
401014 3
401014 4
401014 5
401015 3
401016 3
401016 4
401016 5
401017 3
401017 4
401017 5
401018 3
401018 4
401018 5
401019 3
401019 4
401019 5
401020 3
401020 4
401020 5
401021 3
401021 4
401021 5
401022 3
401022 4
401022 5
401023 3
401023 4
401023 5
401024 3
401024 4
401024 5
401025 3
401026 3
401026 4
401026 5
401027 3
401027 4
401028 3
401028 4
401028 5
401030 3
401030 4
401030 5
401031 3
401031 4
401031 5
401032 3
401032 4
401032 5
401033 3
end

[Carlo Lazzaro]

Charles:
you may want to try:

. bysort pid ( wave): egen wanted=count(pid)

. g counter=1 if wanted==3

. replace counter=0 if wanted<3


. list

     +----------------------------------+
     |    pid   wave   wanted   counter |
     |----------------------------------|
  1. | 301072      3        1         0 |
  2. | 302124      3        1         0 |
  3. | 303433      3        1         0 |
  4. | 303536      3        1         0 |
  5. | 304653      3        1         0 |
     |----------------------------------|
  6. | 306632      3        1         0 |
  7. | 306683      3        2         0 |
  8. | 306683      4        2         0 |
  9. | 307009      3        1         0 |
 10. | 307105      3        1         0 |
     |----------------------------------|
 11. | 307184      3        1         0 |
 12. | 309889      3        1         0 |
 13. | 309959      3        1         0 |
 14. | 310765      3        1         0 |
 15. | 314107      3        1         0 |
     |----------------------------------|
 16. | 314119      3        1         0 |
 17. | 314164      3        1         0 |
 18. | 314873      3        1         0 |
 19. | 315305      3        1         0 |
 20. | 315366      3        1         0 |
     |----------------------------------|
 21. | 315413      3        1         0 |
 22. | 315918      3        1         0 |
 23. | 315956      3        1         0 |
 24. | 315979      3        1         0 |
 25. | 316319      3        1         0 |
     |----------------------------------|
 26. | 316564      3        1         0 |
 27. | 316566      3        1         0 |
 28. | 318376      3        1         0 |
 29. | 318618      3        1         0 |
 30. | 318635      3        1         0 |
     |----------------------------------|
 31. | 318678      3        1         0 |
 32. | 318679      3        1         0 |
 33. | 318927      3        1         0 |
 34. | 319396      3        1         0 |
 35. | 319689      3        1         0 |
     |----------------------------------|
 36. | 319941      3        1         0 |
 37. | 321447      3        1         0 |
 38. | 321485      3        1         0 |
 39. | 321777      3        1         0 |
 40. | 321785      3        1         0 |
     |----------------------------------|
 41. | 322077      3        1         0 |
 42. | 322526      3        1         0 |
 43. | 381022      3        1         0 |
 44. | 401011      3        3         1 |
 45. | 401011      4        3         1 |
     |----------------------------------|
 46. | 401011      5        3         1 |
 47. | 401012      3        1         0 |
 48. | 401013      3        3         1 |
 49. | 401013      4        3         1 |
 50. | 401013      5        3         1 |
     |----------------------------------|
 51. | 401014      3        3         1 |
 52. | 401014      4        3         1 |
 53. | 401014      5        3         1 |
 54. | 401015      3        1         0 |
 55. | 401016      3        3         1 |
     |----------------------------------|
 56. | 401016      4        3         1 |
 57. | 401016      5        3         1 |
 58. | 401017      3        3         1 |
 59. | 401017      4        3         1 |
 60. | 401017      5        3         1 |
     |----------------------------------|
 61. | 401018      3        3         1 |
 62. | 401018      4        3         1 |
 63. | 401018      5        3         1 |
 64. | 401019      3        3         1 |
 65. | 401019      4        3         1 |
     |----------------------------------|
 66. | 401019      5        3         1 |
 67. | 401020      3        3         1 |
 68. | 401020      4        3         1 |
 69. | 401020      5        3         1 |
 70. | 401021      3        3         1 |
     |----------------------------------|
 71. | 401021      4        3         1 |
 72. | 401021      5        3         1 |
 73. | 401022      3        3         1 |
 74. | 401022      4        3         1 |
 75. | 401022      5        3         1 |
     |----------------------------------|
 76. | 401023      3        3         1 |
 77. | 401023      4        3         1 |
 78. | 401023      5        3         1 |
 79. | 401024      3        3         1 |
 80. | 401024      4        3         1 |
     |----------------------------------|
 81. | 401024      5        3         1 |
 82. | 401025      3        1         0 |
 83. | 401026      3        3         1 |
 84. | 401026      4        3         1 |
 85. | 401026      5        3         1 |
     |----------------------------------|
 86. | 401027      3        2         0 |
 87. | 401027      4        2         0 |
 88. | 401028      3        3         1 |
 89. | 401028      4        3         1 |
 90. | 401028      5        3         1 |
     |----------------------------------|
 91. | 401030      3        3         1 |
 92. | 401030      4        3         1 |
 93. | 401030      5        3         1 |
 94. | 401031      3        3         1 |
 95. | 401031      4        3         1 |
     |----------------------------------|
 96. | 401031      5        3         1 |
 97. | 401032      3        3         1 |
 98. | 401032      4        3         1 |
 99. | 401032      5        3         1 |
100. | 401033      3        1         0 |
     +----------------------------------+

.

[Charles Ackah]

Carlo Lazzaro, Thanks very much.