clear 
clear mata
clear matrix

global INPATH   "d:\work\SHARE\Wave2008\Data\sharew3_rel1"
global STUB     "sharew3_rel1"    
global OUTSTUB  "w3_data"    
global OUTPATH  "d:\work\share\data"

*------------------------------------------------------------------------------
clear
version 12.0
set mem 800m
pause off
set more off
*------------------------------------------------------------------------------
/* 
KOMENTAR
1. 	tento kod slouci soubory z 3. vlny SHARELIFE do jednoho souboru podle identifikace respondentu mergeid
2. 	slouci pouze moduly CS, CV_R, GL, RC, RP a ST, dalsi moduly se daji pripojit podobnym zpusobem
3. 	prvne tyto vybrane moduly ulozime pod novy jmenem w3_data_"modul".dta, 
	ve kterych promenne prejmenujeme s predponou vlny w3_"jmeno promenne"
	pomoci prikazu renpfix (aby se daly od sebe rozlisit vlny po spojeni dat:
	prikaz renpfix nahradi predponu sharelife sl_*  --->  predponou s cislem vlny w3_* )
4. 	spojeni modulu do jednou souburu podle osobni identifikace respondenta pomoci promenne mergeid 
5. 	ulozeni souboru w3_data.dta

V modulech pouzivame prikazy:
	keep "jmeno promenne"	ponecha v pameti jenom vyjmenovane promenne
	drop "jmeno promenne" 	vymaze z pameti vyjmenovane promenne
*/
   

use "${INPATH}/${STUB}_cs", clear
  renpfix sl_cs w3_cs
  sort mergeid
  save "${OUTPATH}/${OUTSTUB}_cs.dta", replace

use "${INPATH}/${STUB}_cv_r", clear
  keep mergeid gender yrbirth mobirth
  renpfix gender w3_gender
  renpfix yrbirth w3_yrbirth
  renpfix mobirth w3_mobirth
  sort mergeid
  save "${OUTPATH}/${OUTSTUB}_cv_r.dta", replace

use "${INPATH}/${STUB}_gl", clear
  renpfix sl_gl w3_gl
  sort mergeid
  save "${OUTPATH}/${OUTSTUB}_gl.dta", replace

use "${INPATH}/${STUB}_rc", clear
  drop      *_11 *_12 *_13 *_14 *_15 
  renpfix sl_rc w3_rc
  sort mergeid
  save "${OUTPATH}/${OUTSTUB}_rc.dta", replace

use "${INPATH}/${STUB}_rp", clear
  drop      *_11 *_12 *_13 *_14 *_15 *_16 *_17 *_18
  renpfix sl_rp w3_rp
  sort mergeid
  save "${OUTPATH}/${OUTSTUB}_rp.dta", replace

use "${INPATH}/${STUB}_st", clear
  renpfix sl_st w3_st
  sort mergeid
  save "${OUTPATH}/${OUTSTUB}_st.dta", replace



/* Spojeni modulu do jednou souburu podle mergeid */

use "${OUTPATH}/${OUTSTUB}_cs.dta", clear
merge mergeid using ///
 "${OUTPATH}/${OUTSTUB}_cv_r.dta" ///
 "${OUTPATH}/${OUTSTUB}_gl.dta" ///
 "${OUTPATH}/${OUTSTUB}_rc.dta" ///
 "${OUTPATH}/${OUTSTUB}_rp.dta" ///
 "${OUTPATH}/${OUTSTUB}_st.dta" 
drop if _merge==2
drop _merge*
sort mergeid

save "${OUTPATH}/w3_data.dta", replace