clear
capture log close

*log using P:\lobby\agendas_project\death_penalty\book\data\NYT\abstract_level_1960_2005.log, replace
log using abstract_level_1960_2005.log, replace

set more off

***************************************************************************************************************;
*  Created By:      AEB                                                                                       *;
*  Creation Date:   8/20/05                                                                                   *;
*  Modified:        3/10/07                                                                                   *;
*  Do-file-name:    abstract_level_1960_2005.do                                                               *;
*  Purpose:         Running raw frequencies of independent variables and aggregated variable groups from data *;
*                   collected Fall of 2002-Spring of 2003 by CHF and AEB from coding abstracts of every New   *;
*                   York Times article listed under "capital punishment" in the NYT Index Jan 1960 - Aug 2003,*;
*                   updated by AEB through Sept 2004 (in Summer, 2004) then through Dec 2005 (in Spring, 2007)*;               *;
*  In-put file:     P:\lobby\agendas_project\death_penalty\book\data\NYT\Death_Penalty_1960_2005.dta          *;
*  Out-putfile:     P:\lobby\agendas_project\death_penalty\book\data\NYT\abstract_level_DP_1960_2004.dta      *;
***************************************************************************************************************;

set mem 700m

*use P:\lobby\agendas_project\death_penalty\book\data\NYT\Death_Penalty_1960_2005.dta
insheet using Death_Penalty_1960_2005.csv

gen year=nytindexyear

*** LIST OF INDIVIDUAL VARIABLES
* nytindexyear
* front_page
* d3_tone
* d4_story_type
* d10_vicofficer
* d11_vicchild
* d12_vicmult
* d13_vicfam
* d14_female
* d19_viccharother
* d20_defterr
* d21_defmin
* d22_defmenthand
* d23_deffem
* d24_defparent
* d25_defjuv
* d27_defhuman
* d29_defcharother
* d30_mode
* d31_typecrime
* d32_violence_
* d40_leg_initiative
* d100_efficacy
* d101_deterrence
* d102_incapacitation
* d103_altsflawed
* d109_otherpro
* d110_notdeterrent
* d111_altsystems
* d119_otheranti
* d200_moral
* d201_retribution
* d202_famvengeance
* d203_crimedeserves
* d209_otherpro
* d210_killingvenbad
* d211_famopposed
* d219_otheranti
* d300_fairness
* d301_arefair
* d302_abbreviate
* d303_flawsoverstated
* d304_noblanket
* d309_otherpro
* d310_inadequaterep
* d311_arbitrary
* d312a_racist
* d312b_classist
* d312c_otherdemo
* d313a_vulnerablepop
* d313b_mitigating
* d314_mandatorysent
* d315_noaltpunish
* d316_evidence
* d317_innocence
* d318_broken
* d319_otheranti
* d400_constpopcontrol
* d401_notcruel
* d402_processupheld
* d403_popsupportup
* d404_statesrightspro
* d405_fedjurispro
* d409_otherpro
* d410_cruelunusual
* d411_viodueprocess
* d412_popsupportdown
* d413_statesrightsanti
* d414_fedjurisanti
* d419_otheranti
* d500_cost
* d501_worthit
* d502_prisonexp
* d509_otherpro
* d510_notworthit
* d511_prisoncheaper
* d519_otheranti
* d600_mode
* d601_modejust
* d609_otherpro
* d610_modequestioned
* d619_otheranti
* d700_international
* d709_internationalpro
* d710_intcomplaints
* d711_extraditionprobs
* d712_foreignnatls
* d719_other_anti
* d900_other_dimension


**************VICTIM CHARACTERISTICS
gen victim_char = 0
replace victim_char = 1 if d10_vicofficer == 1
replace victim_char = 1 if d11_vicchild == 1
replace victim_char = 1 if d12_vicmult == 1
replace victim_char = 1 if d13_vicfam == 1
replace victim_char = 1 if d14_female == 1
replace victim_char = 1 if d19_viccharother == 1
tab nytindexyear victim_char

**************DEFENDANT CHARACTERISTICS
gen defendant_char = 0
replace defendant_char = 1 if d21_defmin == 1
replace defendant_char = 1 if d22_defmenthand == 1
replace defendant_char = 1 if d23_deffem == 1
replace defendant_char = 1 if d24_defparent == 1
replace defendant_char = 1 if d25_defjuv == 1
replace defendant_char = 1 if d27_defhuman == 1
replace defendant_char = 1 if d29_defcharother == 1
tab nytindexyear defendant_char

