njau 发表于 2018-10-2 22:25
好的,谢谢,我再试试。
如同 David Benson 之建议,最简单之方法为在 excel 中重新命名 x1 x1_1995, x2 to x_1995, 同样地,x1_1996 x2_1996。然后:
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input str1 area float(x1_1995 x2_1995 x3_1995 x4_1995 x5_1995 x1_1996 x2_1996 x3_1996 x4_1996 x5_1996)
- "A" .064 .232 .344 .215 .144 .02 .09 .379 .323 .189
- "B" .072 .321 .356 .182 .069 .05 .23 .432 .22 .067
- "C" .094 .47 .339 .081 .015 .1 .337 .439 .107 .018
- "D" .083 .391 .381 .11 .035 .056 .299 .465 .135 .045
- "E" .123 .396 .334 .123 .024 .129 .306 .375 .149 .041
- "F" .073 .385 .391 .105 .045 .034 .261 .516 .14 .048
- "G" .071 .382 .346 .156 .044 .046 .285 .428 .197 .043
- "H" .083 .393 .36 .13 .035 .049 .259 .462 .179 .051
- "I" .07 .236 .37 .226 .097 .038 .121 .428 .284 .13
- "J" .113 .398 .342 .118 .029 .134 .302 .401 .128 .035
- end
- // David Benson
- reshape long x1_ x2_ x3_ x4_ x5_, i(area) j(year)
- rename *_ * // just renaming x1_ x1, x2_ x2
- sort year area
- by year: gen n= _n // just to make list work
- list if n<=5, noobs sepby(year)
复制代码