Hi there!
I have a question about generating new variables which are averages of existing variables& observations.
As you can see, I now have monthly averages for all the variables listed. The analysis will be performed at the district level.
Let's take the variable comean as an example.
What I am trying to create is 1) a variable that contains the 3 month comean average for September-October- November of each year for each district(DNAME).
and 2) a variable that contains the annual comean average for each year for each district (DNAME).
I can't figure it out myself, any thoughts on this?
I have a question about generating new variables which are averages of existing variables& observations.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float(year month modate) str25 DNAME float comean double no2mean float(o3mean pm25mean so2mean hummean precmean tempmean TI_Count) 2011 1 612 "Abbottabad" 96.11294 1.310e+15 298.28824 1.76e-08 2.73e-09 .00392794 .3336239 9.507707 0 2011 2 613 "Abbottabad" 99.00775 1.460e+15 316.1375 2.65e-08 2.15e-09 .00545092 10.204703 8.897905 12 2011 3 614 "Abbottabad" 94.20843 1.810e+15 298.09076 2.39e-08 1.78e-09 .007622995 2.124073 16.084745 0 2011 4 615 "Abbottabad" 94.20843 1.810e+15 298.09076 2.39e-08 1.78e-09 .009222679 2.5252585 19.86308 4 2011 5 616 "Abbottabad" 104.68707 1.950e+15 275.99075 1.96e-08 1.58e-09 .01052664 1.0606406 28.08996 0 2011 6 617 "Abbottabad" 109.628 2.290e+15 281.9203 5.06e-08 1.91e-09 .013622346 .011838347 29.03797 4 2011 7 618 "Abbottabad" 108.49804 1.920e+15 276.34128 5.91e-08 1.92e-09 .018228771 6.863993 26.21046 0 2011 8 619 "Abbottabad" 109.3066 1.450e+15 274.3686 3.76e-08 1.70e-09 .01891132 10.042828 24.76641 0 2011 9 620 "Abbottabad" 101.22145 1.110e+15 269.13705 2.74e-08 2.07e-09 .016146185 3.0123484 23.46266 4 2011 10 621 "Abbottabad" 90.27409 1.350e+15 267.95438 2.55e-08 2.20e-09 .009440948 .4462588 20.54009 0 2011 11 622 "Abbottabad" 88.15783 1.220e+15 268.0185 2.11e-08 2.38e-09 .006934988 .5463931 17.047546 4 2011 12 623 "Abbottabad" 94.36868 1.930e+15 273.5778 2.20e-08 2.98e-09 .003909926 .1488069 12.05056 0 2012 1 624 "Abbottabad" 99.94749 1889509255938048 306.9364 2.782192e-08 2.60837e-09 .003782884 2.5814395 7.430996 0 2012 2 625 "Abbottabad" 98.93758 2397047644050773.5 302.53705 3.2616246e-08 1.864745e-09 .0044749156 4.400591 7.884643 8 2012 3 626 "Abbottabad" 95.1821 2177927226239658.8 308.4847 4.425051e-08 1.990966e-09 .006003992 1.572094 14.459875 0 2012 4 627 "Abbottabad" 93.47544 911579450529109.4 291.62167 2.0841245e-08 1.372158e-09 .009904053 3.2744465 19.239843 4 2012 5 628 "Abbottabad" 97.07664 1734575200578218.8 306.4253 1.621035e-08 1.2243e-09 .010428986 1.4341682 24.758507 0 2012 6 629 "Abbottabad" 96.54571 2787026379560277.5 295.0486 2.38403e-08 1.285829e-09 .00865004 .07942466 29.80407 4 2012 7 630 "Abbottabad" 109.2311 2283370239229952 285.53198 4.867892e-08 1.823594e-09 .015685901 .6128967 28.975204 0 2012 8 631 "Abbottabad" 104.59014 1527325446023850.8 275.8333 4.925287e-08 2.057103e-09 .01867117 3.344791 25.772505 0 2012 9 632 "Abbottabad" 95.23199 1161556926660608 275.3314 2.8072336e-08 1.838347e-09 .016001359 2.0617228 23.33639 4 2012 10 633 "Abbottabad" 89.11844 1520449695514624 281.3 1.9658003e-08 1.940535e-09 .008600234 .08928955 19.59357 0 2012 11 634 "Abbottabad" 85.95892 2242177342111744 279.37936 2.6016703e-08 2.058495e-09 .005726042 .5078251 15.448177 4 2012 12 635 "Abbottabad" 89.91596 1664319780902229.3 278.10165 2.604281e-08 2.19356e-09 .004485305 1.637229 11.776385 0 2013 1 636 "Abbottabad" 92.60094 1.94313e+15 300.21448 3.77138e-08 2.41391e-09 .003829347 .8444911 9.136307 0 2013 2 637 "Abbottabad" 95.06524 1.87938e+15 289.6492 2.98648e-08 2.24287e-09 .005880678 9.429545 10.063504 12 2013 3 638 "Abbottabad" 88.70963 1.43937e+15 284.9158 2.26445e-08 1.87814e-09 .008420701 3.2791874 16.08373 0 2013 4 639 "Abbottabad" 90.56194 1.4585e+15 294.69968 2.08604e-08 1.3909e-09 .010196055 .2418624 19.88057 4 2013 5 640 "Abbottabad" 91.076 1.72791e+15 293.57333 1.95936e-08 1.20822e-09 .01020622 .2325486 26.141603 0 2013 6 641 "Abbottabad" 97.87124 1.92451e+15 289.71448 3.34126e-08 1.65939e-09 .013099546 1.8082206 29.132254 4 2013 7 642 "Abbottabad" 104.43357 2.07596e+15 284.72083 5.39985e-08 1.76332e-09 .018933235 2.5392246 27.1648 0 2013 8 643 "Abbottabad" 104.71043 1.31618e+15 280.60556 4.14442e-08 2.08538e-09 .01901123 7.693342 24.822226 0 2013 9 644 "Abbottabad" 103.26907 1.25613e+15 276.5106 4.96716e-08 2.15839e-09 .015489435 1.5389085 23.32317 4 2013 10 645 "Abbottabad" 94.09236 1.15134e+15 270.19275 4.0029e-08 2.16936e-09 .01075663 .25782615 20.94896 0 2013 11 646 "Abbottabad" 85.94402 1.77838e+15 277.21594 1.95026e-08 2.06909e-09 .005402774 .5899205 15.385907 4 2013 12 647 "Abbottabad" 91.06864 2.34483e+15 297.14545 2.41227e-08 2.33124e-09 .003511088 .0769775 11.960663 0 2014 1 648 "Abbottabad" 92.46869 2054955467451050.8 310.7489 1.6139827e-08 2.345427e-09 .003238943 .2727376 10.632012 0 2014 2 649 "Abbottabad" 97.16617 1754077707545258.8 307.6921 2.887692e-08 2.180447e-09 .0045914087 2.722884 9.791932 12 2014 3 650 "Abbottabad" 93.75581 1855054491418624 326.4917 2.692161e-08 1.752437e-09 .006978645 4.4648805 13.333652 0 2014 4 651 "Abbottabad" . 1743582507565056 310.24445 1.5047817e-08 1.327211e-09 .009164255 2.2142391 19.142923 4 2014 5 652 "Abbottabad" 99.46532 1503870629620394.8 302.82083 2.1770195e-08 1.265936e-09 .011653435 1.2830895 24.037764 0 2014 6 653 "Abbottabad" 92.94113 2213488839622656 287.529 3.180394e-08 1.383175e-09 .011436623 .05029847 29.69454 4 2014 7 654 "Abbottabad" 102.6995 1397929713598464 283.70557 5.941536e-08 1.961298e-09 .017431311 3.521061 27.584726 0 2014 8 655 "Abbottabad" 98.96602 1949545740457301.3 282.04532 5.215981e-08 2.093902e-09 .017834723 3.6781175 25.869314 0 2014 9 656 "Abbottabad" 101.9624 1368955416827221.3 273.5508 3.627155e-08 2.135658e-09 .016256062 2.112559 23.24897 4 2014 10 657 "Abbottabad" 93.20239 1302389195101525.3 271.62668 3.01346e-08 2.107534e-09 .010277042 .3431065 19.87448 0 2014 11 658 "Abbottabad" 86.39405 1474946619757909.3 274.78946 2.0336204e-08 2.065525e-09 .00577689 2.577628 16.004822 4 2014 12 659 "Abbottabad" 100.4571 2725718047850496 284.00467 2.630644e-08 2.826692e-09 .003765313 .007012808 12.397847 0 2015 1 660 "Abbottabad" 110.44862 1.88569e+15 304.19046 2.88991e-08 2.74527e-09 .003752843 1.1088774 10.286826 0 2015 2 661 "Abbottabad" 102.31495 1.95594e+15 342.07895 3.45284e-08 2.60817e-09 .005854315 6.7552 11.92959 12 2015 3 662 "Abbottabad" 96.91565 1.50595e+15 325.2223 2.35899e-08 1.68313e-09 .008125777 7.248246 14.10447 0 2015 4 663 "Abbottabad" 98.60025 1.71341e+15 298.14102 2.62611e-08 1.83112e-09 .01170911 2.868866 20.08065 4 2015 5 664 "Abbottabad" 98.53368 2.24542e+15 304.79117 2.04929e-08 1.38215e-09 .0121814 .3097502 25.69384 0 2015 6 665 "Abbottabad" 99.15784 2.22084e+15 296.89566 2.8834e-08 1.51366e-09 .012748851 1.0664684 27.46773 4 2015 7 666 "Abbottabad" 105.12056 1.70915e+15 282.4818 5.15182e-08 1.87055e-09 .018386604 3.19802 26.451986 0 2015 8 667 "Abbottabad" 100.12718 2.13224e+15 284.6746 4.3554e-08 2.08866e-09 .018806176 3.296762 25.17417 0 2015 9 668 "Abbottabad" 99.12728 1.89107e+15 286.01968 2.19564e-08 1.93508e-09 .013187833 1.9230855 24.002747 4 2015 10 669 "Abbottabad" 94.87969 1.58046e+15 280.68695 2.97106e-08 2.17138e-09 .009761647 1.8585702 20.22321 0 2015 11 670 "Abbottabad" 98.77528 2.14874e+15 285.12875 2.57521e-08 2.78422e-09 .007192711 2.0486941 15.034578 4 2015 12 671 "Abbottabad" 95.64295 1.55972e+15 288.28842 2.41762e-08 3.00926e-09 .005407415 .23315525 12.061103 0 2016 1 672 "Abbottabad" 98.24339 2210406529499136 282.89386 2.556562e-08 2.868163e-09 .005088837 1.754321 10.5896 0 2016 2 673 "Abbottabad" 104.52613 1306773394817024 297.1778 2.3876334e-08 2.858757e-09 .00584867 .6881298 13.247365 8 2016 3 674 "Abbottabad" 96.07843 1264688822222848 295.6772 2.53855e-08 2.010953e-09 .008804991 7.828474 15.767677 0 2016 4 675 "Abbottabad" 88.66109 1860925398537557.3 304.78326 1.952907e-08 1.43839e-09 .01086606 1.339975 20.78674 4 2016 5 676 "Abbottabad" 97.48742 2542789216698368 295.9303 2.455278e-08 1.284265e-09 .012110964 .7759994 27.215055 0 2016 6 677 "Abbottabad" 103.19395 2888313787995477 281.1427 4.064063e-08 1.692827e-09 .01517543 .15507045 29.686985 4 2016 7 678 "Abbottabad" 104.06378 2154611190966954.5 284.63104 5.165793e-08 1.850948e-09 .01922356 6.383112 26.64068 0 2016 8 679 "Abbottabad" 106.416 2027915829750442.8 280.14197 2.9443203e-08 2.012731e-09 .01877158 4.123931 25.32282 0 2016 9 680 "Abbottabad" 100.7034 1414894140959402.8 272.50183 4.463418e-08 2.422531e-09 .015318148 1.0327499 24.67562 4 2016 10 681 "Abbottabad" 93.65022 1309992159630677.3 268.56186 3.70537e-08 2.38872e-09 .009215945 .05339586 22.025736 0 2016 11 682 "Abbottabad" 99.40435 2403099879320234.5 266.84387 4.685437e-08 2.629745e-09 .004405521 .05109868 17.85624 4 2016 12 683 "Abbottabad" 101.99583 2475374067843072 252.76666 3.3213052e-08 3.002554e-09 .0032341275 .017012155 15.69756 0 2017 1 684 "Abbottabad" 102.4318 4157700499133781.5 293.79343 3.585694e-08 2.566731e-09 .004848249 6.974658 7.63629 0 2017 2 685 "Abbottabad" 98.41375 1441745829101568 282.18542 1.9463204e-08 2.621182e-09 .006327221 3.402175 12.169314 12 2017 3 686 "Abbottabad" 93.08501 1439061810085888 302.89215 2.336944e-08 1.662089e-09 .008087777 2.315762 14.82795 0 2017 4 687 "Abbottabad" 89.1006 2024430866442922.8 288.35397 2.5836966e-08 1.355565e-09 .010432748 3.2298725 22.163013 4 2017 5 688 "Abbottabad" 103.14132 2361130980037973.5 295.85565 2.716631e-08 1.421383e-09 .011387262 .16236494 27.002256 0 2017 6 689 "Abbottabad" 101.18838 2368135982219264 290.245 4.697955e-08 1.640894e-09 .013500904 2.2224474 28.032614 4 2017 7 690 "Abbottabad" 105.70515 2129374947398997.3 280.61014 5.377744e-08 1.892596e-09 .018713687 4.608266 26.536583 0 2017 8 691 "Abbottabad" 103.5687 1800121591267328.3 279.1394 5.772475e-08 2.203404e-09 .01867041 3.619065 25.79536 0 2017 9 692 "Abbottabad" 100.0604 1701298957189119.8 274.29242 3.365526e-08 2.141319e-09 .013989558 1.8452687 24.2776 4 2017 10 693 "Abbottabad" 97.96345 1689317161653589.3 271.17618 4.908114e-08 2.425621e-09 .007531395 .003302701 22.55861 0 2017 11 694 "Abbottabad" 105.20314 2924821367925419 279.42407 5.456809e-08 3.086409e-09 .004778198 .4200529 15.976475 4 2017 12 695 "Abbottabad" 98.59682 2520086735399594.5 290.24075 1.9099634e-08 2.866294e-09 .004233103 .9042324 12.574588 0 2018 1 696 "Abbottabad" 102.44623 2289069884527957.5 300.37964 3.2426396e-08 3.246013e-09 .003835864 .2006465 11.183366 0 2018 2 697 "Abbottabad" 98.22069 1714132229991082.8 325.1955 2.5546996e-08 2.396801e-09 .005144543 3.0212786 12.350897 12 2018 3 698 "Abbottabad" 92.42289 1488037232683690.8 319.7807 2.5609847e-08 1.890565e-09 .007545669 2.568554 17.784193 0 2018 4 699 "Abbottabad" 92.15745 1499904674714965.3 299.4889 3.590518e-08 1.597453e-09 .009898277 5.158232 21.438934 4 2018 5 700 "Abbottabad" 97.09755 2012323219417770.8 306.6524 3.1213037e-08 1.435762e-09 .01097664 .6141531 24.774906 0 2018 6 701 "Abbottabad" 104.08241 2382565193285632 287.69833 5.407014e-08 1.792892e-09 .013062525 3.0385444 28.928503 4 2018 7 702 "Abbottabad" 98.80846 2098195229660501.3 286.105 6.0765224e-08 1.944652e-09 .019069323 6.738194 26.12833 0 2018 8 703 "Abbottabad" 98.09788 1949142818837845.5 281.31427 7.541456e-08 2.351727e-09 .019889766 4.4622 25.375484 0 2018 9 704 "Abbottabad" 103.21876 1979803113968981.3 277.86667 4.87032e-08 2.688709e-09 .015143073 3.641236 23.681053 4 2018 10 705 "Abbottabad" 94.08669 1465989823376042.8 288.41833 2.838665e-08 2.567406e-09 .008872074 .13970277 19.81153 0 2018 11 706 "Abbottabad" 91.10707 2827230405197824 271.4158 2.5963974e-08 2.663288e-09 .006371015 .4347376 15.54988 4 2018 12 707 "Abbottabad" 97.35249 2667389797094741.5 275.27963 2.8099016e-08 3.055254e-09 .0044211494 .8334113 11.265207 0 2019 1 708 "Abbottabad" 99.62814 1932714613669888 292.70877 3.232046e-08 2.62134e-09 .00467529 6.33387 6.984877 0 2019 2 709 "Abbottabad" 105.13398 1293067639674197.3 303.26666 2.7337714e-08 2.743786e-09 .005704947 4.620583 8.2302265 12 2019 3 710 "Abbottabad" 97.71956 645019530690560 305.7562 2.6603914e-08 1.975986e-09 .007962183 4.256084 13.214072 0 2019 4 711 "Abbottabad" 93.49516 1409965106746709.3 280.23956 2.732811e-08 1.79674e-09 .0119124 3.4632735 20.989145 4 end format %tm modate label var modate "(mean) modate" label var DNAME "Name of the district" label var comean "(mean) comean" label var no2mean "(mean) no2mean" label var o3mean "(mean) o3mean" label var pm25mean "(mean) pm25mean" label var so2mean "(mean) so2mean" label var hummean "(mean) hummean" label var precmean "(mean) precmean" label var tempmean "(mean) tempmean" label var TI_Count "(mean) TI_Count"
Let's take the variable comean as an example.
What I am trying to create is 1) a variable that contains the 3 month comean average for September-October- November of each year for each district(DNAME).
and 2) a variable that contains the annual comean average for each year for each district (DNAME).
I can't figure it out myself, any thoughts on this?
Comment