**************VICTIM NO DEFENDANT
gen vic_no_def = 0
replace vic_no_def = 1 if victim_char==1 & defendant_char==0

**************DEFENDANT NO VICTIM
gen def_no_vic = 0
replace def_no_vic = 1 if defendant_char==1 & victim_char==0

*************NEITHER VICTIM NOR DEFENDANT CHARACTERISTICS
gen neither_vic_nor_def = 0
replace neither_vic_nor_def = 1 if victim_char==0 & defendant_char==0

**************EFFICACY
gen efficacy = 0
replace efficacy = 1 if d100_efficacy == 1
replace efficacy = 1 if d101_deterrence == 1
replace efficacy = 1 if d102_incapacitation == 1
replace efficacy = 1 if d103_altsflawed == 1
replace efficacy = 1 if d109_otherpro == 1
replace efficacy = 1 if d110_notdeterrent == 1
replace efficacy = 1 if d111_altsystems == 1
replace efficacy = 1 if d119_otheranti == 1
tab nytindexyear efficacy

gen pro_efficacy = 0
replace pro_efficacy = 1 if d101_deterrence == 1
replace pro_efficacy = 1 if d102_incapacitation == 1
replace pro_efficacy = 1 if d103_altsflawed == 1
replace pro_efficacy = 1 if d109_otherpro == 1
tab nytindexyear pro_efficacy

gen anti_efficacy = 0
replace anti_efficacy = 1 if d110_notdeterrent == 1
replace anti_efficacy = 1 if d111_altsystems == 1
replace anti_efficacy = 1 if d119_otheranti == 1
tab nytindexyear anti_efficacy

**************MORAL
gen moral = 0
replace moral = 1 if d200_moral == 1
replace moral = 1 if d201_retribution == 1
replace moral = 1 if d202_famvengeance == 1
replace moral = 1 if d203_crimedeserves == 1
replace moral = 1 if d209_otherpro == 1
replace moral = 1 if d210_killingvenbad == 1
replace moral = 1 if d211_famopposed == 1
replace moral = 1 if d219_otheranti == 1
tab nytindexyear moral

gen pro_moral = 0
replace pro_moral = 1 if d201_retribution == 1
replace pro_moral = 1 if d202_famvengeance == 1
replace pro_moral = 1 if d203_crimedeserves == 1
replace pro_moral = 1 if d209_otherpro == 1
tab nytindexyear pro_moral

gen anti_moral = 0
replace anti_moral = 1 if d210_killingvenbad == 1
replace anti_moral = 1 if d211_famopposed == 1
replace anti_moral = 1 if d219_otheranti == 1
tab nytindexyear anti_moral

**************FAIRNESS
gen fairness = 0
replace fairness = 1 if d300_fairness == 1
replace fairness = 1 if d301_arefair == 1
replace fairness = 1 if d302_abbreviate == 1
replace fairness = 1 if d303_flawsoverstated == 1
replace fairness = 1 if d304_noblanket == 1
replace fairness = 1 if d309_otherpro == 1
replace fairness = 1 if d310_inadequaterep == 1
replace fairness = 1 if d311_arbitrary == 1
replace fairness = 1 if d312a_racist == 1
replace fairness = 1 if d312b_classist == 1
replace fairness = 1 if d312c_otherdemo == 1
replace fairness = 1 if d313a_vulnerablepop == 1
replace fairness = 1 if d313b_mitigating == 1
replace fairness = 1 if d314_mandatorysent == 1
replace fairness = 1 if d315_noaltpunish == 1
replace fairness = 1 if d316_evidence == 1
replace fairness = 1 if d317_innocence == 1
replace fairness = 1 if d318_broken == 1
replace fairness = 1 if d319_otheranti == 1
tab nytindexyear fairness

gen pro_fairness = 0
replace pro_fairness = 1 if d301_arefair == 1
replace pro_fairness = 1 if d302_abbreviate == 1
replace pro_fairness = 1 if d303_flawsoverstated == 1
replace pro_fairness = 1 if d304_noblanket == 1
replace pro_fairness = 1 if d309_otherpro == 1
tab nytindexyear pro_fairness

