I am currently using the following code but i have been advice to use shorter codes. I tried using loops but i am not exactly sure how to start should i first generate all the variables and then replace? looking for help and guidance. thank you.
Code:
gen water_crops_1 =0 replace water_crops_1=1 if january==1 gen water_crops_2 =0 replace water_crops_2 =1 if january==2 replace water_crops_2 =1 if feb==2 gen water_crops_3 =0 replace water_crops_3 =1 if january==3 replace water_crops_3 =1 if feb==3 replace water_crops_3 =1 if mar==3 gen water_crops_4 =0 replace water_crops_4 =1 if january==4 replace water_crops_4 =1 if feb==4 replace water_crops_4 =1 if mar==4 replace water_crops_4 =1 if aprl==4 gen water_crops_5 =0 replace water_crops_5 =1 if january==5 replace water_crops_5 =1 if feb==5 replace water_crops_5 =1 if mar==5 replace water_crops_5 =1 if aprl==5 replace water_crops_5 =1 if may==5 gen water_crops_6 =0 replace water_crops_6 =1 if january==6 replace water_crops_6 =1 if feb==6 replace water_crops_6 =1 if mar==6 replace water_crops_6 =1 if aprl==6 replace water_crops_6 =1 if may==6 replace water_crops_6 =1 if june==6 gen water_crops_7 =0 replace water_crops_7 =1 if january==7 replace water_crops_7 =1 if feb==7 replace water_crops_7 =1 if mar==7 replace water_crops_7 =1 if aprl==7 replace water_crops_7 =1 if may==7 replace water_crops_7 =1 if june==7 replace water_crops_7 =1 if july==7 gen water_crops_8 =0 replace water_crops_8 =1 if january==8 replace water_crops_8 =1 if feb==8 replace water_crops_8 =1 if mar==8 replace water_crops_8 =1 if aprl==8 replace water_crops_8 =1 if may==8 replace water_crops_8 =1 if june==8 replace water_crops_8 =1 if july==8 replace water_crops_8 =1 if aug==8 gen water_crops_9 =0 replace water_crops_9 =1 if january==9 replace water_crops_9 =1 if feb==9 replace water_crops_9 =1 if mar==9 replace water_crops_9 =1 if aprl==9 replace water_crops_9 =1 if may==9 replace water_crops_9 =1 if june==9 replace water_crops_9 =1 if july==9 replace water_crops_9 =1 if aug==9 replace water_crops_9 =1 if sep==9 gen water_crops_10 =0 replace water_crops_10 =1 if january==10 replace water_crops_10 =1 if feb==10 replace water_crops_10 =1 if mar==10 replace water_crops_10 =1 if aprl==10 replace water_crops_10 =1 if may==10 replace water_crops_10 =1 if june==10 replace water_crops_10 =1 if july==10 replace water_crops_10 =1 if aug==10 replace water_crops_10 =1 if sep==10 replace water_crops_10 =1 if oct==10 gen water_crops_11 =0 replace water_crops_11 =1 if january==11 replace water_crops_11 =1 if feb==11 replace water_crops_11 =1 if mar==11 replace water_crops_11 =1 if aprl==11 replace water_crops_11 =1 if may==11 replace water_crops_11 =1 if june==11 replace water_crops_11 =1 if july==11 replace water_crops_11 =1 if aug==11 replace water_crops_11 =1 if sep==11 replace water_crops_11 =1 if oct==11 replace water_crops_11 =1 if nov==11 gen water_crops_12 =0 replace water_crops_12 =1 if january==12 replace water_crops_12 =1 if feb==12 replace water_crops_12 =1 if mar==12 replace water_crops_12 =1 if aprl==12 replace water_crops_12 =1 if may==12 replace water_crops_12 =1 if june==12 replace water_crops_12 =1 if july==12 replace water_crops_12 =1 if aug==12 replace water_crops_12 =1 if sep==12 replace water_crops_12 =1 if oct==12 replace water_crops_12 =1 if nov==12 replace water_crops_12 =1 if dec==12
