Good Day!
I am currently trying to reshape the Bruegel Dataset. Currently it is comprised of a year variable and several country variables as columns (see below):
Period Australia Austria ....... Vietnam
1996 XXX XXX XXX
1997 XXX XXX XXX
1998 XXX XXX XXX
1999 XXX XXX XXX
2000 XXX XXX XXX
*Note that XXX are actual values.
I am trying to reshape the data wherein countries would be a new variable (see below):
Period Country Exchange Rate
1996 Australia XXX
1996 Austria XXX
1996 Vietnam XXX
1997 Australia XXX
1997 Austria XXX
1997 Vietnam XXX
Since there would be two new variable, what would be the best command to perform this? Thank you!
Related Posts with Reshaping the Bruegel Dataset
replace with the last row in each goup Hi STATALIST, Could you please help me to replace meacstdivol_1 with last row within each study_1?…
Dummy variables in first difference regressionHi guys, I have a potentially very stupid question to ask, but for the life of me I can not figure …
Problem with variables names inside loopsHi all, I have a set of variables named "ratio_##########_co_###" (where # are numbers). My proble…
Fine and Gray calculate individual risksDear all, I would like to calculate the 10-year risk of stroke for each individual in my dataset, g…
line graphic of series from 1st occurrence Covid-19Hello! I am using the data set provided in this study, "Oxford COVID-19 govt response tracker' here …
Subscribe to:
Post Comments (Atom)
0 Response to Reshaping the Bruegel Dataset
Post a Comment