gen anti_fairness = 0
replace anti_fairness = 1 if d310_inadequaterep == 1
replace anti_fairness = 1 if d311_arbitrary == 1
replace anti_fairness = 1 if d312a_racist == 1
replace anti_fairness = 1 if d312b_classist == 1
replace anti_fairness = 1 if d312c_otherdemo == 1
replace anti_fairness = 1 if d313a_vulnerablepop == 1
replace anti_fairness = 1 if d313b_mitigating == 1
replace anti_fairness = 1 if d314_mandatorysent == 1
replace anti_fairness = 1 if d315_noaltpunish == 1
replace anti_fairness = 1 if d316_evidence == 1
replace anti_fairness = 1 if d317_innocence == 1
replace anti_fairness = 1 if d318_broken == 1
replace anti_fairness = 1 if d319_otheranti == 1
tab nytindexyear anti_fairness

**************CONSTITUTIONAL
gen constitutional = 0
replace constitutional = 1 if d400_constpopcontrol == 1
replace constitutional = 1 if d401_notcruel == 1
replace constitutional = 1 if d402_processupheld == 1
replace constitutional = 1 if d403_popsupportup == 1
replace constitutional = 1 if d404_statesrightspro == 1
replace constitutional = 1 if d405_fedjurispro == 1
replace constitutional = 1 if d409_otherpro == 1
replace constitutional = 1 if d410_cruelunusual == 1
replace constitutional = 1 if d411_viodueprocess == 1
replace constitutional = 1 if d412_popsupportdown == 1
replace constitutional = 1 if d413_statesrightsanti  == 1
replace constitutional = 1 if d414_fedjurisanti  == 1
replace constitutional = 1 if d419_otheranti  == 1
tab nytindexyear constitutional

gen pro_constitutional = 0
replace pro_constitutional = 1 if d401_notcruel == 1
replace pro_constitutional = 1 if d402_processupheld == 1
replace pro_constitutional = 1 if d403_popsupportup == 1
replace pro_constitutional = 1 if d404_statesrightspro == 1
replace pro_constitutional = 1 if d405_fedjurispro == 1
replace pro_constitutional = 1 if d409_otherpro == 1
tab nytindexyear pro_constitutional

gen anti_constitutional = 0
replace anti_constitutional = 1 if d410_cruelunusual == 1
replace anti_constitutional = 1 if d411_viodueprocess == 1
replace anti_constitutional = 1 if d412_popsupportdown == 1
replace anti_constitutional = 1 if d413_statesrightsanti  == 1
replace anti_constitutional = 1 if d414_fedjurisanti  == 1
replace anti_constitutional = 1 if d419_otheranti  == 1
tab nytindexyear anti_constitutional

**************COST
gen cost = 0
replace cost = 1 if d500_cost == 1
replace cost = 1 if d501_worthit == 1
replace cost = 1 if d502_prisonexp == 1
replace cost = 1 if d509_otherpro == 1
replace cost = 1 if d510_notworthit == 1
replace cost = 1 if d511_prisoncheaper == 1
replace cost = 1 if d519_otheranti == 1
tab nytindexyear cost

gen pro_cost = 0
replace pro_cost = 1 if d501_worthit == 1
replace pro_cost = 1 if d502_prisonexp == 1
replace pro_cost = 1 if d509_otherpro == 1
tab nytindexyear pro_cost

gen anti_cost = 0
replace anti_cost = 1 if d510_notworthit == 1
replace anti_cost = 1 if d511_prisoncheaper == 1
replace anti_cost = 1 if d519_otheranti == 1
tab nytindexyear anti_cost

**************MODE
gen mode = 0
replace mode = 1 if d600_mode == 1
replace mode = 1 if d601_modejust == 1
replace mode = 1 if d609_otherpro == 1
replace mode = 1 if d610_modequestioned == 1
replace mode = 1 if d619_otheranti == 1
tab nytindexyear mode

gen pro_mode = 0
replace pro_mode = 1 if d601_modejust == 1
replace pro_mode = 1 if d609_otherpro == 1
tab nytindexyear pro_mode

gen anti_mode = 0
replace anti_mode = 1 if d610_modequestioned == 1
replace anti_mode = 1 if d619_otheranti == 1
tab nytindexyear anti_mode

**************INTERNATIONAL
gen international = 0
replace international = 1 if d700_international == 1
replace international = 1 if d709_internationalpro == 1
replace international = 1 if d710_intcomplaints == 1
replace international = 1 if d711_extraditionprobs == 1
replace international = 1 if d712_foreignnatls == 1
replace international = 1 if d719_other_anti == 1
tab nytindexyear international

