*PØÍPRAVA:
* 1) registrace na stránkách SHARE: http://www.share-project.org/data-access-documentation/research-data-center-data-access.html
* 2) po získání uživatelského jména a hesla pøihlášení na SHARE Research Data Center http://cdata28.uvt.nl/sharedatadissemination/users/login
* 3) na zaèátku analýzy je dùležité si promyslet, jakou informaci chceme z dat získat: 
	- jaké je téma našeho analytického problému - tomu pøizpùsobíme výbìr modulù 
	- co bude naše základní jednotka (respondent, domácnost), zda chceme analyzovat jednotlivou vlnu anebo porovnat vlny mezi sebou - podle toho spustíme váhy 

*PROVEDENÍ: pøíklad - základní jednotka: respondent, VLNA 2, moduly AC (aktivity), CS (test vstávání), DN (demografie) a PH (fyzické zdraví).
* 4) stáhnout si potøebné moduly vlny 2 + covescreenový dotazník CV_R a váhy WEIGHTS
* 5) základním datasetem bude CV_R, ze kterého odstraníme osoby, které nebyly dotazovány v hlavním dotazníku, a pøejmenujeme promìnné (pøidáme pøíponu "w2")
* 6) k CV_R postupnì pøipojíme upravené ostatní moduly (bez duplicitních promìnných, s pøejmenovanými promìnnými), a to podle jedineèného "mergeid"
* 7) nakonec pøipojíme váhy.

GET
  FILE='C:\C:\Documents and Settings\pc\Plocha\sharew2_rel2-5-0_cv_r.sav'.
DATASET NAME cv_r WINDOW=FRONT.

*vymazání osob, které nebyly dotazovány v hlavním dotazníku.
USE ALL. 
SELECT IF (not (mergeid="no int w.2")). 
EXECUTE.

ren var (hhid1=hhid1w2).
ren var (hhid2=hhid2w2).
ren var (country=countryw2).
ren var (waveid=waveidw2).
ren var (split=splitw2).
ren var (language=languagew2).
ren var (cvid=cvidw2).
ren var (gender=genderw2).
ren var (mobirth=mobirthw2).
ren var (yrbirth=yrbirthw2).
ren var (ageind=ageindw2).
ren var (mstat=mstatw2).
ren var (cvidp=cvidpw2).
ren var (relrpers=relrpersw2).
ren var (hhsize=hhsizew2).
ren var (dumfamr=dumfamrw2).
ren var (dumfinr=dumfinrw2).
ren var (dumhhr=dumhhrw2).
ren var (int_year_w2=int_yearw2).
ren var (int_month_w2=int_monthw2).
exe.
SORT CASES by mergeid.

GET
  FILE='C:\Documents and Settings\pc\Plocha\sharew2_rel2-5-0_ac.sav'.
DATASET NAME ac WINDOW=FRONT.
*vymazání duplicitních promìnných.
del var hhid hhid1 hhid2 country waveid split language cvid.

