clear capture log close set mem 80m set more off #delimit ; log using Espy_collapse_year.log, replace; ****************************************************************************************************************; * Created by: AEB ; * Creation Date: 04/27/07 ; * Directory: J:\Lobby\Agendas_Project\Death_Penalty\book\website\data_log_and_do_files ; * Do-file-name: Espy_collapse_year.do ; * Purpose: collapse executions by year ; * Data Input: Espy_executions_data.dta ; * Log File: Espy_collapse_year.log ; * Data Output: Espy_collapse_year.dta ; * NOTES: ; ****************************************************************************************************************; *Start with raw Espy data file, including all executions since 1608; use Espy_executions_data.dta; collapse (sum) white black native asian hispanic raceoth racedk total_by_year, by(year); save Espy_collapse_year.dta, replace;