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!
Related Posts with Combining two datasets on two variables.
Multiple Regression with large numbers of variablesI'm attempting to perform multiple regression on large amounts of molecular data to model the associ…
F-Test valuesHello, I'm performing some quite simple linear regression analyses (with the command reg followed by…
Descriptive statistics after regression: multiple observations per idDear Statalist users, I am running a conditional risk set model (survival analysis), which entails …
Missing standard errors because of stratum with single sampling unit.How do I fix the problem of missing standard errors because of stratum with single sampling unit whe…
Forum like stataliest for new R usersHello stata community, I have been a long time stata user but need to get myself familiar with R fo…
Subscribe to:
Post Comments (Atom)
0 Response to Combining two datasets on two variables.
Post a Comment