Column A with all the countries listed in the photo below
Column B with one of 3 options (Advanced Economies, Emerging Market Economies, Low-Income Developing Countries) to match whichever category it is placed under in the photo below.
So ideally, we'd end up with something that looks like:
Country | Type |
Australia | Advanced Economies |
Austria | Advanced Economies |
Albania | Emerging Market Economies |
Afghanistan | Low-Income Developing Countries |
I can do this easily on excel by moving cells around, etc.
But how do I do this with purely Stata? I realize it's not a wide-to-long format reshaping matter.
Thank you in advance,
Array
0 Response to Rearranging columns and rows to make it country-level database
Post a Comment