Announcement

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

  • Difference-in-differences estimation


    I have a data set on around 1890 farmers over two time periods and I am trying to implement a Difference-in-differences estimation to understand of dissemination of technical information impacted crop yields

    The dataset is on farmers (Respondents). They are located within villages (41 villages), located within higher geograohical units called Halqa (4 in total), located within higher geograohical units called tehsils (2 in total). I have this data for 2 time periods (wave1 in 2020 and wave 2 in 2021). Out of the 4 Halqa 2 are treated and 2 are control. Both tehsils have treated and control Halqa

    I run the following command

    Code:
    xtset Respondent_id
    xtdidregress ( Crop_Production )( Treatment ), group( Halqa_encoded ) time(wave)
    and get the error

    Code:
    The treatment variable Treatment was omitted because of collinearity.
    r(198);
    I realize that this question has been asked before. I have gone through the Statalist posts as well as the helpfile, but cant get what I am missing.


    Below is an example of my data.



    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input long Respondent_id byte(wave result) int year float Treatment str9 Tehsil    str12    Halqa    str23    Village    int    Crop_Production    long    Halqa_encoded
    11101101 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            50 4
    11101101 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            10 4
    11101102 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            40 4
    11101102 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            10 4
    11101103 1 2 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            50 4
    11101104 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101104 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            60 4
    11101105 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            50 4
    11101105 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            70 4
    11101106 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            40 4
    11101106 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            80 4
    11101107 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            20 4
    11101107 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101108 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101108 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            80 4
    11101109 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            25 4
    11101109 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            40 4
    11101110 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101110 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            20 4
    11101111 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            33 4
    11101111 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            40 4
    11101112 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            50 4
    11101112 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101113 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            15 4
    11101113 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101114 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            15 4
    11101114 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            40 4
    11101115 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101115 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11101116 1 1 2020 1 "Muridke"   "Muridke"   "Qila Bhattian"            35 4
    11101116 2 1 2021 1 "Muridke"   "Muridke"   "Qila Bhattian"            30 4
    11102101 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  40 4
    11102101 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  75 4
    11102105 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  20 4
    11102105 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  70 4
    11102106 1 2 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  33 4
    11102108 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  20 4
    11102108 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  30 4
    11102109 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  15 4
    11102109 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  20 4
    11102111 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  20 4
    11102111 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  30 4
    11102112 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  60 4
    11102112 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  30 4
    11102113 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  40 4
    11102113 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  40 4
    11102114 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  15 4
    11102114 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  50 4
    11102116 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  30 4
    11102116 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  50 4
    11102201 1 2 2020 1 "Muridke"   "Muridke"   "Sidhwan"                 100 4
    11102202 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  50 4
    11102202 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  40 4
    11102203 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  35 4
    11102203 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  20 4
    11102207 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  20 4
    11102207 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  40 4
    11102208 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  35 4
    11102208 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  70 4
    11102209 1 1 2020 1 "Muridke"   "Muridke"   "Sidhwan"                  70 4
    11102209 2 1 2021 1 "Muridke"   "Muridke"   "Sidhwan"                  60 4
    11103102 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103102 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103103 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 20 4
    11103103 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                  5 4
    11103104 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103104 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 60 4
    11103108 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103108 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103110 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 20 4
    11103110 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 90 4
    11103112 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103112 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103113 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 25 4
    11103113 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103114 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103114 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103115 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 75 4
    11103115 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 60 4
    11103116 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 25 4
    11103116 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103117 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103117 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103118 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103118 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103119 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103119 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 20 4
    11103123 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 25 4
    11103123 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103125 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103125 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 15 4
    11103127 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103127 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103130 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 60 4
    11103130 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 20 4
    11103201 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 25 4
    11103201 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 20 4
    11103203 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103203 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 60 4
    11103207 1 2 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 15 4
    11103208 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 70 4
    11103208 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 90 4
    11103209 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 60 4
    11103209 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 20 4
    11103211 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                  5 4
    11103211 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 20 4
    11103213 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 25 4
    11103213 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 90 4
    11103214 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103214 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 25 4
    11103215 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103215 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103216 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 25 4
    11103216 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103218 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 50 4
    11103218 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 70 4
    11103220 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103220 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 10 4
    11103226 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 18 4
    11103226 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 40 4
    11103231 1 2 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 10 4
    11103232 1 1 2020 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11103232 2 1 2021 1 "Muridke"   "Muridke"   "Bidadpur"                 30 4
    11104102 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               75 4
    11104102 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               20 4
    11104104 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               50 4
    11104104 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               30 4
    11104105 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"              100 4
    11104105 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               90 4
    11104106 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               20 4
    11104106 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               50 4
    11104107 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               80 4
    11104107 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               80 4
    11104108 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               30 4
    11104108 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               10 4
    11104110 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               30 4
    11104110 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               35 4
    11104112 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               20 4
    11104112 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               40 4
    11104113 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               80 4
    11104113 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               30 4
    11104201 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               45 4
    11104201 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               20 4
    11104202 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               50 4
    11104202 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               30 4
    11104203 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               40 4
    11104203 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               40 4
    11104205 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               85 4
    11104205 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               50 4
    11104206 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               30 4
    11104206 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               60 4
    11104207 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               80 4
    11104207 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               20 4
    11104208 1 1 2020 1 "Muridke"   "Muridke"   "Dilawarian"               80 4
    11104208 2 1 2021 1 "Muridke"   "Muridke"   "Dilawarian"               20 4
    11105101 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11105101 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              40 4
    11105102 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105102 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105104 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105104 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105105 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105105 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              55 4
    11105110 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              35 4
    11105110 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              35 4
    11105111 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105111 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105112 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105112 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              40 4
    11105115 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              60 4
    11105115 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              60 4
    11105116 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105116 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              60 4
    11105117 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105117 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              80 4
    11105119 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105119 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105123 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105123 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105124 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105124 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11105125 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105125 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              80 4
    11105126 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105126 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              35 4
    11105127 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              80 4
    11105127 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              10 4
    11105128 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              70 4
    11105128 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              70 4
    11105129 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              60 4
    11105129 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              40 4
    11105130 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              10 4
    11105130 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105131 2 5 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              80 4
    11105203 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105203 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11105204 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105204 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105205 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105205 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11105206 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105206 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11105211 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              25 4
    11105211 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105213 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              50 4
    11105213 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              40 4
    11105217 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              60 4
    11105217 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              10 4
    11105229 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11105229 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              40 4
    11105230 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105230 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              30 4
    11105231 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11105231 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              10 4
    11105232 1 1 2020 1 "Muridke"   "Muridke"   "Chak Sanata"              40 4
    11105232 2 1 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              80 4
    11105233 2 5 2021 1 "Muridke"   "Muridke"   "Chak Sanata"              20 4
    11201101 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       75 1
    11201101 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       25 1
    11201102 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201102 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201104 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       25 1
    11201104 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201105 1 2 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201106 1 2 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       60 1
    11201107 1 2 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       25 1
    11201108 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       70 1
    11201108 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       20 1
    11201110 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       30 1
    11201110 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201112 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       70 1
    11201112 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       20 1
    11201113 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       45 1
    11201113 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201114 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       15 1
    11201114 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201119 1 2 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       90 1
    11201120 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201120 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201122 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"      100 1
    11201122 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       30 1
    11201125 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201125 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       60 1
    11201126 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       20 1
    11201126 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201129 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201129 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"        0 1
    11201201 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       25 1
    11201201 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201205 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       70 1
    11201205 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       30 1
    11201206 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       80 1
    11201206 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       80 1
    11201209 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       90 1
    11201209 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       20 1
    11201210 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201210 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       30 1
    11201213 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201213 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       10 1
    11201214 1 2 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       10 1
    11201216 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201216 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201218 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       60 1
    11201218 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201219 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       60 1
    11201219 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       20 1
    11201220 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201220 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       60 1
    11201222 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       80 1
    11201222 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       95 1
    11201223 1 1 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       50 1
    11201223 2 1 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       35 1
    11201231 1 2 2020 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11201232 2 5 2021 0 "Muridke"   "Ahdian"    "Mahaj/Mahay Virkan"       40 1
    11203102 1 2 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  40 1
    11203103 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  40 1
    11203103 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  90 1
    11203105 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  20 1
    11203105 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  30 1
    11203106 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  30 1
    11203106 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  80 1
    11203108 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  25 1
    11203108 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  60 1
    11203110 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  50 1
    11203110 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  25 1
    11203115 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203115 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  30 1
    11203201 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  25 1
    11203201 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  40 1
    11203203 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  35 1
    11203203 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203205 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  50 1
    11203205 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  30 1
    11203209 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  20 1
    11203209 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203210 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203210 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203211 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  20 1
    11203211 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203215 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203215 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203216 1 1 2020 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky" 100 1
    11203216 2 1 2021 0 "Muridke"   "Ahdian"    "Rasulpura/Dharor Hindky"  90 1
    11204101 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     60 1
    11204101 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     40 1
    11204102 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                    100 1
    11204102 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     80 1
    11204103 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     60 1
    11204103 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     50 1
    11204104 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     95 1
    11204104 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     50 1
    11204105 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     50 1
    11204105 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     60 1
    11204112 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     70 1
    11204112 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     70 1
    11204113 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     30 1
    11204113 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     40 1
    11204115 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     75 1
    11204115 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     30 1
    11204116 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     75 1
    11204116 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                      0 1
    11204201 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     30 1
    11204201 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     40 1
    11204202 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     70 1
    11204202 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     80 1
    11204203 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     80 1
    11204203 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     80 1
    11204204 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                    100 1
    11204204 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                    100 1
    11204205 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     50 1
    11204205 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     50 1
    11204206 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     50 1
    11204206 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     50 1
    11204208 1 1 2020 0 "Muridke"   "Ahdian"    "Natt"                     70 1
    11204208 2 1 2021 0 "Muridke"   "Ahdian"    "Natt"                     20 1
    11205102 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"      100 1
    11205102 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       85 1
    11205103 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       20 1
    11205103 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       50 1
    11205104 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       40 1
    11205104 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       30 1
    11205105 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       25 1
    11205105 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       60 1
    11205106 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       30 1
    11205106 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       30 1
    11205108 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       40 1
    11205108 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       70 1
    11205114 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       80 1
    11205114 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       75 1
    11205202 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       30 1
    11205202 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       30 1
    11205203 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       80 1
    11205203 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       90 1
    11205204 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       80 1
    11205204 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"      100 1
    11205205 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       25 1
    11205205 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       50 1
    11205206 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       25 1
    11205206 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       50 1
    11205209 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       30 1
    11205209 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       30 1
    11205210 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       35 1
    11205210 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       40 1
    11205212 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       70 1
    11205212 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       40 1
    11205216 1 1 2020 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       40 1
    11205216 2 1 2021 0 "Muridke"   "Ahdian"    "Channi/Rakh Channi"       65 1
    end
    label values result labels0
    label def labels0 1 "completed - both", modify
    label def labels0 2 "completed - w1", modify
    label values Treatment group
    label def group 1 "Treatment", modify
    label values Crop_Production labels17
    label def labels17 9998 "Dont know", modify
    label values Halqa_encoded Halqa_encoded
    label def Halqa_encoded 2 "Chak Chattha", modify
    label def Halqa_encoded 3 "Hafizabad", modify

  • #2
    Dear Aisha,
    the issue regards the way in which you coded the Treatment variable. The command xtdidregress requires that the treatment variable is equal to 1 if the unit is treated and, after the treatment, 0 otherwise.

    It suffices to create a new variable defined as above:
    Code:
    gen treat = 0
    replace treat = 1 if Treatment == 1 & wave ==2
    
    xtset Respondent_id
    xtdidregress ( Crop_Production )( treat ), group( Halqa_encoded ) time(wave)
    I hope this helps.

    Comment


    • #3
      Hi Luca.
      Thank you for the suggestion. It works!!!

      Comment

      Working...
      X