ren var (ac002d1=ac002d1w2).
ren var (ac002d2=ac002d2w2).
ren var (ac002d3=ac002d3w2).
ren var (ac002d4=ac002d4w2).
ren var (ac002d5=ac002d5w2).
ren var (ac002d6=ac002d6w2).
ren var (ac002d7=ac002d7w2).
ren var (ac002dno=ac002dnow2).
ren var (ac003_1=ac003_1w2).
ren var (ac003_2=ac003_2w2).
ren var (ac003_3=ac003_3w2).
ren var (ac003_4=ac003_4w2).
ren var (ac003_5=ac003_5w2).
ren var (ac003_6=ac003_6w2).
ren var (ac003_7=ac003_7w2).
ren var (ac004d1_1=ac004d1_1w2).
ren var (ac004d2_1=ac004d2_1w2).
ren var (ac004d4_1=ac004d4_1w2).
ren var (ac004d5_1=ac004d5_1w2).
ren var (ac004d7_1=ac004d7_1w2).
ren var (ac004dno_1=ac004dno_1w2).
ren var (ac004d1_2=ac004d1_2w2).
ren var (ac004d2_2=ac004d2_2w2).
ren var (ac004d4_2=ac004d4_2w2).
ren var (ac004d5_2=ac004d5_2w2).
ren var (ac004d7_2=ac004d7_2w2).
ren var (ac004dno_2=ac004dno_2w2).
ren var (ac004d1_3=ac004d1_3w2).
ren var (ac004d2_3=ac004d2_3w2).
ren var (ac004d4_3=ac004d4_3w2).
ren var (ac004d5_3=ac004d5_3w2).
ren var (ac004d7_3=ac004d7_3w2).
ren var (ac004dno_3=ac004dno_3w2).
ren var (ac004d1_4=ac004d1_4w2).
ren var (ac004d2_4=ac004d2_4w2).
ren var (ac004d4_4=ac004d4_4w2).
ren var (ac004d5_4=ac004d5_4w2).
ren var (ac004d7_4=ac004d7_4w2).
ren var (ac004dno_4=ac004dno_4w2).
ren var (ac004d1_5=ac004d1_5w2).
ren var (ac004d2_5=ac004d2_5w2).
ren var (ac004d4_5=ac004d4_5w2).
ren var (ac004d5_5=ac004d5_5w2).
ren var (ac004d7_5=ac004d7_5w2).
ren var (ac004dno_5=ac004dno_5w2).
ren var (ac004d1_6=ac004d1_6w2).
ren var (ac004d2_6=ac004d2_6w2).
ren var (ac004d4_6=ac004d4_6w2).
ren var (ac004d5_6=ac004d5_6w2).
ren var (ac004d7_6=ac004d7_6w2).
ren var (ac004dno_6=ac004dno_6w2).
ren var (ac004d1_7=ac004d1_7w2).
ren var (ac004d2_7=ac004d2_7w2).
ren var (ac004d4_7=ac004d4_7w2).
ren var (ac004d5_7=ac004d5_7w2).
ren var (ac004d7_7=ac004d7_7w2).
ren var (ac004dno_7=ac004dno_7w2).
ren var (ac006_1=ac006_1w2).
ren var (ac006_2=ac006_2w2).
ren var (ac006_3=ac006_3w2).
ren var (ac007_1=ac007_1w2).
ren var (ac007_2=ac007_2w2).
ren var (ac007_3=ac007_3w2).
ren var (ac011_=ac011_w2).
ren var (ac012_=ac012_w2).
ren var (ac013_=ac013_w2).
ren var (ac014_=ac014_w2).
ren var (ac015_=ac015_w2).
ren var (ac016_=ac016_w2).
ren var (ac017_=ac017_w2).
ren var (ac018_=ac018_w2).
ren var (ac019_=ac019_w2).
ren var (ac020_=ac020_w2).
ren var (ac021_=ac021_w2).
ren var (ac022_=ac022_w2).
ren var (ac023_=ac023_w2).
ren var (ac024_=ac024_w2).
ren var (ac025_=ac025_w2).
ren var (ac026_=ac026_w2).
ren var (ac027_=ac027_w2).
ren var (ac028_=ac028_w2).
ren var (ac029_=ac029_w2).
ren var (ac030_=ac030_w2).
ren var (ac031_=ac031_w2).
ren var (ac032_=ac032_w2).
ren var (ac033_=ac033_w2).
ren var (ac034_=ac034_w2).
exe.

sort cases by mergeid.

DATASET ACTIVATE cv_r.
MATCH FILES /FILE=*
  /FILE='ac'
  /BY mergeid.
EXECUTE.

dataset close ac.

GET
  FILE='C:\Documents and Settings\pc\Plocha\sharew2_rel2-5-0_cs.sav'.
DATASET NAME cs WINDOW=FRONT.
del var hhid hhid1 hhid2 country waveid split language cvid.

ren var (cs002_=cs002_w2).
ren var (cs004_=cs004_w2).
ren var (cs005d1=cs005d1w2).
ren var (cs005d2=cs005d2w2).
ren var (cs005d3=cs005d3w2).
ren var (cs005d4=cs005d4w2).
ren var (cs005d5=cs005d5w2).
ren var (cs005d6=cs005d6w2).
ren var (cs005dot=cs005dotw2).
ren var (cs007_=cs007_w2).
ren var (cs008_=cs008_w2).
ren var (cs009d1=cs009d1w2).
ren var (cs009d2=cs009d2w2).
ren var (cs009d3=cs009d3w2).
ren var (cs009d4=cs009d4w2).
ren var (cs009d5=cs009d5w2).
ren var (cs009d6=cs009d6w2).
ren var (cs009dot=cs009dotw2).
ren var (cs011_=cs011_w2).
exe.

