- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input str24 province int year long road double rail
- "北京市" 1999 12825 1141.1
- "北京市" 2000 13597 1140.9
- "北京市" 2001 13891 1160.6
- "北京市" 2002 14359 1138.1
- "北京市" 2003 14453 1136.1
- "北京市" 2004 14630 1124.6
- "北京市" 2005 14696 1125.4
- "北京市" 2006 20503 1121.5
- "北京市" 2007 20754 1119.9
- "北京市" 2008 20340 1166.5
- "北京市" 2009 20755 1169.459
- "北京市" 2010 21114 1169.4
- "北京市" 2011 21347 1228.4
- "北京市" 2012 21492 1276.3
- "北京市" 2013 21673 1276.7
- "北京市" 2014 21849 1284.753
- "北京市" 2015 21885 1284.753
- "天津市" 1999 8844 529.6
- "天津市" 2000 8946 531.2
- "天津市" 2001 9647 697.2
- "天津市" 2002 9696 681.6
- "天津市" 2003 10168 666.3
- "天津市" 2004 10514 661.6
- "天津市" 2005 10836 664.6
- "天津市" 2006 11316 744.7
- "天津市" 2007 11531 694.2
- "天津市" 2008 12060 764.3
- "天津市" 2009 14316 781.49
- "天津市" 2010 14832 781.5
- "天津市" 2011 15163 866.9
- "天津市" 2012 15391 867.7
- "天津市" 2013 15718 963.4
- "天津市" 2014 16110 970.927
- "天津市" 2015 16550 1043.743
- "河北省" 1999 58162 3619.4
- "河北省" 2000 59152 3631.9
- "河北省" 2001 62615 4570.9
- "河北省" 2002 63079 4585.7
- "河北省" 2003 65391 4744
- "河北省" 2004 70200 4671.5
- "河北省" 2005 75894 4652
- "河北省" 2006 143778 4818.2
- "河北省" 2007 147265 4837.8
- "河北省" 2008 149503 4853.5
- "河北省" 2009 152135 4880.286
- "河北省" 2010 154344 4916.4
- "河北省" 2011 156965 5170.5
- "河北省" 2012 163045 5630.3
- "河北省" 2013 174492 6255.5
- "河北省" 2014 179200 6252.766
- "河北省" 2015 184553 6958.106
- end
复制代码
谢谢黄老师的解答,数据如上所示,如何生成新的观测值,province为京津冀地区,其每个年份的road和rail等于北京、天津和河北各年份road和rail的和?