gen pro_international = 0
replace pro_international = 1 if d709_internationalpro == 1
tab nytindexyear pro_international

gen anti_international = 0
replace anti_international = 1 if d710_intcomplaints == 1
replace anti_international = 1 if d711_extraditionprobs == 1
replace anti_international = 1 if d712_foreignnatls == 1
replace anti_international = 1 if d719_other_anti == 1
tab nytindexyear anti_international

**************OTHER
gen other = 1
replace other = 0 if efficacy == 1
replace other = 0 if moral == 1
replace other = 0 if constitutional == 1
replace other = 0 if fairness == 1
replace other = 0 if cost == 1
replace other = 0 if mode == 1
replace other = 0 if international == 1
tab nytindexyear other



*************************************************************
*************************************************************
*************************************************************
***LARGE AGGREGATE CATEGORIES
gen pro_arguments = 0
replace pro_arguments = 1 if pro_efficacy == 1
replace pro_arguments = 1 if pro_moral == 1
replace pro_arguments = 1 if pro_fairness == 1
replace pro_arguments = 1 if pro_constitutional == 1
replace pro_arguments = 1 if pro_cost == 1
replace pro_arguments = 1 if pro_mode == 1
replace pro_arguments = 1 if pro_international == 1
tab nytindexyear pro_arguments

gen anti_arguments = 0
replace anti_arguments = 1 if anti_efficacy == 1
replace anti_arguments = 1 if anti_moral == 1
replace anti_arguments = 1 if anti_fairness == 1
replace anti_arguments = 1 if anti_constitutional == 1
replace anti_arguments = 1 if anti_cost == 1
replace anti_arguments = 1 if anti_mode == 1
replace anti_arguments = 1 if anti_international == 1
tab nytindexyear anti_arguments


**************************************************************
***VARIABLE COMBINATIONS OF PARTICULAR INTEREST - FREQUENCY CROSSTABS BY YEAR, next do these same combinations as proportions
gen cruel_and_unusual = 0
replace cruel_and_unusual = 1 if d401_notcruel == 1
replace cruel_and_unusual = 1 if d410_cruelunusual == 1
tab nytindexyear cruel_and_unusual

gen extension_legislation = 0
replace extension_legislation = 1 if d203_crimedeserves == 1 & d40_leg_initiative == 1
tab nytindexyear extension_legislation

gen vic_officer_legislation = 0
replace vic_officer_legislation = 1 if d10_vicofficer == 1 & d40_leg_initiative == 1
tab nytindexyear vic_officer_legislation

gen type_crime_legislation = 0
replace type_crime_legislation = 1 if d31_typecrime == 1 & d40_leg_initiative == 1
tab nytindexyear type_crime_legislation

gen new_issues = 0
replace new_issues = 1 if d316_evidence == 1
replace new_issues = 1 if d317_innocence == 1
replace new_issues = 1 if d318_broken == 1
tab nytindexyear new_issues

gen new_issues_defendant = 0
replace new_issues_defendant = 1 if new_issues == 1
replace new_issues_defendant = 1 if defendant_char == 1
tab new_issues_defendant

gen juveniles_vulnerable = 0
replace juveniles_vulnerable = 1 if d313a_vulnerablepop == 1 & d25_defjuv == 1
tab nytindexyear juveniles_vulnerable

gen menthand_vulnerable = 0
replace menthand_vulnerable =1 if d22_defmenthand == 1 & d313a_vulnerablepop == 1
tab nytindexyear menthand_vulnerable

gen deterrence = 0
replace deterrence = 1 if d101_deterrence == 1
replace deterrence = 1 if d110_notdeterrent == 1
tab nytindexyear deterrence

gen tone_strong_pro = 1 if d3_tone == 1
gen tone_weak_pro = 1 if d3_tone == 2
gen tone_neutral = 1 if d3_tone == 3
gen tone_weak_anti = 1 if d3_tone == 4
gen tone_strong_anti = 1 if d3_tone == 5
gen tone_uncodeable = 1 if d3_tone == 9

