**............................................................................**
**                                                                            **
**        COMPARATIVE STUDY OF ELECTORAL SYSTEMS (CSES)                       **
**  Stata example syntax for bridging party-level data to CSES relational     **
**  data: Bridging the CSES MODULE 4 FINAL RELEASE to the Comparative         **
**  Manifesto Project Dataset (MARPOR/CMP)                                    **                                                            
**                                                                            **
**  CSES Module 4 Version:    MODULE 4 FINAL RELEASE                          **
**  MARPOR/CMP Version:       Manifesto Project Dataset (Version 2020a)       **                                                
**  Default Directory:        c:\cses\CSES_data_bridging_project              **
**                                                                            **
**  Website:       www.cses.org                                               **
**  Email:         cses@umich.edu                                             **
**  Last Updated:  November 23, 2020                                          **
**  Created by:    CSES Secretariat                                           **
**............................................................................**


********************************************************************************
********************************************************************************
**>>> SYNTAX FILE: SECTIONS AND TABLE OF CONTENTS
** 1: Instructions for Navigating Syntax File, Purpose of Syntax File, STATA 
**    Setup, and Set Working Directory 
** 2: Loading the CSES Module 4 Dataset & Preparing CSES Module 4 Dataset For  
**    Bridging with variables from MARPOR/CMP Dataset
** 3: Loading the MARPOR/CMP Dataset & Preparing the MARPOR/CMP Dataset For
**    Bridging with variables from CSES Module 4  
** 4: Bridging the CSES Module 4 Dataset with the MARPOR/CMP Dataset
** 5: Finalizing the Bridged Dataset
********************************************************************************
********************************************************************************


********************************************************************************
********************************************************************************
**#>>> 1: INSTRUCTIONS FOR NAVIGATING SYNTAX FILE, PURPOSE OF SYNTAX FILE
**        STATA SETUP AND SET WORKING DIRECTORY
********************************************************************************
********************************************************************************


********************************************************************************
**\\\ 1.1 INSTRUCTIONS FOR NAVIGATING SYNTAX FILE
********************************************************************************
** #>>>    = Section Heading
*** \\\    = Sub-section Heading
**  //     = Instruction Heading 
** ACHTUNG = Highlighting any issues including potential file path changes 
**           needed to successfully run the file.


********************************************************************************
**\\\ 1.2 PURPOSE OF SYNTAX FILE INSTRUCTIONS
********************************************************************************

** This syntax file is intended for less experienced users of STATA. 
** For advanced STATA users, we recommend that you use the Light File 
** which provides only minimal comments for commands employed in the file. 
** This is available on the CSES Data Bridging Webpage - see Light File.

** This syntax outlines how to bridge the 2020a MARPOR/CMP Manifesto Project 
** Dataset to the CSES Module 5 Second Advance Release dataset. This example 
** demonstrates how to merge MARPOR/CMPs right-left ideological index
** (variable name in MARPOR/CMP "RILE") to the CSES Module 4 dataset. 
** Variables from MARPOR/CMP can also be linked to other CSES Data Products 
** using this syntax example be specifying a different CSES data product.  
** Other variables from MARPOR/CMP besides the "RILE" can also be linked to CSES
** data products by specifying a different variable from MARPOR/CMP.  


********************************************************************************
**\\\ 1.3 CLEARING THE STATA WORKSPACE
********************************************************************************

** // CLOSE ALL OPEN DATA FILES, GRAPH WINDOWS, AND DIALOG BOXES
clear all 
** // CLOSE ANY OPEN LOG-FILES
capture log close


********************************************************************************
**\\\ 1.4 DOWNLOAD THE CSES MODULE 4 AND MARPOR/CMP DATASETS AND  
**        SET THE WORKING DIRECTORY
********************************************************************************

** // DOWNLOAD THE CSES MODULE 4 DATASET: 
**    The current release of the CSES Module 4 Dataset is available via 
**    https://cses.org/data-download/module-4-2011-2016/ 


