Generating summary dataset based on dataset of list of events

[Alex Williamson]

Hi all,

I am an undergrad who is new to stata, so I desperately need help as I feel very out of depth!

I am using the Global Terrorism Database, which is formatted as a list of individual events (e.g., 1 Mar 1970, Afghanistan, 8 casualties, IED, etc.). The link to the site is attached (it is the 1970-2019 file).
I was attempting to compile a different dataset where my three variables are,

1. terr_dom - individual events of domestic terrorism by year by country (in GTD these events are int_any==0)
2. terr_int - individual events of transnational terrorism by year by country (int_any==1)
3. terr - individual events of terrorism by year by country (N.B. terr != terr_dom + terr_int as there are many events which are uncertain but still valuable in analysis).

Potentially also I would like to have the casualties per country per year for each of these variables, though this is something I believe I could work out myself after a nudge in the right direction in this thread.

I look forward to hearing your help! I am able to answer any questions directed my way. Thank you!

[Alex Williamson]

I have managed to find a solution from a previous thread I found on the forum. Thanks to Clyde Schechter!