clear
set maxvar 10000
set mem 400m
set more off
set matsize 800

/***********************************************************************/
/********* define directories ****************/
/***********************************************************************/
global datadir "c:\SHARE\Data\sharew7"
/***********************************************************************/

/***********************************************************************/

global modules "ac as br cc cf ch co dn dq ep ex fs ft gl gs hc hh ho hs it iv mh ph ra rc re rp sp technical_variables wq xt"
global cv "cv_r"
global gv "gv_big5 gv_children gv_health gv_housing gv_imputations gv_weights"
 
use $datadir\sharew7_rel7-0-0_cv_r.dta, clear
keep if country ==28
sort mergeid
save $datadir\sharew7_cz, replace

foreach x in $modules {

	use $datadir\sharew7_rel7-0-0_`x'.dta
	keep if country ==28
	sort mergeid
	
	save $datadir\temp, replace

	use $datadir\sharew7_cz, clear
	merge mergeid using $datadir\temp.dta
	keep if country ==28
	drop _m
	sort mergeid
	save $datadir\sharew7_cz, replace

}


use $datadir\sharew7_cz.dta, clear
keep if country ==28
sort mergeid

log using $datadir\SHARE_Wave7_Codebook_CZ.log, replace
codebook, c
log close

/* GENERATED VARIABLES */
use $datadir\sharew7_rel7-0-0_gv_isced.dta, clear
keep if country ==28
sort mergeid
save $datadir\sharew7_gv_cz.dta, replace

foreach x in $gv {

	use $datadir\sharew7_rel7-0-0_`x'.dta
	keep if country ==28
	sort mergeid
	save $datadir\temp, replace

	use $datadir\sharew7_gv_cz, clear
	merge mergeid using $datadir\temp.dta
	keep if country ==28
	drop _m
	sort mergeid
	save $datadir\sharew7_gv_cz, replace
}

use $datadir\sharew7_gv_cz.dta, clear
keep if country ==28
sort mergeid

log using $datadir\SHARE_Wave7_Codebook_CZ_gv.log, replace
codebook, c
log close


*DROPOFF
use $datadir\sharew7_rel7-0-0_dropoff.dta, clear
keep if country ==28
keep mergeid* hhid7 couple* country* lang* yrbirth* gender* cz*
save $datadir\sharew7_rel7-0-0_dropoff_cz.dta, replace

log using $datadir\SHARE_Wave7_Codebook_CZ_dropoff.log, replace
codebook, c
log close