sort cases by mergeid.


DATASET ACTIVATE cv_r.
MATCH FILES /FILE=*
  /FILE='cs'
  /BY mergeid.
EXECUTE.

dataset close cs.


GET
  FILE='C:\Documents and Settings\pc\Plocha\sharew2_rel2-5-0_dn.sav'.
DATASET NAME dn WINDOW=FRONT.
del var hhid hhid1 hhid2 country waveid split language cvid.

ren var (dn002_=dn002_w2).
ren var (dn003_=dn003_w2).
ren var (dn004_=dn004_w2).
ren var (dn005c=dn005cw2).
ren var (dn006_=dn006_w2).
ren var (dn007_=dn007_w2).
ren var (dn008c=dn008cw2).
ren var (dn009_=dn009_w2).
ren var (dn010_=dn010_w2).
ren var (dn012d1=dn012d1w2).
ren var (dn012d2=dn012d2w2).
ren var (dn012d3=dn012d3w2).
ren var (dn012d4=dn012d4w2).
ren var (dn012d5=dn012d5w2).
ren var (dn012d6=dn012d6w2).
ren var (dn012d7=dn012d7w2).
ren var (dn012d8=dn012d8w2).
ren var (dn012d9=dn012d9w2).
ren var (dn012d10=dn012d10w2).
ren var (dn012d11=dn012d11w2).
ren var (dn012d12=dn012d12w2).
ren var (dn012d13=dn012d13w2).
ren var (dn012d14=dn012d14w2).
ren var (dn012d95=dn012d95w2).
ren var (dn012dno=dn012dnow2).
ren var (dn012dot=dn012dotw2).
ren var (dn014_=dn014_w2).
ren var (dn015_=dn015_w2).
ren var (dn016_=dn016_w2).
ren var (dn017_=dn017_w2).
ren var (dn018_=dn018_w2).
ren var (dn019_=dn019_w2).
ren var (dn020_=dn020_w2).
ren var (dn021_=dn021_w2).
ren var (dn023d1=dn023d1w2).
ren var (dn023d2=dn023d2w2).
ren var (dn023d3=dn023d3w2).
ren var (dn023d4=dn023d4w2).
ren var (dn023d5=dn023d5w2).
ren var (dn023d6=dn023d6w2).
ren var (dn023d7=dn023d7w2).
ren var (dn023d8=dn023d8w2).
ren var (dn023d9=dn023d9w2).
ren var (dn023d10=dn023d10w2).
ren var (dn023d11=dn023d11w2).
ren var (dn023d12=dn023d12w2).
ren var (dn023d13=dn023d13w2).
ren var (dn023d14=dn023d14w2).
ren var (dn023d95=dn023d95w2).
ren var (dn023dno=dn023dnow2).
ren var (dn023dot=dn023dotw2).
ren var (dn026_1=dn026_1w2).
ren var (dn026_2=dn026_2w2).
ren var (dn027_1=dn027_1w2).
ren var (dn027_2=dn027_2w2).
ren var (dn028_1=dn028_1w2).
ren var (dn028_2=dn028_2w2).
ren var (dn030_1=dn030_1w2).
ren var (dn030_2=dn030_2w2).
ren var (dn032_1=dn032_1w2).
ren var (dn032_2=dn032_2w2).
ren var (dn033_1=dn033_1w2).
ren var (dn033_2=dn033_2w2).
ren var (dn034_=dn034_w2).
ren var (dn035_=dn035_w2).
ren var (dn036_=dn036_w2).
ren var (dn037_=dn037_w2).
ren var (dn038_=dn038_w2).
ren var (dn040_=dn040_w2).
ren var (dn041_=dn041_w2).
ren var (dn041_raw=dn041_raww2).
ren var (dn042_=dn042_w2).
ren var (dn043_=dn043_w2).
ren var (dn044_=dn044_w2).
ren var (mn101_=mn101_w2).
exe.

sort cases by mergeid.

DATASET ACTIVATE cv_r.
MATCH FILES /FILE=*
  /FILE='dn'
  /BY mergeid.
EXECUTE.

dataset close dn.



GET
  FILE='C:\Documents and Settings\pc\Plocha\sharew2_rel2-5-0_ph.sav'.