****NET TONE***;
*gen net_tone =
***************;
gen tone_pro = 0
replace tone_pro =1 if tone_strong_pro == 1 | tone_weak_pro == 1
gen tone_anti = 0
replace tone_anti = 1 if tone_strong_anti == 1 | tone_weak_anti == 1
gen tone_blah = 0
replace tone_blah = 1 if tone_neutral == 1 | tone_uncodeable == 1

gen type_news = 1 if d4_story_type == 1
gen type_editorial = 1 if d4_story_type == 2
gen type_op_ed = 1 if d4_story_type == 3
gen type_letter = 1 if d4_story_type == 4



***SHOWING WHETHER MAJOR CATEGORIES WERE GENERALLY ASSOCIATED WITH PRO OR ANTI TONE
gen efficacy_tone_pro = 0
replace efficacy_tone_pro = 1 if efficacy==1 & tone_pro==1

gen efficacy_tone_anti = 0
replace efficacy_tone_anti = 1 if efficacy==1 & tone_anti==1

gen moral_tone_pro = 0
replace moral_tone_pro = 1 if moral==1 & tone_pro==1

gen moral_tone_anti = 0
replace moral_tone_anti = 1 if moral==1 & tone_anti==1

gen fairness_tone_pro = 0
replace fairness_tone_pro = 1 if fairness==1 & tone_pro==1

gen fairness_tone_anti = 0
replace fairness_tone_anti = 1 if fairness==1 & tone_anti==1

gen constitutional_tone_pro = 0
replace constitutional_tone_pro = 1 if constitutional==1 & tone_pro==1

gen constitutional_tone_anti = 0
replace constitutional_tone_anti = 1 if constitutional==1 & tone_anti==1

gen cost_tone_pro = 0
replace cost_tone_pro = 1 if cost==1 & tone_pro==1

gen cost_tone_anti = 0
replace cost_tone_anti = 1 if cost==1 & tone_anti==1

gen mode_tone_pro = 0
replace mode_tone_pro = 1 if mode==1 & tone_pro==1

gen mode_tone_anti = 0
replace mode_tone_anti = 1 if mode==1 & tone_anti==1

gen international_tone_pro = 0
replace international_tone_pro = 1 if international==1 & tone_pro==1

gen international_tone_anti = 0
replace international_tone_anti = 1 if international==1 & tone_anti==1

gen other_tone_pro = 0
replace other_tone_pro = 1 if other==1 & tone_pro==1

gen other_tone_anti = 0
replace other_tone_anti = 1 if other==1 & tone_anti==1

gen defendant_and_new=0
replace defendant_and_new = 1 if defendant_char == 1
replace defendant_and_new = 1 if new_issues == 1

gen defendant_and_new_tone_pro = 0
replace defendant_and_new_tone_pro = 1 if defendant_and_new ==1 & tone_pro==1

gen defendant_and_new_tone_anti = 0
replace defendant_and_new_tone_anti =1 if defendant_and_new ==1 & tone_anti==1

gen vic_no_def_pro=0
replace vic_no_def_pro=1 if vic_no_def==1 & tone_pro==1

gen vic_no_def_anti=0
replace vic_no_def_anti=1 if vic_no_def==1 & tone_anti==1

gen vic_no_def_blah=0
replace vic_no_def_blah=1 if vic_no_def==1 & tone_blah==1

gen def_no_vic_pro=0
replace def_no_vic_pro=1 if def_no_vic==1 & tone_pro==1

gen def_no_vic_anti=0
replace def_no_vic_anti=1 if def_no_vic==1 & tone_anti==1

gen def_no_vic_blah=0
replace def_no_vic_blah=1 if def_no_vic==1 & tone_blah==1

gen neither_vic_nor_def_pro = 0
replace neither_vic_nor_def_pro = 1 if neither_vic_nor_def == 1 & tone_pro==1

gen neither_vic_nor_def_anti = 0
replace neither_vic_nor_def_anti = 1 if neither_vic_nor_def == 1 & tone_anti==1

gen neither_vic_nor_def_blah = 0
replace neither_vic_nor_def_blah = 1 if neither_vic_nor_def == 1 & tone_blah==1

gen victim_char_pro = 0
replace victim_char_pro = 1 if victim_char == 1 & tone_pro==1

gen victim_char_anti = 0
replace victim_char_anti = 1 if victim_char == 1 & tone_anti==1

gen victim_char_blah = 0
replace victim_char_blah = 1 if victim_char == 1 & tone_blah==1

