I have panel data of more than 100 countries and 30 years. I want to assign these countries to low, lower-middle, upper-middle and high-income countries. When I download the world bank classification from the world bank website, all I get is the classified group for each country for a single year, but I want to assign the income status of each country for all the years. For example, a country is in a lower-middle-income country for the year 2020, but I want to assign this lower-middle-income status to that country for all the 30 years (i.e. from 1990-2020, that country will be assigned lower-middle-income status). Similarly, I want to do that for all the countries in my dataset. It would take a huge amount of time in excel. Is there any command in Stata which can allow me to do that?
NB: If anyone is wondering whether it would be appropriate to assign lower-middle-income status to a country which was low-income in 1995, please ignore it. Instead of income classifications, it could be regional classifications which I wanted to assign.
Related Posts with Assigning classifications/status of a country for all years in panel data
Combine two strings with entry that has more informationDear statalists, I have two variables that capture the same thing but with differing precision. One…
Using Weights for countries in Survey DatasetHello everyone, I am working with 2 waves (5 and 6) of World Value Survey in Stata 15 and I am anal…
Foreach and gen ? Help please(Don't speak english, Hope you can understand) Hi, I was wondering if is possible making a loop to f…
collapse or Roger Newman's xcollapse with string variablesTried help (and the help for xcollapse) but can't get an answer that makes sense to me. I have three…
Using foreach for two set of groupsDear All, I have two groups of countries and pairwise data- importers and exporters. Eg. Importers=…
Subscribe to:
Post Comments (Atom)
0 Response to Assigning classifications/status of a country for all years in panel data
Post a Comment