Hello,
I have one dataset (called Natural Disaster) with three variables: Year, CountryCode, and TotalAffected. Since countries can have more than one natural disaster every year, there are often multiple entries with the same Year and CountryCode
I have one dataset (called Population) with many variables: one named CountryCode, and the rest corresponding to years (from 1980-2018). So each row of this dataset contains the country's code, and that country's population over the period 1980-2018.
I want to create a new variable, PercentageAffected, in the Natural Disaster dataset. This is equal to (TotalAffected/Population in that year and in that country).
To do that I would have to create a Population variable in the Natural Disaster dataset.
I'm not sure how to transfer the population data from my Population dataset into the Natural Disaster dataset, such that the new Population variable in the Natural Disaster dataset contains the value of the population corresponding to the correct CountryCode and Year.
I would appreciate help with this, and please let me know if this question was unclear. Thanks!