** // DOWNLOAD THE MARPOR/CMP DATASET: 
**    The current release of the Manifesto Project Dataset (version 2020a) is 
**    available via https://manifesto-project.wzb.eu/datasets upon registration. 
 
 
** ACHTUNG: BEFORE RUNNING THE SYNTAX FILE, CSES strongly advises users to save  
**          the CSES Module 4 and MARPOR/CMP datasets into the SAME(!) folder. 
**          We suggest the following directory: 
**          C:\cses\CSES_data_bridging_project

** // SPECIFY THE WORKING DIRECTORY   
**    The following command sets the working directory, i.e. the folder from 
**    which datasets are loaded into Stata and into which Stata places saved 
**    datasets. 
**
** ACHTUNG: Running the syntax requires the CSES Module 4 and MARPOR/CMP dataset
**          to be placed in the working directory specified below. We suggest 
**          the following:  
cd "C:\cses\CSES_data_bridging_project" 


********************************************************************************
**\\\ 1.5 PARAMETERS FOR DATA BRIDGING TO FUNTION IN STATA
********************************************************************************
** In STATA, bridging data from two or more different sources requires key  
** variables with unit identifiers that:
** a) are included in both datasets 
** b) have the same variable name (i.e. column names should be identical)

** The following key variables are required for bridging CSES to MARPOR/CMP: 
** 1) a variable identifying the polity
** 2) a variable identifying the election (month and year election held) 
** 3) a variable identifying the political party 


********************************************************************************
********************************************************************************
**#>>> 2: LOADING THE CSES MODULE 4 DATASET & PREPARING CSES MODULE 4 DATASET
**        FOR MERGING WITH VARIABLES FROM MARPOR/CMP 

** the CSES Module 4 dataset includes the following identifiers required for 
** bridging data to MARPOR/CMP: 
** 1) Polity Identifier: IMD1006_NAM
** 2) Election Identifier (month and year election held): D5024_1 & D5034_3
** 3) Party Identifier: D5200_A-I
********************************************************************************
********************************************************************************

** // LOAD CSES MODULE 4 DATASET   
use cses4.dta, clear 


** // TABULATE POLITY ID VARIABLE IN CSES FOR MERGING 
**   (variable name in CSES: polity identifier D1006_NAM: Polity Name)   
tabulate D1006_NAM, m 


** // TABULATE MARPOR/CMP PARTY ID VARIABLE IN CSES FOR MERGING 
**    (variable name in CSES: E5200_A-I MARPOR/CMP identifiers for PARTIES A-I)    
tab1 D5200_*, m 


