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

/***********************************************************************/
/********* define directories ****************/
/***********************************************************************/
global datadir "c:\work\SHARE\Wave_6_2014\data\internal"
/***********************************************************************/

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

global modules "ac_all as_all br_all bs_all cf_all ch_all co_all dn_all ep_all ex_all ft_all gs_all hc_all hh_all ho_all it_all iv_all mh_all pf_all ph_all sn_all sp_all xt_all"
global cv "cv_r_all"
//global gv "gv_health gv_housing gv_isced gv_weights"

/* does not include: generated variables (biomarkers, health, housing, isced, networks), weights, imputations */

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

foreach x in $modules {

	use $datadir\sharew6_`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

stop

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

foreach x in $gv {

	use $datadir\sharew6_`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_do.dta, clear
keep if country ==28

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