Hi everyone,
I am working with panel data which consists of three waves (3, 4, and 5) as below. I want to calculate the attrition weight; the inverse of the probability of being successfully reinterviewed in the subsequent wave, conditional on appearing in Wave 3 using a probit model. I have a set of covariates for the probit model, but I am confused about what the dependent variable should be or how to create it. What should be my dependent variable and which codes can I run to achieve the objective? I am not sure whether I have provided enough information but will do so when required. Thanks in advance.


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long pid float wave
401011 3
401011 4
401013 3
401014 3
401014 4
401014 5
401016 3
401016 4
401016 5
401017 3
401017 4
401018 3
401018 4
401018 5
401019 3
401020 3
401020 4
401020 5
401021 3
401021 4
401022 3
401022 4
401023 3
401023 4
401023 5
401024 3
401024 4
401024 5
401026 3
401026 4
401027 3
401028 3
401028 4
401028 5
401030 3
401030 4
401030 5
401031 3
401032 3
401032 4
401032 5
401033 3
401034 3
401035 3
401035 4
401035 5
401036 3
401036 4
401036 5
401037 3
401037 4
401037 5
401038 3
401038 4
401038 5
401039 3
401039 4
401040 3
401040 4
401040 5
401041 3
401042 3
401042 4
401043 3
401043 4
401043 5
401044 3
401044 4
401044 5
401045 3
401045 4
401045 5
401046 3
401046 4
401047 3
401047 4
401048 3
401048 4
401048 5
401050 3
401050 4
401050 5
401052 3
401052 4
401052 5
401056 3
401056 4
401056 5
401060 3
401064 3
401064 4
401064 5
401065 3
401065 4
401065 5
401066 3
401066 4
401066 5
401068 3
401068 4
401068 5
401069 3
401070 3
401070 4
401070 5
401071 3
401073 3
401073 4
401073 5
401075 3
401075 4
401075 5
401076 3
401076 4
401077 3
401077 4
401077 5
401079 3
401079 4
401080 3
401080 4
401080 5
401083 3
401084 3
401084 4
401084 5
401085 3
401085 4
401085 5
401087 3
401087 4
401087 5
401088 3
401088 4
401088 5
401089 3
401089 4
401089 5
401091 3
401091 4
401091 5
401092 3
401095 3
401095 4
401095 5
401097 3
401097 4
401097 5
401101 3
401101 4
401101 5
401102 3
401102 4
401103 3
401104 3
401104 4
401105 3
401106 3
401106 4
401106 5
401108 3
401108 4
401108 5
401111 3
401111 4
401111 5
401112 3
401112 4
401112 5
401114 3
401114 4
401114 5
401115 3
401115 4
401115 5
401118 3
401118 4
401119 3
401120 3
401120 4
401120 5
401123 3
401123 4
401123 5
401124 3
401124 4
401124 5
401125 3
401125 4
401129 3
401129 4
401129 5
401130 3
401133 3
401133 4
401133 5
401135 3
401135 4
401135 5
401136 3
end