** // CREATE A NEW ELECTION ID IN CSES FOR MONTH OF ELECTION TO ENABLE BRIDGING 
**    WITH MARPOR/CMP
**    (NOTE: MARPOR/CMP provides the election identifier in YYYYMM format. E.g., 
**    a September 2015 election is coded as 201509. The CSES provides data
**    on election date in three separate variables D5024_1-3 for Month, Day and
**    Year. The following lines 150 - 189 create a single election date ID
**    within CSES resembling the MARPOR/CMP identifier. 

** // CREATE A NEW ELECTION ID IN CSES - MONTH
**    (use Variable D5024_1 Date election held: Month in CSES which is saved as 
**     string variable "emonth") 
tostring D5024_1, gen(emonth) 

** // INSERT A ZERO IN FRONT OF MONTHS INCLUDED IN VARIABLE "EMONTH" - 
**    (NOTE: currently, emonth codes election months January (1) - September (9)
**     with a single digit. However, the MARPOR/CMP identifier requires election 
**     date in a YYYYMM format. Hence, the following lines 162 - 170 add a zero 
**     in front of every single-digit month, such that a September 2015 election
**     will be coded as 201509 instead of 20159. 

replace emonth = "01" if emonth == "1" // January
replace emonth = "02" if emonth == "2" // February
replace emonth = "03" if emonth == "3" // March
replace emonth = "04" if emonth == "4" // April   
replace emonth = "05" if emonth == "5" // May
replace emonth = "06" if emonth == "6" // June
replace emonth = "07" if emonth == "7" // July
replace emonth = "08" if emonth == "8" // August
replace emonth = "09" if emonth == "9" // September


** // CREATE A NEW ELECTION ID IN CSES FOR YEAR OF ELECTION TO ENABLE BRIDGING
**    WITH MARPOR/CMP 
**    (use Variable D5024_3 Date election held: Year in CSES which is saved as string variable) 
tostring D5024_3, gen(eyear)


** // CREATE A NEW ELECTION ID IN CSES COMBINING MONTH AND YEAR OF ELECTION TO
**    ENABLE BRIDGING WITH MARPOR/CMP 
**   (Note: Combining year and month variables created above to generate new 
**    variable "date" combining eyear and emonth into one string:
generate date = eyear + emonth 


** // DESTRING NEW VARIABLE TO MAKE NUMERIC VARIABLE AND TABULATE TO CHECK 
**    VARIABLE IS "YYYYMM" FORMAT
destring date, replace 
tabulate date, m


** // DROP HELP VARIABLES emonth AND eyear NEEDED FOR CREATING ELECTION ID:
drop emonth eyear

	  
** // SAVE CSES MODULE 4 DATASET WITH NEWLY CREATED VARIABLES - 
**    CSES FILE READY FOR BRIDGING
save cses_m4_formerging.dta, replace



********************************************************************************
********************************************************************************
**#>>> 3: LOADING THE MARPOR/CMP DATASET & PREPARING MARPOR/CMP DATASET
**        FOR MERGING WITH CSES MODULE 4  

** the MARPOR/CMP dataset includes the following identifiers required for 
** bridging data to CSES: 
** 1) Polity Identifier: countryname
** 2) Election Identifier (month and year election held): date
** 3) Party Identifier: party

* However, for STATA to conduct data bridging, identifiers have to be named the
* same in the CSES and the Manifesto dataset. Therefore, the following lines 
* generate identifiers named according to CSES Standards: 
********************************************************************************
********************************************************************************


** // LOAD MARPOR/CMP  DATASET   
use "MPDataset_MPDS2020a.dta", clear  


** // CREATE POLITY ID VARIABLE IN MARPOR/CMP TO ENABLE MERGING WITH CSES 
**   (variable name in MARPOR/CMP: countryname: English country name)  
**   (Note: save countryname as D1006_NAM which is the country name variable in 
**   CSES Module 4):  
generate D1006_NAM = countryname 

** // RENAME POLITIES ACCORDING TO CSES STANDARD, IF NECESSARY:
**    USA listed differently in CSES and MARPOR/CMP. This harmonizes country name 
**    in line with CSES standards: 
replace D1006_NAM = "United States of America" if D1006_NAM == "United States"
**    Korea listed differently in CSES and MARPOR/CMP. This harmonizes country name 
**    in line with CSES standards: 
replace D1006_NAM = "Republic of Korea" if D1006_NAM == "South Korea" 
**    MARPOR/CMP only includes data for the United Kingdom, while CSES survey 
**    data refers to Great Britain (no respondents from Northern Ireland included). 
**    This harmonizes country name to Great Britain:
replace D1006_NAM = "Great Britain" if D1006_NAM == "United Kingdom" 

** // TABULATE ELECTION ID VARIABLE FOR MERGING 
tabulate date, missing // date: election date (YYYYMM)

	  
** // CREATE NEW PARTY ID VARAIBLES FOR MERGING WITH CSES 
** The syntax above duplicates the CMP/MARPOR identifier "party" nine times within 
** the CMP/MARPOR dataset before bridging – once for each alphabetic party code A-I, 
** labelling them according to MARPOR/CMP identifiers included in CSES Module 4:
** D5200_A, D5200_B, … D5200_I. 	  
generate D5200_A = party // party: MARPOR/CMP party ID
generate D5200_B = party // party: MARPOR/CMP party ID
generate D5200_C = party // party: MARPOR/CMP party ID
generate D5200_D = party // party: MARPOR/CMP party ID
generate D5200_E = party // party: MARPOR/CMP party ID
generate D5200_F = party // party: MARPOR/CMP party ID
generate D5200_G = party // party: MARPOR/CMP party ID
generate D5200_H = party // party: MARPOR/CMP party ID
generate D5200_I = party // party: MARPOR/CMP party ID


