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

/***********************************************************************/
/********* define directories ****************/
/***********************************************************************/
global datadir "c:\work\SHARE\Wave_6_2014\data\sharew6_rel6-0-0"
/***********************************************************************/

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

global modules "ac as br bs cf ch co dn ep ex ft gs hc hh ho  it iv mh pf ph sn sp technical_variables xt"
global cv "cv_r"
global gv "gv_children gv_dbs gv_health gv_housing gv_imputations gv_networks gv_weights"

 
use $datadir\sharew6_rel6-0-0_cv_r.dta, clear
keep if country ==28
sort mergeid
save $datadir\sharew6_cz, replace



foreach x in $modules {

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

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

}


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

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



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

foreach x in $gv {

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

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

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


*DROPOFF
use $datadir\sharew6_rel6-0-0_dropoff.dta, clear
keep if country ==28

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