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
Fusing multiple rows into a single columnHello, I am a beginner using Stata 15. I have a data in the long format which I will like to convert…
stacked bar chartHi, I have a dataset of sales that can be attributed to one of three buyer-organizations (1,2,3). T…
Comparison of the dataHello room, Am struggling to do variation comparison between variables. What is the best method to …
Treatment of missings in geodistI have encountered the following issue using geodist from SSC, by Robert Picard: When all coordinate…
Balancing treatment and control group with - weight -Hi I have a cross sectional study (individuals from 26 countries) in an RD-design. The treatment is…
Subscribe to:
Post Comments (Atom)
0 Response to creating a count variable for multiple entries per year
Post a Comment