请教：如何根据两组增长率，对两组value值加总。

945

收藏 2016-10-31

如下表，想要根据rate1和rate2的大小，同时对value1和value2 加总。我试着写了下，好些不太对。
请指教。

gen A1=sum(value1) if (rate1>0 & rate2>0 & rate1>rate2)
gen B1=sum(value1) if rate1>0 & (rate2>0 & rate1<rate2)
gen D1=sum(value1) if (rate1<0 & rate2>0)
gen C1=sum(value1) if (rate1>0 & rate2<0)
gen E1=sum(value1) if (rate1<0 & rate2<0)

gen A2=sum(value2) if (rate1>0 & rate2>0 & rate1>rate2)
gen B2=sum(value2) if rate1>0 & (rate2>0 & rate1<rate2)
gen D2=sum(value2) if (rate1<0 & rate2>0)
gen C2=sum(value2) if (rate1>0 & rate2<0)
gen E2=sum(value2) if (rate1<0 & rate2<0)

value1	value2	rate1	rate2
4700000	2.8E+08	0.014364	-0.00573
2.7E+09	1.3E+10	0.046655	-0.0071
6000000	23000000	0.003564	6.05E-05
3.8E+08	1.8E+09	0.03108	-0.01743
35000000	2.9E+08	0.006228	-0.00286
446998	2500000	0.000199	0.000373
5000000	11000000	-4.1E-05	-0.00011
9700000	77000000	0.008404	0.009359
82000000	1.1E+08	-0.00141	0.068161
3500000	20000000	0.002692	0.0434
2.5E+08	75000000	-0.01289	0.114531
8600000	13000000	-0.00028	0.125795
231189	3.5E+08	0.009147	-0.00451
6100000	3.5E+08	0.017183	-0.04417
200	4200000	0.000533	-2.1E-05
2.7E+08	5E+09	0.15082	-0.11755
975712	8300000	0.000938	-0.01301
944684	381450	-0.00043	-0.01871
3400000	39000000	0.023785	-0.00984
47000000	1.7E+08	0.000516	0.007003
17000000	91000000	0.000688	0.038835
21000000	19000000	-0.00168	0.144289
3.7E+08	8.1E+08	-0.00334	0.039342
1.1E+09	2.1E+09	-0.02526	0.036487
2.1E+09	7.7E+09	0.088155	0.019384
1E+08	1.3E+08	-0.00999	0.055926
1.4E+09	6.2E+09	0.031837	0.011009
1.4E+08	2.8E+08	-0.00553	0.003861