*********************************************************************************
*
*								MERGE
*
*********************************************************************************
* Demographics (DN): Basic demographic information about 
* each respondent's marital status, country of birth and
* education. The module also contains questions on the 
* respondentīs parents and (ex-)spouses.
***************************************************************
clear

cd "G:\Il mio Drive\Multifonte\" 
use sharew1_rel8-0-0_dn, clear


tab country,mi
tab dn042,mi


*********************************************************************************
* 								COVERSCREEN
*********************************************************************************
* The coverscreen is the first module of each interview.
* It collects basic demographic information about every person 
* currently living in the household. 
* The coverscreen questionnaire is completed by only one member 
* of the household. Household members who are not eligible for 
* a SHARE interview are part of the coverscreen data, too, 
* which explains the higher number of observations compared to 
* the other CAPI interview modules.
*********************************************************************************
use sharew1_rel8-0-0_cv_r, clear

tab country,mi
tab gender,mi

tab interview

set more off
tab1 cvresp fam_resp fin_resp hou_resp,mi


*********************************************************************************
merge 1:1 mergeid using  sharew1_rel8-0-0_dn,

tab _merge interview

********************************************************
*OPERIAMO ALCUNI CONTROLLI DI COERENZA TRA LE VARIABILI
*PRESENTI IN ENTRAMBI I DATABASE
******************************************************** 
*genere
tab _merge interview if dn042_==gender,mi
tab _merge interview if dn042_!=gender,mi

*anno di nascita
tab _merge interview if dn003_== yrbirth,mi
tab _merge interview if dn003_!= yrbirth,mi

*mese di nascita
tab _merge interview if dn002_== mobirth,mi
tab _merge interview if dn002_!= mobirth,mi

tab mobirth interview if dn002_!= mobirth & _merge==3,mi col
tab dn002 interview if dn002_!= mobirth & _merge==3,mi col


***********************************************************
*571 discrepanze sul mese di nascita
**********************************************************
gen wave=1
save shareWave1, replace




*****************************************************************
*****************************************************************
*PARTE 1
* 			Fate la stessa cosa con la wave 2
*
*****************************************************************

use sharew2_rel8-0-0_cv_r, clear

merge 1:1 mergeid using sharew2_rel8-0-0_dn,
tab _merge interview
drop _merge

*****************************************************************
*PARTE 2: partendo dal file creato
*
*			Sapreste unire la wave 2 e la wave 1
*
*****************************************************************

help append

append using shareWave1
recode wave(.=2)
tab wave interview

save shareWave1e2, replace

*****************************************************************
*PARTE 3: partendo dal file creato 
*  
*
*  PROVATE AD ABBINARE LE INFORMAZIONI CONTENUTE NEL FILE
*  CH_ SUI FIGLI SIA PER LA PRIMA CHE PER LA SECONDA WAVE
*  (ATTENZIONE A COLLEGARE I FILE CH_ ALLA WAVE GIUSTA)
*****************************************************************