Using egen for multiple variables and multiple options

[Alvin Ghimire]

Hello,
I wanted generate variables maizerain, maizetmax, maizetmin, maizediurnal and similar ones for rice and paddy based on maizecal, wheatcal paddycal, where I want the sum for rain and mean for tmax tmin and diurnal. I tried collapsing, with that I will have so many datasets which I don't want. In addition to that I tried

bys district year maizecal: egen maizerain=total(rain)

, which didn't gave me the expected results as there were multiple years and growing seasons after that code. Let me know if I could incorporate the seasons to generate seasonwise rain and temp variables. Thanks.

* Example generated by -dataex-. To install: ssc install dataex
clear
input str9 district float mdate str3 month float(year distnum) double(paddy wheat maize tmax tmin rain) float diurnal str6 season str10(maizecal paddycal wheatcal)
"Banke" 324 "Jan" 1987 11  784 1500    1228  22.05806541442871 10.854838371276855               2.42 11.203227 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 325 "Feb" 1987 11  784 1500    1228 26.578571319580078 14.853846549987793              16.58 11.724725 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 326 "Mar" 1987 11  784 1500    1228   31.3935489654541 17.187097549438477               5.34  14.20645 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 327 "Apr" 1987 11  784 1500    1228  36.44137954711914  20.27241325378418              24.18 16.168966 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 328 "May" 1987 11  784 1500    1228  36.64838790893555 23.354839324951172               71.4  13.29355 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 329 "Jun" 1987 11  784 1500    1228  39.47999954223633 27.823333740234375              35.96 11.656666 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 330 "Jul" 1987 11  784 1500    1228  32.86451721191406  26.28709602355957                597  6.577421 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 331 "Aug" 1987 11  784 1500    1228 32.929630279541016 26.185184478759766              181.8  6.744446 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 332 "Sep" 1987 11  784 1500    1228 32.790000915527344 25.739999771118164 159.01999999999998  7.050001 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 333 "Oct" 1987 11  784 1500    1228 31.103225708007813 21.312902450561523              35.76  9.790323 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 334 "Nov" 1987 11  784 1500    1228 28.469999313354492 13.920000076293945                  0     14.55 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 335 "Dec" 1987 11  784 1500    1228  23.98064422607422 10.135483741760254               6.88  13.84516 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 336 "Jan" 1988 11 2000 1450     743 23.148387908935547  8.829031944274902 10.440000000000001 14.319356 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 337 "Feb" 1988 11 2000 1450     743  26.58965492248535 11.751724243164063               6.24  14.83793 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 338 "Mar" 1988 11 2000 1450     743 30.570968627929688 14.870967864990234 31.839999999999996      15.7 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 339 "Apr" 1988 11 2000 1450     743  37.28666687011719 20.690000534057617               24.7 16.596666 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 340 "May" 1988 11 2000 1450     743  37.86451721191406 25.387096405029297 43.160000000000004  12.47742 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 341 "Jun" 1988 11 2000 1450     743  36.28620529174805  25.81999969482422 192.04000000000002 10.466206 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 342 "Jul" 1988 11 2000 1450     743  32.33548355102539 26.512903213500977             677.06   5.82258 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 343 "Aug" 1988 11 2000 1450     743  31.90322494506836 26.138710021972656  533.8399999999999  5.764515 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 344 "Sep" 1988 11 2000 1450     743  32.91999816894531 25.543333053588867  65.61999999999999  7.376665 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 345 "Oct" 1988 11 2000 1450     743  32.10645294189453 20.045162200927734 18.279999999999998  12.06129 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 346 "Nov" 1988 11 2000 1450     743  28.58333396911621 15.403448104858398                  0 13.179886 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 347 "Dec" 1988 11 2000 1450     743 24.445161819458008 11.761401653289795 31.840000000000003  12.68376 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 348 "Jan" 1989 11 2200 1560    1159 20.558063507080078  8.119355201721191 42.160000000000004 12.438708 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 349 "Feb" 1989 11 2200 1560    1159 23.939285278320313  9.228571891784668               8.74 14.710713 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 350 "Mar" 1989 11 2200 1560    1159 30.354839324951172 14.619355201721191                  7 15.735484 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 351 "Apr" 1989 11 2200 1560    1159   36.0966682434082 18.856666564941406                  0 17.240002 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 352 "May" 1989 11 2200 1560    1159  38.10322570800781 25.053333282470703 30.359999999999996 13.049892 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 353 "Jun" 1989 11 2200 1560    1159  34.52666473388672  25.19333267211914 222.61999999999998  9.333332 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 354 "Jul" 1989 11 2200 1560    1159 32.435482025146484 26.274192810058594              568.9  6.161289 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 355 "Aug" 1989 11 2200 1560    1159 32.793548583984375 26.006450653076172             261.58  6.787098 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 356 "Sep" 1989 11 2200 1560    1159  32.13666534423828 25.049999237060547 297.15999999999997  7.086666 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 357 "Oct" 1989 11 2200 1560    1159  31.63225746154785   21.1741943359375              37.78 10.458063 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 358 "Nov" 1989 11 2200 1560    1159 27.729999542236328 14.706666946411133                8.1 13.023333 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 359 "Dec" 1989 11 2200 1560    1159 22.641935348510742 11.512903213500977 26.860000000000003 11.129032 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 360 "Jan" 1990 11 2000 1495 1394.25  21.63548469543457  9.190322875976563                  0 12.445162 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 361 "Feb" 1990 11 2000 1495 1394.25  23.60714340209961 11.767999649047852  81.74000000000001 11.839144 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 362 "Mar" 1990 11 2000 1495 1394.25 28.070968627929688 15.216129302978516              81.18  12.85484 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 363 "Apr" 1990 11 2000 1495 1394.25  34.95000076293945 19.683332443237305               6.88 15.266668 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 364 "May" 1990 11 2000 1495 1394.25 34.358062744140625 24.049999237060547             166.68 10.308064 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 365 "Jun" 1990 11 2000 1495 1394.25 35.733333587646484   26.5766658782959              183.3  9.156668 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 366 "Jul" 1990 11 2000 1495 1394.25  31.86451530456543                 26  553.0200000000001  5.864515 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 367 "Aug" 1990 11 2000 1495 1394.25  33.19655227661133 26.455554962158203             229.18  6.740997 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 368 "Sep" 1990 11 2000 1495 1394.25 32.599998474121094 25.386667251586914             128.68  7.213331 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 369 "Oct" 1990 11 2000 1495 1394.25 31.232257843017578 19.622581481933594              37.72 11.609676 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 370 "Nov" 1990 11 2000 1495 1394.25 28.920000076293945 14.220000267028809                  0      14.7 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 371 "Dec" 1990 11 2000 1495 1394.25 24.299999237060547 10.180644989013672 32.739999999999995 14.119354 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 372 "Jan" 1991 11 1800 1430  1629.5 21.455171585083008  8.117240905761719 28.580000000000002  13.33793 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 373 "Feb" 1991 11 1800 1430  1629.5 26.325000762939453 11.689285278320313              34.18 14.635715 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 374 "Mar" 1991 11 1800 1430  1629.5 31.225807189941406   15.8903226852417              35.16 15.335485 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 375 "Apr" 1991 11 1800 1430  1629.5 35.900001525878906 20.106666564941406 34.300000000000004 15.793335 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 376 "May" 1991 11 1800 1430  1629.5  39.33871078491211 25.574193954467773 38.980000000000004 13.764517 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 377 "Jun" 1991 11 1800 1430  1629.5   36.0099983215332 27.086666107177734             104.28  8.923332 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 378 "Jul" 1991 11 1800 1430  1629.5 34.586666107177734 26.963333129882812             132.94  7.623333 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 379 "Aug" 1991 11 1800 1430  1629.5  32.69355010986328 26.151613235473633             373.54  6.541937 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 380 "Sep" 1991 11 1800 1430  1629.5   32.6185188293457 24.914813995361328 188.73999999999995  7.703705 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 381 "Oct" 1991 11 1800 1430  1629.5  32.16128921508789  19.99032211303711                  0 12.170967 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 382 "Nov" 1991 11 1800 1430  1629.5  26.72333335876465 12.796667098999023               6.44 13.926666 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 383 "Dec" 1991 11 1800 1430  1629.5 22.774192810058594  9.706451416015625 63.720000000000006  13.06774 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 384 "Jan" 1992 11 1600 1365 1864.75 21.229032516479492  8.809677124023438              44.26 12.419355 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 385 "Feb" 1992 11 1600 1365 1864.75 22.568965911865234   9.54137897491455              23.82 13.027587 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 386 "Mar" 1992 11 1600 1365 1864.75  31.04838752746582 15.361289978027344              17.02 15.687098 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 387 "Apr" 1992 11 1600 1365 1864.75  37.38999938964844 20.706666946411133 24.279999999999998 16.683332 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 388 "May" 1992 11 1600 1365 1864.75  37.71034622192383 23.796552658081055                 22 13.913794 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 389 "Jun" 1992 11 1600 1365 1864.75  37.70000076293945 26.453332901000977             129.34 11.246668 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 390 "Jul" 1992 11 1600 1365 1864.75 33.709678649902344 26.161291122436523 263.15999999999997  7.548388 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 391 "Aug" 1992 11 1600 1365 1864.75 32.954837799072266 26.445161819458008 386.76000000000005  6.509676 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 392 "Sep" 1992 11 1600 1365 1864.75  32.90999984741211 24.899999618530273 264.69999999999993      8.01 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 393 "Oct" 1992 11 1600 1365 1864.75 31.274192810058594  21.04838752746582               92.4 10.225805 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 394 "Nov" 1992 11 1600 1365 1864.75  28.23666763305664   15.1899995803833 16.979999999999997 13.046668 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 395 "Dec" 1992 11 1600 1365 1864.75 23.003225326538086 10.041935920715332              12.58  12.96129 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 396 "Jan" 1993 11 1400 1300    2100  19.40999984741211  8.573333740234375               5.62 10.836666 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 397 "Feb" 1993 11 1400 1300    2100 26.321428298950195 12.414285659790039                3.9 13.907143 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 398 "Mar" 1993 11 1400 1300    2100  28.79032325744629  13.95161247253418  45.81999999999999  14.83871 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 399 "Apr" 1993 11 1400 1300    2100  35.27000045776367 19.670000076293945 31.879999999999995      15.6 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 400 "May" 1993 11 1400 1300    2100   36.1129035949707 24.809677124023438              97.22 11.303226 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 401 "Jun" 1993 11 1400 1300    2100                 36 26.149999618530273 187.23999999999995      9.85 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 402 "Jul" 1993 11 1400 1300    2100 33.836666107177734  26.44333267211914              302.2  7.393333 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 403 "Aug" 1993 11 1400 1300    2100  32.83871078491211 26.264516830444336  485.9799999999999  6.574194 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 404 "Sep" 1993 11 1400 1300    2100  32.02000045776367  24.93666648864746             163.82  7.083334 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 405 "Oct" 1993 11 1400 1300    2100  32.90645217895508 20.651613235473633 15.919999999999998  12.25484 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 406 "Nov" 1993 11 1400 1300    2100 28.982759475708008 15.510344505310059  4.140000000000001 13.472415 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 407 "Dec" 1993 11 1400 1300    2100 25.467741012573242  10.54838752746582               9.42 14.919353 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 408 "Jan" 1994 11 1184 1375    1964  22.71290397644043   9.14838695526123 24.900000000000002 13.564517 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 409 "Feb" 1994 11 1184 1375    1964 24.367856979370117 11.225000381469727              36.32 13.142857 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 410 "Mar" 1994 11 1184 1375    1964  31.59677505493164  16.19354820251465               2.74 15.403227 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 411 "Apr" 1994 11 1184 1375    1964  35.78333282470703 20.260000228881836               8.32 15.523333 "spring" "leanperiod" "leanperiod" "harvest"  
"Banke" 412 "May" 1994 11 1184 1375    1964 39.216129302978516  25.79032325744629 32.839999999999996 13.425806 "spring" "sowing"     "leanperiod" "harvest"  
"Banke" 413 "Jun" 1994 11 1184 1375    1964  37.20000076293945  27.59000015258789 262.03999999999996  9.610001 "summer" "sowing"     "leanperiod" "leanperiod"
"Banke" 414 "Jul" 1994 11 1184 1375    1964  34.25806427001953  26.93225860595703 260.08000000000004  7.325806 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 415 "Aug" 1994 11 1184 1375    1964  32.69355010986328 26.348386764526367 230.36000000000004  6.345163 "summer" "growing"    "sowing"     "leanperiod"
"Banke" 416 "Sep" 1994 11 1184 1375    1964 33.372413635253906  24.77666664123535             128.88  8.595747 "summer" "harvest"    "growing"    "leanperiod"
"Banke" 417 "Oct" 1994 11 1184 1375    1964  32.40322494506836 19.264516830444336               5.92 13.138708 "autumn" "harvest"    "growing"    "leanperiod"
"Banke" 418 "Nov" 1994 11 1184 1375    1964  28.66666603088379 14.186666488647461                  0     14.48 "autumn" "leanperiod" "harvest"    "sowing"   
"Banke" 419 "Dec" 1994 11 1184 1375    1964 24.503225326538086  9.729032516479492  5.340000000000001 14.774193 "winter" "leanperiod" "leanperiod" "sowing"   
"Banke" 420 "Jan" 1995 11  968 1450    1828  20.95161247253418  8.677419662475586              19.04 12.274193 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 421 "Feb" 1995 11  968 1450    1828 25.003570556640625 11.364285469055176 34.760000000000005 13.639285 "winter" "leanperiod" "leanperiod" "growing"  
"Banke" 422 "Mar" 1995 11  968 1450    1828  30.30645179748535 14.896774291992188              17.46 15.409678 "spring" "leanperiod" "leanperiod" "growing"  
"Banke" 423 "Apr" 1995 11  968 1450    1828 37.266666412353516 20.036666870117188 15.719999999999999     17.23 "spring" "leanperiod" "leanperiod" "harvest"  
end
format %tm mdate

