clear
capture log close

version 8.0
log using make_yrly_exonerations_1973_2006.log, replace
#delimit ;
set more off ;

* ***********************************************************************;
*   File-Name:      make_yrly_exonerations_1973_2006.do                 *;
*   Date:           September 6, 2006                                   *;
*   Author:         AEB                                                 *;
*   Purpose:        Aggregate exoneration data to yrly level and        *;
*                   create Stata dataset                                *;
*   In-put file:    exonerations_1973_2006.csv                          *;
*   Output File:    make_yrly_exonerations_1973_2006.log                *;
*   Data Output:    yrly_exonerations_1973_2006.dta                     *;
*   Previous File:  None                                                *;
*   Machine:        Pond 228                                            *;
* ***********************************************************************;

set mem 700m;

*use s:\lobby\agendas_project\death_penalty\book\data\exonerations\make_yrly_death_row_1953_2006.do*;
insheet using exonerations_1973_2006.csv;

rename v1 exoneree;
rename v2 name;
rename v3 year;
rename v4 quarter;

********************************;
**Year as Unit of Analysis***;
********************************;
gen exonerations=1;
sort year;

***Now aggregate the variables by qtr and save the datafile - includes individual vars***;
collapse (sum)  exonerations, by(year);
sort year;

label var exonerations
    "Number of exonerations per year";
sort year;
tset year;



save yrly_exonerations_1973_2006.dta, replace;