Graphs for pre and post treatment outcomes

Aisha Khan

Join Date: May 2023
Posts: 43

Graphs for pre and post treatment outcomes

25 Mar 2024, 16:52

I have a data set on crop production for around 3752 farmers over three time periods (wave1 in 2020, wave 2 in 2021 and wave 3 in 2023). the data also records the implementation of ‘technology demonstrations’ for a control group. So ‘technology demonstrations’ is my treatment variable and it gives me a control group and a treatment group
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

My question is that what graphs can I effectively use to show the difference between the control and treatment groups pre and post treatment. Till now I have tried simple line graphs and box plots, but they are not visually appealing and there may be a better way to show this.
My objective is to capture any difference (of lack of difference) in the outcome (crop prodcution) in the two groups pre and post intervention.

This is what I tried

Code:

egen g=group( Treatment wave )
stripplot Crop_Production  , over( g) box refline cumul cumprob centre vertical scheme(s1color) xla(, tlc(none))

Last edited by Aisha Khan; 25 Mar 2024, 17:01.

Tags: Boxplots, graphs

Joseph Coveney

Join Date: Apr 2014

Posts: 4352
#2

25 Mar 2024, 22:20

Originally posted by Aisha Khan View Post

. . . what graphs can I effectively use to show the difference between the control and treatment groups pre and post treatment. . . . My objective is to capture any difference (of lack of difference) in the outcome (crop prodcution) in the two groups pre and post intervention.

How about something like the following?

Code:

mixed Crop_Production i.Treatment##i.year || Respondent_id: , nolrtest nolog quietly margins Treatment#year marginsplot , /// xdimension(year) /// plotdimension(Treatment) /* plotopts(lcolor(black)) */ /// plot1opts(msymbol(O) mcolor(black) mfcolor(white)) /// plot2opts(msymbol(T) msize(medlarge) mcolor(black) mfcolor(white)) /// ciopts(lcolor(black)) level(67) /// title("") ytitle(Crop Production) xtitle(Year) /// scheme(stsj) ylabel( , nogrid) /// legend(off)

Be sure to parenthetically include the units of measurement (metric tons?) in the y-axis title.
1 like
Comment

Announcement

Graphs for pre and post treatment outcomes

Comment