Dear Statalisters,
I have panel data in the following format (actually yearly data extend
up to year_2007):
Country measure year_1990 year_1991 year_1992 year_1993
year_1994 year_1995
Argentina gdp_constant 182,63 201,81 222,59 236,51 250,31 243,19
Argentina gdp_deflator 37,74 89,64 101,82 100 102,85 106,11
Argentina gdp_percap_const 5614,3 6120,91 6660,41 6972,96
7286,34 6992,31
Argentina gdp_percap_current 4344,82 5750,51 6845,48 6972,96
7493,95 7419,16
Argentina gdp_ppp 182,37 208,56 235,33 255,81 276,5 274,13
Argentina gdp_ppp_percap 5606,06 6325,71 7041,58 7542,26 8048,73
7881,97
Argentina ppp_conversion_rate 0,38 0,87 0,96 0,93 0,93 0,94
Argentina cpi 23,21 63,05 78,75 93,33 97,23 100,52
Argentina population 32,53 32,97 33,42 33,92 34,35 34,78
Australia gdp_constant 581,27 574,22 586,19 608,95 640,25 663,04
Australia gdp_deflator 70 71,54 72,71 73,6 74,16 75,49
Australia gdp_percap_const 34011,52 33167,52 33462,01 34411,12
35799,96 36624,29
Australia gdp_percap_current 18601,81 18486,94 17889,14 17225,66
19424,37 20499,27
Australia gdp_ppp 299,35 306,06 319,63 339,71 364,76 385,47
Australia gdp_ppp_percap 17515,56 17678,38 18245,57 19196,38
20395,62 21292,13
Australia ppp_conversion_rate 1,36 1,34 1,33 1,32 1,3 1,3
Australia cpi 80,35 82,94 83,76 85,28 86,9 90,93
Australia population 17,09 17,31 17,52 17,7 17,88 18,1
I need to reshape them in the following format:
Country year gdp_constant gdp_deflator gdp_percap_const
gdp_percap_current gdp_ppp gdp_ppp_percap ppp_conversion_rate
cpi population
Argentina 1990
Argentina 1991
Argentina 1992
Argentina 1993
Argentina 1994
Argentina 1995
Australia 1990
Australia 1991
Australia 1992
Australia 1993
Australia 1994
Australia 1995
Can you please help?
Best regards,
Pavlos
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