[Nick Cox]

What's your definition of growing season? Presumably not identical across crops.

[Alvin Ghimire]

After the egen command, it must have only four values of maizecal i.e. growing, sowing, harvest, leanperiod for a year, but, I got more than four values of maizecal for the same year.

[Nick Cox]

So, each *cal variable is an argument to egen. Sorry, but I don't understand what your difficulty is. Calculate the totals you want by specifying the variables that define groups.

[Alvin Ghimire]

I would appreciate if we could loop to collapse and append all the collapsed datasets to have one big dataset with all the variables I required. That way would be more better if incase egen couldn't provide the output as I intend. Thanks.

[Alvin Ghimire]

So, each *cal variable is an argument to egen. Sorry, but I don't understand what your difficulty is. Calculate the totals you want by specifying the variables that define groups.

Hi Nick,

I wanted to generate the climatic variables maizerain maizetmax……...wheatrain…...paddyrain….and so on.... based on maizecal, wheatcal and paddycal. Here, maizecal is the crop calendar of maize which gives the sowing months, growing months, harvest months and lean periods, I wanted to egen maizerain as the sum of rain based on maizecal. So that, I will have the data that shows the rainfall amount during sowing period of maize. Similar to wheat and paddy.

[Nick Cox]

Again, what's the difficulty?