/* This Do-file creates a country-year data set using the Uppsala Armed Conflict Data Project's "List of System Members Since 1946" from their codebook: http://www.pcr.uu.se/digitalAssets/124/124920_1codebook_ucdp_prio-armed-conflict-dataset-v4_2015.pdf From the codebook, I carefully created the file "ACD_SystemMembers_v2015.csv" */ version 14.1 clear all set more off import delimited "ACD_SystemMembers_v2015.csv", encoding(UTF-8) * Label variables: label var statenum "ACD State Number" label var stateab "ACD State Abbreviation" label var statename "ACD State Name" label var startyear "ACD Membership Start Year" label var endyear "ACD Membership End Year" * Quickly make an overall mat structure of country-years: expand 2012-1946+1 sort statenum egen year = seq(), from(1946) to(2012) * Drop observations that are outside the member's start and end years: drop if year < startyear drop if year > endyear