Problem with generating a variable from the temporal difference of another variable
Dear Forum,
I am looking for a solution to my problem; I am using Stata for Uni and am still very inexperienced in using the program. I am investigating certain factors influencing foreign aid's effectiveness for democratisation. For this, I am using the PolityV Democracy Index, which shows a 21-point scale from autocratic (-10 to -6) to democratic (6-10) for (almost) every country.
I have the variables PolityV, Year, and Country. For each country, the values of the PolityV index from different years exist. For example, I have data on Guatemala, which had a Polity value of -6 in 1970 and five years later in 1975, a score of 3. In all these years, Guatemala has received democracy aid, and I want to investigate whether the aid flows are related to the change in the values of the PolityV index.
To do this, I now try to capture this five-year temporal difference in a new variable called regime change. This new variable should be measured as a change in the country's PolityV score five years after receiving foreign aid. To determine the extent of regime change, I planned to subtract the country's PolityV score at the time of aid allocation from its PolityV score five years later.
My problem is that I do not know how to proceed here to generate the required variable. I apologise if my problem is insufficiently described. I am happy for any advice on commands or literature I can have a look at.
Many thanks for considering my request
Tilman
I am looking for a solution to my problem; I am using Stata for Uni and am still very inexperienced in using the program. I am investigating certain factors influencing foreign aid's effectiveness for democratisation. For this, I am using the PolityV Democracy Index, which shows a 21-point scale from autocratic (-10 to -6) to democratic (6-10) for (almost) every country.
I have the variables PolityV, Year, and Country. For each country, the values of the PolityV index from different years exist. For example, I have data on Guatemala, which had a Polity value of -6 in 1970 and five years later in 1975, a score of 3. In all these years, Guatemala has received democracy aid, and I want to investigate whether the aid flows are related to the change in the values of the PolityV index.
To do this, I now try to capture this five-year temporal difference in a new variable called regime change. This new variable should be measured as a change in the country's PolityV score five years after receiving foreign aid. To determine the extent of regime change, I planned to subtract the country's PolityV score at the time of aid allocation from its PolityV score five years later.
My problem is that I do not know how to proceed here to generate the required variable. I apologise if my problem is insufficiently described. I am happy for any advice on commands or literature I can have a look at.
Many thanks for considering my request
Tilman
Comment