Hello,
I need help in wrangling some data on Stata. Can someone share the code for the below operation?
1. I would like to have the years in a single column (long data) , starting with 1990 for all observations, then 1991, then 1992, etc.
2. I would like for "Country" to remain in a column but arranged in alphabetical order ( Inida, Italie , Japon, Korea, UK, USA)
3 Finally, I would like each category to be in a separate column.
The file I need help for is attached (DATAEXAMPLE1), and I have also attached a picture of the format I hope to get (Objective).
Thank you
I need help in wrangling some data on Stata. Can someone share the code for the below operation?
1. I would like to have the years in a single column (long data) , starting with 1990 for all observations, then 1991, then 1992, etc.
2. I would like for "Country" to remain in a column but arranged in alphabetical order ( Inida, Italie , Japon, Korea, UK, USA)
3 Finally, I would like each category to be in a separate column.
The file I need help for is attached (DATAEXAMPLE1), and I have also attached a picture of the format I hope to get (Objective).
Thank you
Comment