------------------------------------------------------------------------------- log: G:\April_27_2007_from_J_drive\website\data_log_and_do_files\make_y > rly_nyt_1960_2005.log log type: text opened on: 28 Apr 2007, 09:06:08 . ***************************************************************************** > ***********************************; . * 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: make_yrly_nyt_1960_2005.do > ; . * Purpose: collapse NYT stories by year > ; . * Data Input: abstract_level_1960_2005.dta > ; . * Log File: make_yrly_nyt_1960_2005.log > ; . * Data Output: yrly_nyt_1960_2005.dta > ; . * NOTES: > ; . ***************************************************************************** > ***********************************; . *Start with the raw NYT dataset of individual stories; . use abstract_level_1960_2005.dta; . *****************************; . **Year as Unit of Analysis***; . *****************************; . ***Now aggregate the variables by year and save the datafile - includes indiv > idual vars***; . gen total_art_y=1; . collapse (sum) tone_strong_pro tone_weak_pro tone_neutral tone_weak_anti ton > e_strong_anti > tone_uncodeable tone_pro tone_anti tone_blah type_news type_editorial typ > e_op_ed > type_letter frontpage d10_vicofficer d11_vicchild d12_vicmult d13_vicfam > d14_female > d19_viccharother d20_defterr d21_defmin d22_defmenthand d23_deffem d24_de > fparent > d25_defjuv d27_defhuman d29_defcharother d30_mode d31_typecrime d32_viole > nce > 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 d21 > 1_famopposed > d219_otheranti d300_fairness d301_arefair d302_abbreviate d303_flawsovers > tated > d304_noblanket d309_otherpro d310_inadequaterep d311_arbitrary d312a_raci > st d312b_classist > d312c_otherdemo d313a_vulnerablepop d313b_mitigating d314_mandatorysent d > 315_noaltpunish > d316_evidence d317_innocence d318_broken d319_otheranti d400_constpopcont > rol d401_notcruel > d402_processupheld d403_popsupportup d404_statesrightspro d405_fedjurispr > o d409_otherpro > d410_cruelunusual d411_viodueprocess d412_popsupportdown d413_statesright > santi > d414_fedjurisanti d419_otheranti d500_cost d501_worthit d502_prisonexp d5 > 09_otherpro > d510_notworthit d511_prisoncheaper d519_otheranti d600_mode d601_modejust > d609_otherpro > d610_modequestioned d619_otheranti d700_international d709_internationalp > ro > d710_intcomplaints d711_extraditionprobs d712_foreignnatls d719_other_ant > i victim_char > defendant_char efficacy pro_efficacy anti_efficacy moral pro_moral anti_m > oral fairness > pro_fairness anti_fairness constitutional pro_constitutional anti_constit > utional cost > pro_cost anti_cost mode pro_mode anti_mode international pro_internationa > l anti_international > other cruel_and_unusual extension_legislation vic_officer_legislation typ > e_crime_legislation > new_issues juveniles_vulnerable menthand_vulnerable deterrence pro_argume > nts anti_arguments > efficacy_tone_pro efficacy_tone_anti moral_tone_pro moral_tone_anti fairn > ess_tone_pro > fairness_tone_anti constitutional_tone_pro constitutional_tone_anti cost_ > tone_pro > cost_tone_anti mode_tone_pro mode_tone_anti international_tone_pro intern > ational_tone_anti > other_tone_pro other_tone_anti defendant_and_new total_art_y, by(nytindex > year); . rename nytindexyear year; . generate net_tone = tone_pro-tone_anti; . label var net_tone > "tone_pro minus tone_anti"; . sort year; . save yrly_nyt_1960_2005.dta, replace; (note: file yrly_nyt_1960_2005.dta not found) file yrly_nyt_1960_2005.dta saved . end of do-file