I have a pannel dataset that is organized by country, code, year, and Disaster type.
the disaster variable has 5 kinds of observations "Bio, Hydro, Climat, geo, & Meteo." For example:
Country Code Year Disaster type
Algeria DZA 1980 Geophysical
Algeria DZA 1981 Hydrological
Algeria DZA 1981 Hydrological
Algeria DZA 1981 Biological
I want to create 2 variables one that sums up the biological events for each year and another that sums up the 4 remaining categories, without having to duplicate the year. For example:
Country Code Year occurrence_h occurance_w
Algeria DZA 1980 0 1
Algeria DZA 1981 1 2
I tried creating dummy variables for each disaster type however I couldn't do anything after that. I would be grateful for any ideas on how I can sort out this problem.
Thanks in advance
Related Posts with creating a count variable for multiple entries per year
Appending to a matrix in a loopHi, I am looping over several independent variables, and I am trying to end up with a matrix that c…
Power for a household-randomised RCT with variable cluster sizesHi, I want to power a household-randomised, two-arm, post-exposure prophylaxis (PEP) trial where th…
New -omega- commandHappy Monday to all. There is a new module, -omega-, now available on the SSC, that calculates the ω…
Measuring the strength of instruments using WeakivtestI'm interesting in estimating Montiel-Pflueger-style 'effective' F stats for a series of panel model…
Splitting a string variable into observations (instead of variables)Hi everyone I have two datasets. The master data include, among others, a list of (numeric) zip cod…
Subscribe to:
Post Comments (Atom)
0 Response to creating a count variable for multiple entries per year
Post a Comment