计算这个加总的因变量不能直接加总到三天后删除多余值,而是在在每一条数据上都加上上一期和下一期的因变量值,想到了两个代码,但算出来貌似都不太对
部分数据如下:
- [/size]
- [size=14px]* Example generated by -dataex-. To install: ssc install dataex[/size]
- [size=14px]clear[/size]
- [size=14px]input float city_pair long dataDate float rate[/size]
- [size=14px]200 20190103 .001170275[/size]
- [size=14px]200 20190111 .001170275[/size]
- [size=14px]200 20190124 .001170275[/size]
- [size=14px]200 20190127 .001170275[/size]
- [size=14px]200 20190207 .001170275[/size]
- [size=14px]200 20190211 .001170275[/size]
- [size=14px]200 20190221 .001170275[/size]
- [size=14px]200 20190225 .001170275[/size]
- [size=14px]200 20190321 .001170275[/size]
- [size=14px]200 20190324 .001170275[/size]
- [size=14px]200 20190329 .0005851375[/size]
- [size=14px]200 20190403 .001170275[/size]
- [size=14px]200 20190408 .001170275[/size]
- [size=14px]200 20190413 .001170275[/size]
- [size=14px]200 20190425 .001170275[/size]
- [size=14px]200 20190430 .001170275[/size]
- [size=14px]200 20190521 .0046811[/size]
- [size=14px]200 20190522 .001170275[/size]
- [size=14px]200 20190529 .001170275[/size]
- [size=14px]200 20190601 .001170275[/size]
- [size=14px]200 20190607 .001170275[/size]
- [size=14px]200 20190620 .0005851375[/size]
- [size=14px]200 20190621 .001170275[/size]
- [size=14px]200 20190714 .0029256875[/size]
- [size=14px]200 20190726 .0017554126[/size]
- [size=14px]200 20190727 .001170275[/size]
- [size=14px]200 20190802 .001170275[/size]
- [size=14px]200 20190803 .001170275[/size]
- [size=14px]200 20190804 .001170275[/size]
- [size=14px]200 20190808 .0005851375[/size]
- [size=14px]200 20190810 .0029256875[/size]
- [size=14px]200 20190812 .003510825[/size]
- [size=14px]200 20190814 .0005851375[/size]
- [size=14px]200 20190818 .0017554126[/size]
- [size=14px]200 20190819 .001170275[/size]
- [size=14px]200 20190821 .001170275[/size]
- [size=14px]200 20190827 .001170275[/size]
- [size=14px]200 20190831 .0005851375[/size]
- [size=14px]200 20190901 .0017554126[/size]
- [size=14px]200 20190902 .001170275[/size]
- [size=14px]200 20190903 .001170275[/size]
- [size=14px]200 20190905 .001170275[/size]
- [size=14px]200 20190906 .0017554126[/size]
- [size=14px]200 20190907 .00234055[/size]
- [size=14px]200 20190909 .001170275[/size]
- [size=14px]200 20190910 .001170275[/size]
- [size=14px]200 20190913 .0005851375[/size]
- [size=14px]200 20190914 .00234055[/size]
- [size=14px]200 20190916 .001170275[/size]
- [size=14px]200 20190918 .001170275[/size]
- [size=14px]200 20190920 .001170275[/size]
- [size=14px]200 20190922 .001170275[/size]
- [size=14px]200 20190923 .001170275[/size]
- [size=14px]200 20190925 .001170275[/size]
- [size=14px]200 20190927 .001170275[/size]
- [size=14px]200 20191003 .001170275[/size]
- [size=14px]200 20191005 .001170275[/size]
- [size=14px]200 20191006 .001170275[/size]
- [size=14px]200 20191008 .0005851375[/size]
- [size=14px]200 20191009 .001170275[/size]
- [size=14px]200 20191011 .001170275[/size]
- [size=14px]200 20191012 .001170275[/size]
- [size=14px]200 20191016 .0005851375[/size]
- [size=14px]200 20191018 .001170275[/size]
- [size=14px]200 20191020 .001170275[/size]
- [size=14px]200 20191021 .001170275[/size]
- [size=14px]200 20191029 .001170275[/size]
- [size=14px]200 20191031 .001170275[/size]
- [size=14px]200 20191102 .00234055[/size]
- [size=14px]200 20191103 .00234055[/size]
- [size=14px]200 20191105 .001170275[/size]
- [size=14px]200 20191106 .0005851375[/size]
- [size=14px]200 20191107 .001170275[/size]
- [size=14px]200 20191108 .001170275[/size]
- [size=14px]200 20191109 .00234055[/size]
- [size=14px]200 20191110 .00234055[/size]
- [size=14px]200 20191111 .00234055[/size]
- [size=14px]200 20191113 .00234055[/size]
- [size=14px]200 20191115 .001170275[/size]
- [size=14px]200 20191118 .0005851375[/size]
- [size=14px]200 20191119 .001170275[/size]
- [size=14px]200 20191121 .0005851375[/size]
- [size=14px]200 20191128 .0005851375[/size]
- [size=14px]200 20191204 .001170275[/size]
- [size=14px]200 20191205 .0017554126[/size]
- [size=14px]200 20191206 .0005851375[/size]
- [size=14px]200 20191210 .0005851375[/size]
- [size=14px]200 20191212 .0005851375[/size]
- [size=14px]200 20191215 .0017554126[/size]
- [size=14px]200 20191220 .001170275[/size]
- [size=14px]200 20191226 .0017554126[/size]
- [size=14px]200 20191228 .001170275[/size]
- [size=14px]200 20191230 .001170275[/size]
- [size=14px]end[/size]
- [size=14px]
[code]
sort city_pair date
drop group*
gen group3_1=sum(rate[_n] + rate[_n+1] + rate[_n-1] )
gen group3_2=sum(rate[_n] + l.rate + f.rate)
sum group3*
list city_pair date rate group* if city_pair==200
[\code]