** // DROP UNNEEDED VARIABLES 
** Note: As this syntax aims to bring CMP/MARPOR's "RILE" variable into CSES 
**       Module 4, all other variables besides identifiers and "RILE" variable
**       may be dropped from the dataset. 
keep D1006_NAM date D5200* rile 

** // DROP ELECTIONS NOT SCHEDULED IN CSES MODULE 4 PERIOD
**    deleting all entries for elections before January 2011 and after December
**    2016 (i.e. before and after the M4 data collection period)
keep if inrange(date, 201101, 201612)


** // SAVE MARPOR/CMP DATASET WITH NEWLY CREATED VARIABLES ONLY - FILE READY FOR BRIDGING
save MPDataset_MPDS2020a_formerging, replace



********************************************************************************
********************************************************************************
** #>>> 4: MERGING THE CSES MODULE 4 AND MARPOR/CMP DATASETS TOGETHER 
********************************************************************************
********************************************************************************


********************************************************************************
**\\\ 4.1 IMPORTANT NOTE ON MERGING VARIABLES IN STATA:
********************************************************************************

** When conducting a merge, STATA generates a new variable typically called _merge. 
** This variable conventionally has the following three categories, labeled as 
** "master only", "using only", and "matched". Tabulating this variable will give
** you an indication of the following: 
**
** master only (1): identifies cases present in CSES Data only. The CSES data is
**                  called the "master data" because it was loaded into STATA 
**				    when merging was performed.
**  using only (2): identifies cases present in Manifesto Data only. The Manifesto
**                  data is called the "using data" because it was added to the CSES 
**				    data already loaded into Stata by specifying merge ... using.
**     matched (3): identifies cases where Manifesto data was merged successfully 
**	                to CSES data.
**
** All cases that were merged successfully are awarded code "3. matched". 


********************************************************************************
**\\\ 4.2 IMPORTANT NOTE ON BRIDGING BY CSES ALPHABETICAL PARTY CODE
********************************************************************************

** The following steps 4.3 - 4.11 bridge the MARPOR/CMP Dataset to CSES based on 
** key variables previously defnied in Steps 2 and 3. 
** CSES includes MARPOR/CMP party codes for those parties assigned an alphabetical
** party code in CSES (PARTY A-I). Therefore, merging MARPOR/CMP data to CSES 
** is conducted separately for each PARTY A-I. 
** For more information on how alphabetic party codes are used in CSES, please 
** refer to the CSES Module 4 Codebook Part 3 or to the FAQs on the CSES homepage: 
** https://cses.org/about/frequently-asked-questions/ 

* NOTE: In what follows, the steps conducted for merging the "rile" MARPOR/CMP index
* to CSES alphabetical PARTIES A-I is repeated for each alphabetical party code, 
* i.e., PARTY A - I. 


********************************************************************************
**\\\ 4.3 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY A:
********************************************************************************

** // LOADING THE SAVED MODULE 4 DATASET INCLUDING IDENTIFIERS: 
use cses_m4_formerging.dta, clear

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY A:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY A (D5200_A): 
merge m:1 D1006_NAM date D5200_A using "MPDataset_MPDS2020a_formerging.dta", gen(merge_A) 

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_A, FOR PARTY A:
rename rile rile_A

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY A:
label variable rile_A "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY A"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_A == 2 


********************************************************************************
**\\\ 4.4 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY B:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY B:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY B (D5200_B): 
merge m:1 D1006_NAM date D5200_B using "MPDataset_MPDS2020a_formerging.dta", gen(merge_B)

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_B, FOR PARTY B:
rename rile rile_B

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY B:
label variable rile_B "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY B"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_B == 2 


