---------------------------------------------------------------------------------
       log:  J:\lobby\agendas_project\death_penalty\book\data\exonerations\make_y
> rly_exonerations_1973_2006.log
  log type:  text
 opened on:  13 Aug 2007, 13:35:24

. #delimit ;
delimiter now ;
. 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;
(716800k)

. *use s:\lobby\agendas_project\death_penalty\book\data\exonerations\make_yrly_de
> ath_row_1953_2006.do*;
. insheet using exonerations_1973_2006.csv;
(4 vars, 123 obs)

. 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 individu
> al vars***;
. collapse (sum)  exonerations, by(year);

. sort year;

. label var exonerations
>     "Number of exonerations per year";

. sort year;

. tset year;
        time variable:  year, 1973 to 2006, but with a gap

. save yrly_exonerations_1973_2006.dta, replace;
file yrly_exonerations_1973_2006.dta saved

. 
end of do-file

. clear

. log close
       log:  J:\lobby\agendas_project\death_penalty\book\data\exonerations\make_y
> rly_exonerations_1973_2006.log
  log type:  text
 closed on:  13 Aug 2007, 13:37:37
---------------------------------------------------------------------------------