DATASET NAME ph WINDOW=FRONT.
del var hhid hhid1 hhid2 country waveid split language cvid.

ren var (ph003_=ph003_w2).
ren var (ph004_=ph004_w2).
ren var (ph005_=ph005_w2).
ren var (ph006d1=ph006d1w2).
ren var (ph006d2=ph006d2w2).
ren var (ph006d3=ph006d3w2).
ren var (ph006d4=ph006d4w2).
ren var (ph006d5=ph006d5w2).
ren var (ph006d6=ph006d6w2).
ren var (ph006d7=ph006d7w2).
ren var (ph006d8=ph006d8w2).
ren var (ph006d9=ph006d9w2).
ren var (ph006d10=ph006d10w2).
ren var (ph006d11=ph006d11w2).
ren var (ph006d12=ph006d12w2).
ren var (ph006d13=ph006d13w2).
ren var (ph006d14=ph006d14w2).
ren var (ph006d15=ph006d15w2).
ren var (ph006d16=ph006d16w2).
ren var (ph006d17=ph006d17w2).
ren var (ph006dno=ph006dnow2).
ren var (ph006dot=ph006dotw2).
ren var (ph008d1=ph008d1w2).
ren var (ph008d2=ph008d2w2).
ren var (ph008d3=ph008d3w2).
ren var (ph008d4=ph008d4w2).
ren var (ph008d5=ph008d5w2).
ren var (ph008d6=ph008d6w2).
ren var (ph008d7=ph008d7w2).
ren var (ph008d8=ph008d8w2).
ren var (ph008d9=ph008d9w2).
ren var (ph008d10=ph008d10w2).
ren var (ph008d11=ph008d11w2).
ren var (ph008d12=ph008d12w2).
ren var (ph008d13=ph008d13w2).
ren var (ph008d14=ph008d14w2).
ren var (ph008d15=ph008d15w2).
ren var (ph008d16=ph008d16w2).
ren var (ph008d17=ph008d17w2).
ren var (ph008d18=ph008d18w2).
ren var (ph008d19=ph008d19w2).
ren var (ph008d20=ph008d20w2).
ren var (ph008d21=ph008d21w2).
ren var (ph008d22=ph008d22w2).
ren var (ph008dot=ph008dotw2).
ren var (ph009_1=ph009_1w2).
ren var (ph009_2=ph009_2w2).
ren var (ph009_3=ph009_3w2).
ren var (ph009_4=ph009_4w2).
ren var (ph009_5=ph009_5w2).
ren var (ph009_6=ph009_6w2).
ren var (ph009_7=ph009_7w2).
ren var (ph009_8=ph009_8w2).
ren var (ph009_9=ph009_9w2).
ren var (ph009_10=ph009_10w2).
ren var (ph009_11=ph009_11w2).
ren var (ph009_12=ph009_12w2).
ren var (ph009_13=ph009_13w2).
ren var (ph009_14=ph009_14w2).
ren var (ph009_16=ph009_16w2).
ren var (ph010d1=ph010d1w2).
ren var (ph010d2=ph010d2w2).
ren var (ph010d3=ph010d3w2).
ren var (ph010d4=ph010d4w2).
ren var (ph010d5=ph010d5w2).
ren var (ph010d6=ph010d6w2).
ren var (ph010d7=ph010d7w2).
ren var (ph010d8=ph010d8w2).
ren var (ph010d9=ph010d9w2).
ren var (ph010d10=ph010d10w2).
ren var (ph010d11=ph010d11w2).
ren var (ph010d12=ph010d12w2).
ren var (ph010dno=ph010dnow2).
ren var (ph010dot=ph010dotw2).
ren var (ph011d1=ph011d1w2).
ren var (ph011d2=ph011d2w2).
ren var (ph011d3=ph011d3w2).
ren var (ph011d4=ph011d4w2).
ren var (ph011d5=ph011d5w2).
ren var (ph011d6=ph011d6w2).
ren var (ph011d7=ph011d7w2).
ren var (ph011d8=ph011d8w2).
ren var (ph011d9=ph011d9w2).
ren var (ph011d10=ph011d10w2).
ren var (ph011d11=ph011d11w2).
ren var (ph011d12=ph011d12w2).
ren var (ph011d13=ph011d13w2).
ren var (ph011d14=ph011d14w2).
ren var (ph011dno=ph011dnow2).
ren var (ph011dot=ph011dotw2).
ren var (ph012_=ph012_w2).
ren var (ph013_=ph013_w2).
ren var (ph024_=ph024_w2).
ren var (ph025_=ph025_w2).
ren var (ph041_=ph041_w2).
ren var (ph043_=ph043_w2).
ren var (ph044_=ph044_w2).
ren var (ph045_=ph045_w2).
ren var (ph046_=ph046_w2).
ren var (ph047_=ph047_w2).
ren var (ph048d1=ph048d1w2).
ren var (ph048d2=ph048d2w2).
ren var (ph048d3=ph048d3w2).
ren var (ph048d4=ph048d4w2).
ren var (ph048d5=ph048d5w2).
ren var (ph048d6=ph048d6w2).
ren var (ph048d7=ph048d7w2).
ren var (ph048d8=ph048d8w2).
ren var (ph048d9=ph048d9w2).
ren var (ph048d10=ph048d10w2).
ren var (ph048dno=ph048dnow2).
ren var (ph049d1=ph049d1w2).
ren var (ph049d2=ph049d2w2).
ren var (ph049d3=ph049d3w2).
ren var (ph049d4=ph049d4w2).
ren var (ph049d5=ph049d5w2).
ren var (ph049d6=ph049d6w2).
ren var (ph049d7=ph049d7w2).
ren var (ph049d8=ph049d8w2).
ren var (ph049d9=ph049d9w2).
ren var (ph049d10=ph049d10w2).
ren var (ph049d11=ph049d11w2).
ren var (ph049d12=ph049d12w2).
ren var (ph049d13=ph049d13w2).
ren var (ph049dno=ph049dnow2).
ren var (ph050_=ph050_w2).
ren var (ph051_=ph051_w2).
ren var (ph054_=ph054_w2).
ren var (ph056_=ph056_w2).
ren var (ph059d1=ph059d1w2).
ren var (ph059d2=ph059d2w2).
ren var (ph059d3=ph059d3w2).
ren var (ph059d4=ph059d4w2).
ren var (ph059d5=ph059d5w2).
ren var (ph059d6=ph059d6w2).
ren var (ph059d7=ph059d7w2).
ren var (ph059dno=ph059dnow2).
ren var (ph060_=ph060_w2).
ren var (ph061_=ph061_w2).
ren var (ph062_=ph062_w2).
ren var (ph063_=ph063_w2).
ren var (ph064_=ph064_w2).
ren var (ph065_=ph065_w2).
ren var (ph066_=ph066_w2).
ren var (ph067_1=ph067_1w2).
ren var (ph067_2=ph067_2w2).
ren var (ph067_3=ph067_3w2).
ren var (ph067_4=ph067_4w2).
ren var (ph068_1=ph068_1w2).
ren var (ph068_2=ph068_2w2).
ren var (ph068_3=ph068_3w2).
ren var (ph068_4=ph068_4w2).
ren var (ph069_1=ph069_1w2).
ren var (ph069_2=ph069_2w2).
ren var (ph069_3=ph069_3w2).
ren var (ph069_4=ph069_4w2).
ren var (ph071_1=ph071_1w2).
ren var (ph071_2=ph071_2w2).
ren var (ph071_3=ph071_3w2).
ren var (ph071_4=ph071_4w2).
exe.

sort cases by mergeid.

DATASET ACTIVATE cv_r.
MATCH FILES /FILE=*
  /FILE='ph'
  /BY mergeid.
EXECUTE.

dataset close ph.

GET
  FILE='C:\Documents and Settings\pc\Plocha\sharew2_rel2-5-0_weights.sav'.
DATASET NAME weights WINDOW=FRONT.
match files /file=*
  /keep=mergeid w2mch.
sort cases by mergeid.

DATASET ACTIVATE cv_r.
MATCH FILES /FILE=*
  /FILE='weights'
  /BY mergeid.
EXECUTE.

dataset close weights.
dataset activate cv_r.
WEIGHT by w2mch.


*závìreèné uložení.
SAVE OUTFILE='C:\Documents and Settings\pc\Plocha\sharew2_cv-r_ac_cs_dn_ph_w.sav'
  /COMPRESSED.