********************************************************************************
**\\\ 4.5 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY C:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY C:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY C (D5200_C): 
merge m:1 D1006_NAM date D5200_C using "MPDataset_MPDS2020a_formerging.dta", gen(merge_C)

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_C, FOR PARTY C:
rename rile rile_C

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY C:
label variable rile_C "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY C"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_C == 2 


********************************************************************************
**\\\ 4.6 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY D:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY D:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY D (D5200_D): 
merge m:1 D1006_NAM date D5200_D using "MPDataset_MPDS2020a_formerging.dta", gen(merge_D) 

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_D, FOR PARTY D:
rename rile rile_D

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY D:
label variable rile_D "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY D"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_D == 2 


********************************************************************************
**\\\ 4.7 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY E:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY E:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY E (D5200_E): 
merge m:1 D1006_NAM date D5200_E using "MPDataset_MPDS2020a_formerging.dta", gen(merge_E)

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_E, FOR PARTY E:
rename rile rile_E

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY E:
label variable rile_E "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY E"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_E == 2 


********************************************************************************
**\\\ 4.8 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY F:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY F:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY F (D5200_F): 
merge m:1 D1006_NAM date D5200_F using "MPDataset_MPDS2020a_formerging.dta", gen(merge_F) 

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_F, FOR PARTY F:
rename rile rile_F

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY F:
label variable rile_F "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY F"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_F == 2 


********************************************************************************
**\\\ 4.9 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY G:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY G:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY G (D5200_G):
merge m:1 D1006_NAM date D5200_G using "MPDataset_MPDS2020a_formerging.dta", gen(merge_G) 

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_G, FOR PARTY G:
rename rile rile_G

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY G:
label variable rile_G "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY G"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_G == 2 


********************************************************************************
**\\\ 4.10 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY H:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY H:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY H (D5200_H):
merge m:1 D1006_NAM date D5200_H using "MPDataset_MPDS2020a_formerging.dta", gen(merge_H) 

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_H, FOR PARTY H:
rename rile rile_H

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY H:
label variable rile_H "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY H"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_H == 2 


********************************************************************************
**\\\ 4.11 MERGING THE MARPOR/CMP DATA TO CSES MODULE 4 - PARTY I:
********************************************************************************

** // MERGE MARPOR/CMP DATASET TO CSES MODULE 4 DATASET FOR PARTY I:
**    (Note: merging procedure specified as "many to one" (m:1) as all respondents
**    assigned the same numerical party code in D5200_ are merged to exactly one 
**    corresponding MARPOR/CMP party). 
**    Merge by polity (D1006_Nam), by election ID (date) and by PARTY I (D5200_I):
merge m:1 D1006_NAM date D5200_I using "MPDataset_MPDS2020a_formerging.dta", gen(merge_I) 

** // RENAME MERGED MARPOR/CMP rile VARIABLE TO rile_I, FOR PARTY I:
rename rile rile_I

** // LABEL MERGED MARPOR/CMP rile VARIABLE FOR PARTY I:
label variable rile_I "MARPOR/CMP RIGHT-LEFT IDEOLOGICAL INDEX - PARTY I"

** // DROP CASES ONLY PRESENT IN MARPOR/CMP DATA (NO CSES EQUIVALENT):
drop if merge_I == 2 


********************************************************************************
********************************************************************************
* #>>> 5: FINALIZING THE BRIDGED DATASET
********************************************************************************
********************************************************************************

* After conducting separate merges for each alphabetical CSES party code, 
* the expanded dataset now includes MARPOR's rile scores. 
* In what follows, the data is cleaned in such a way that the newly added data
* is placed at the very end of the Module 4 dataset:  

** // PLACE NEWLY ADDED RILE VARIABLES AT THE END OF THE DATASET:
order rile*, after(D5201_I)

** // DROP ELECTION IDENTIFIER:
drop date

** // DROP MERGE CONTROL VARIABLES:
drop merge_*

** // SAVING THE FINAL DATASET:
save cses4_MARPOR_rile.dta, replace
 

**************************************************
*END OF DO-FILE