Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Reshaping


From   "Pavlos C. Symeou" <p.symeou@jbs.cam.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   st: Reshaping
Date   Tue, 11 Nov 2008 11:34:02 +0200

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index