Reshape data keeping repeating variables

[Joan Marti]

Hi,

I have a dataset of the form:

Event	year
event1	2002
event2	2005
event3	2001

And I want to reshape it to:

year_event1	year_event2	year_event3
2002	2005	2001

I have tried multiple options using reshape but have not managed to achieve this so far. Any help would be super appreciated.

Many thanks!

[Øyvind Snilsberg]

* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 event float year
"event1" 2002
"event2" 2005
"event3" 2001
end

gen x=1
reshape wide year, i(x) j(event) s

[Joan Marti]

Thank you!