如何重塑一个特定的数据集从长到宽没有J变量Stata?

Question

我的数据集如下所示:

tbody> <<tr>

标识号	年份	指标	数据
1112000	2000	JKL_ADS	511
1112001	2001	JKL_ADS	517
1112002	2002	JKL_ADS	721
1112003	2003	JKL_ADS	925
1112004	2004	JKL_ADS	1092
1112000	2000	KLS_DSAK	351
1112001	2001	KLS_DSAK	631
1112002	2002	KLS_DSAK	732
1112003	2003	KLS_DSAK	823
1112004	2004	KLS_DSAK	1092

这是一个相当标准的应用程序。您没有按照推荐的形式给出示例数据，因此这里的细节可能需要您修改。

与问题相反，indicator作为j()的论据。

* Example generated by -dataex-. For more info, type help dataex
clear
input long identificationnumber int year str8 indicator int data
1112000 2000 "JKL_ADS"   511
1112001 2001 "JKL_ADS"   517
1112002 2002 "JKL_ADS"   721
1112003 2003 "JKL_ADS"   925
1112004 2004 "JKL_ADS"  1092
1112000 2000 "KLS_DSAK"  351
1112001 2001 "KLS_DSAK"  631
1112002 2002 "KLS_DSAK"  732
1112003 2003 "KLS_DSAK"  823
1112004 2004 "KLS_DSAK" 1092
end
. reshape wide data , i(id year) j(indicator) string
(j = JKL_ADS KLS_DSAK)
Data                               Long   ->   Wide
-----------------------------------------------------------------------------
Number of observations               10   ->   5           
Number of variables                   4   ->   4           
j variable (2 values)         indicator   ->   (dropped)
xij variables:
data   ->   dataJKL_ADS dataKLS_DSAK
-----------------------------------------------------------------------------
. rename (data*) (*)
. l
+--------------------------------------+
| identi~r   year   JKL_ADS   KLS_DSAK |
|--------------------------------------|
1. |  1112000   2000       511        351 |
2. |  1112001   2001       517        631 |
3. |  1112002   2002       721        732 |
4. |  1112003   2003       925        823 |
5. |  1112004   2004      1092       1092 |
+--------------------------------------+