N个国家08-18年的消费数据,dataex导出代码如下:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str4 A str6 B str11 C
"YEAR" "AFRICA" "EAST AFRICA"
"2008" "323921" "72955"
"2009" "340443" "77544"
"2010" "391475" "96882"
"2011" "424482" "111792"
"2012" "439619" "120435"
"2013" "461450" "131299"
"2014" "497003" "150577"
"2015" "487455" "158893"
"2016" "502324" "172879"
end
[/CODE]
希望可以变成 STATA面板数据那种格式,如:
country year var1
Africa 2008 32921
Africa 2009 340443
Africa 2010 391475
Africa……
……
East Africa 2008 72955
East Africa 2009 77544
……
请问该怎么实现呢?我reshape, xpose 好像都不太对, 我是不是缺了什么步骤呢。谢谢热心人