transforming a long dataset into a wide format

[dmunte]

hi guys,


my problem is similar to the one outline here except for the fact that my only variable is GDP
basically, my dataset looks like:

region year log_gdp
region1 2000 4.23
region1 2001 4.29
region1 2002 4.27
region2 2000 4.19
region2 2001 4.22
region2 2002 4.24
....

and i would like to make it like this:

region/year 2000 2001 2002
region1 4.23 4.29 4.27
region2 4.19 4.22 4.24

unfortunately my programming skills are not so advanced and didn't manage to modify the code available in the other thread.

i would greatly appreciate any help with this problem, as copying and pasting the data is very time consuming.


thanks,
dan

[ragulduy]

Please Login or Register  to view this content.