gen defendant_char_pro = 0
replace defendant_char_pro = 1 if defendant_char == 1 & tone_pro==1

gen defendant_char_anti = 0
replace defendant_char_anti = 1 if defendant_char == 1 & tone_anti==1

gen defendant_char_blah = 0
replace defendant_char_blah = 1 if defendant_char == 1 & tone_blah==1

***TABULATIONS FOR PROPORTIONS
tab tone_pro
tab tone_anti
tab tone_blah

tab efficacy
tab moral
tab fairness
tab constitutional
tab cost
tab mode
tab international
tab other

tab efficacy_tone_pro
tab efficacy_tone_anti
tab moral_tone_pro
tab moral_tone_anti
tab fairness_tone_pro
tab fairness_tone_anti
tab constitutional_tone_pro
tab constitutional_tone_anti
tab cost_tone_pro
tab cost_tone_anti
tab mode_tone_pro
tab mode_tone_anti
tab international_tone_pro
tab international_tone_anti
tab other_tone_pro
tab other_tone_anti

sort vic_no_def
by vic_no_def: tab tone_pro
by vic_no_def: tab tone_anti
by vic_no_def: tab tone_blah

sort def_no_vic
by def_no_vic: tab tone_pro
by def_no_vic: tab tone_anti
by def_no_vic: tab tone_blah

sort neither_vic_nor_def
by neither_vic_nor_def: tab tone_pro
by neither_vic_nor_def: tab tone_anti
by neither_vic_nor_def: tab tone_blah

***TOTAL ARGUMENT COUNTS
tab d100_efficacy
tab d101_deterrence
tab d102_incapacitation
tab d103_altsflawed
tab d109_otherpro
tab d110_notdeterrent
tab d111_altsystems
tab d119_otheranti
tab d200_moral
tab d201_retribution
tab d202_famvengeance
tab d203_crimedeserves
tab d209_otherpro
tab d210_killingvenbad
tab d211_famopposed
tab d219_otheranti
tab d300_fairness
tab d301_arefair
tab d302_abbreviate
tab d303_flawsoverstated
tab d304_noblanket
tab d309_otherpro
tab d310_inadequaterep
tab d311_arbitrary
tab d312a_racist
tab d312b_classist
tab d312c_otherdemo
tab d313a_vulnerablepop
tab d313b_mitigating
tab d314_mandatorysent
tab d315_noaltpunish
tab d316_evidence
tab d317_innocence
tab d318_broken
tab d319_otheranti
tab d400_constpopcontrol
tab d401_notcruel
tab d402_processupheld
tab d403_popsupportup
tab d404_statesrightspro
tab d405_fedjurispro
tab d409_otherpro
tab d410_cruelunusual
tab d411_viodueprocess
tab d412_popsupportdown
tab d413_statesrightsanti
tab d414_fedjurisanti
tab d419_otheranti
tab d500_cost
tab d501_worthit
tab d502_prisonexp
tab d509_otherpro
tab d510_notworthit
tab d511_prisoncheaper
tab d519_otheranti
tab d600_mode
tab d601_modejust
tab d609_otherpro
tab d610_modequestioned
tab d619_otheranti
tab d700_international
tab d709_internationalpro
tab d710_intcomplaints
tab d711_extraditionprobs
tab d712_foreignnatls
tab d719_other_anti
tab d900_other_dimension

***ARTICLE COUNTS AND PROPORTIONS
gen total_n = 1

gen maincats = 0
replace maincats = 1 if efficacy == 1
replace maincats = 1 if moral == 1
replace maincats = 1 if fairness == 1
replace maincats = 1 if constitutional == 1

gen old_frame = 0
replace old_frame = 1 if constitutional==1
replace old_frame = 1 if deterrence == 1
replace old_frame = 1 if pro_moral == 1

gen new_frame = 0
replace new_frame = 1 if fairness==1
replace new_frame = 1 if anti_moral==1

gen prop_new_def = new_issues_defendant/total_n
gen prop_maincats_new_def = new_issues_defendant/maincats

gen prop_old_frame = old_frame/total_n
gen prop_maincats_old_frame = old_frame/maincats

gen prop_new_frame = new_frame/total_n
gen prop_maincats_new_frame = new_frame/maincats

*save P:\lobby\agendas_project\death_penalty\book\data\NYT\abstract_level_1960_2005.dta, replace
save abstract_level_1960_2005.dta, replace