*Syntax spoji moduly ze vsech vln obsahujici informace o NUTS, ktere nasledne propoji do finalni promenne. Vysledny dataset je mozne pripojit na libovolnou vlnu.			
*Datove soubory:	"sharew5_rel1-0-0_gv_housing.sav"		(Centerdata - "Wave 5" - "All Generated Variables Modules Including Weights" - "spss" - "sharew5_rel1-0-0_all_gv_modules.zip")
		"sharew4_rel1-1-1_gv_housing.sav"		(Centerdata - "Wave 4" - "Generated Variables" - "Housing" - "spss" - "sharew4_rel1-1-1_gv_housing.zip")
		"sharew2_rel2-5-0_gv_housing.sav"		(Centerdata - "Wave 2" - "Generated Variables" - "Housing and Region" -"spss" - "sharew2_rel2-5-0_gv_housing.zip")
		*sharew1_rel2-6-0_gv_housing.sav"		(Centerdata - "Wave 1" - "Generated Variables" - "Housing and Region" -"spss" - "sharew1_rel2-6-0_gv_housing.zip")
			(+koment k w5 a w3)
		+libovolny soubor ke kterému se napojí..	
*Aktualizace 15.6.2015.			
			
			
*1. OTEVRENI GENEROVANYCH PROMENNYCH 5. VLNY, SELEKCE POTREBNYCH PROMENNYCH.			
GET 			
  FILE='C:\SHARE\sharew5_rel1-0-0_gv_housing.sav'. 			
DATASET NAME NUTS_fin WINDOW=front.			
set UNICODE=no.			
set locale='cs_CZ.windows-1250'.			
			
MATCH FILES FILE=*			
/KEEP= mergeid hhid5 country cvid cvidp nuts1_2010 nuts2_2010 nuts3_2010.			
exe.			
RENAME VARIABLES nuts1_2010=nuts1_w5.			
RENAME VARIABLES nuts2_2010=nuts2_w5.			
RENAME VARIABLES nuts3_2010=nuts3_w5.			
EXECUTE.			
			
ALTER TYPE nuts1_w5 (a30).			
alter type nuts2_w5 (a70).			
alter type nuts3_w5 (a50).			
			
alter type mergeid (a36).			
alter type hhid5 (a11).			
sort cases by mergeid.			
			
SAVE OUTFILE='C:\SHARE\share_NUTS_fin.sav' 			
  /COMPRESSED.			
			
*2. OTEVRENI GENEROVANYCH PROMENNYCH VLNY 4, SELEKCE A NASLEDNE NAPOJENI FINALNI DATASET.			
GET 			
  FILE='C:\SHARE\sharew4_rel1-1-1_gv_housing.sav'. 			
DATASET NAME NUTS_W4 WINDOW=front.			
			
MATCH FILES FILE=*			
/KEEP= mergeid hhid4 country cvid cvidp nuts1_2010 nuts2_2010 nuts3_2010.			
exe.			
			
RENAME VARIABLES nuts1_2010=nuts1_w4.			
RENAME VARIABLES nuts2_2010=nuts2_w4.			
RENAME VARIABLES nuts3_2010=nuts3_w4.			
EXECUTE.			
			
ALTER TYPE nuts1_w4 (a30).			
alter type nuts2_w4 (a70).			
alter type nuts3_w4 (a50).			
			
alter type mergeid (a36).			
alter type hhid4 (a11).			
			
SORT CASES BY mergeid.			
			
dataset activate NUTS_fin.			
DATASET ACTIVATE NUTS_fin.			
MATCH FILES /FILE=*			
  /FILE='NUTS_W4'			
  /RENAME (country cvid cvidp = d0 d1 d2) 			
  /BY mergeid			
  /DROP= d0 d1 d2.			
EXECUTE.			
			
*kontrola 85558 pripadu.			
FREQUENCIES VARIABLES=mergeid			
  /FORMAT=NOTABLE			
  /ORDER=ANALYSIS.			
			
dataset close nuts_w4.			
dataset activate nuts_fin.			
sort cases by mergeid.			
			
*3. OTEVRENI GENEROVANYCH PROMENNYCH VLNY 2, SELEKCE A NASLEDNE NAPOJENI FINALNI DATASET.			
GET 			
  FILE='C:\SHARE\sharew2_rel2-5-0_gv_housing.sav'. 			
DATASET NAME NUTS_W2 WINDOW=front.			
			
MATCH FILES FILE=*			
/KEEP= mergeid hhid2 country cvid  nuts1 nuts2 nuts3.			
exe.			
			
RENAME VARIABLES nuts1=nuts1_w2.			
RENAME VARIABLES nuts2=nuts2_w2.			
RENAME VARIABLES nuts3=nuts3_w2.			
EXECUTE.			
			
ALTER TYPE nuts1_w2 (a30).			
alter type nuts2_w2 (a70).			
alter type nuts3_w2 (a50).			
			
alter type mergeid (a36).			
alter type hhid2 (a11).			
			
SORT CASES BY mergeid.			
			
dataset activate NUTS_fin.			
DATASET ACTIVATE NUTS_fin.			
MATCH FILES /FILE=*			
  /FILE='NUTS_W2'			
  /RENAME (country cvid  = d0 d1 ) 			
  /BY mergeid			
  /DROP= d0 d1 .			
EXECUTE.			
			
*kontrola 100054 pripadu.			
FREQUENCIES VARIABLES=mergeid			
  /FORMAT=NOTABLE			
  /ORDER=ANALYSIS.			
			
dataset close nuts_w2.			
dataset activate nuts_fin.			
sort cases by mergeid.			
			
*4. OTEVRENI GENEROVANYCH PROMENNYCH VLNY 1, SELEKCE A NASLEDNE NAPOJENI FINALNI DATASET.			
GET 			
  FILE='C:\SHARE\sharew1_rel2-6-0_gv_housing.sav'. 			
DATASET NAME NUTS_W1 WINDOW=front.			
			
MATCH FILES FILE=*			
/KEEP= mergeid hhid1 country cvid  nuts1 nuts2 nuts3.			
exe.			
			
RENAME VARIABLES nuts1=nuts1_w1.			
RENAME VARIABLES nuts2=nuts2_w1.			
RENAME VARIABLES nuts3=nuts3_w1.			
EXECUTE.			
			
ALTER TYPE nuts1_w1 (a30).			
alter type nuts2_w1 (a70).			
alter type nuts3_w1 (a50).			
			
alter type mergeid (a36).			
alter type hhid1 (a11).			
			
SORT CASES BY mergeid.			
			
dataset activate NUTS_fin.			
DATASET ACTIVATE NUTS_fin.			
MATCH FILES /FILE=*			
  /FILE='NUTS_W1'			
  /RENAME (country cvid  = d0 d1 ) 			
  /BY mergeid			
  /DROP= d0 d1 .			
EXECUTE.			
			
FREQUENCIES VARIABLES=mergeid			
  /FORMAT=NOTABLE			
  /ORDER=ANALYSIS.			
*finalni vycisteni.			
SELECT IF not mergeid="".			
EXECUTE.			
*kontrola 108971 pripadu.			
FREQUENCIES VARIABLES=mergeid			
  /FORMAT=NOTABLE			
  /ORDER=ANALYSIS.			
			
dataset close nuts_w1.			
dataset activate nuts_fin.			
SAVE OUTFILE='C:\SHARE\share_NUTS_fin.sav' 			
  /COMPRESSED.			
			
*5. VYTVORENI FINALNICH PROMENNYCH NUTS.			
string nuts1_fin (a30).			
string nuts2_fin (a70).			
string nuts3_fin (a50).			
			
var lab nuts1_fin "NUTS level 1: nomenclature of territorial units for statistics".			
var lab nuts2_fin "NUTS level 2: nomenclature of territorial units for statistics".			
var lab nuts3_fin "NUTS level 3: nomenclature of territorial units for statistics".			
			
*vypocet finalnich NUTS promennych.			
compute nuts1_fin=nuts1_w4.			
if nuts1_fin="" and not nuts1_w2="" nuts1_fin=nuts1_w2.			
if nuts1_fin="" and not nuts1_w1="" nuts1_fin=nuts1_w1.			
if nuts1_fin="" and not nuts1_w5="" nuts1_fin=nuts1_w5.			
exe.			
			
compute nuts2_fin=nuts2_w4.			
if nuts2_fin="" and not nuts2_w2="" nuts2_fin=nuts2_w2.			
if nuts2_fin="" and not nuts2_w1="" nuts2_fin=nuts2_w1.			
if nuts2_fin="" and not nuts2_w5="" nuts2_fin=nuts2_w5.			
exe.			
			
compute nuts3_fin=nuts3_w4.			
if nuts3_fin="" and not nuts3_w2="" nuts3_fin=nuts3_w2.			
if nuts3_fin="" and not nuts3_w1="" nuts3_fin=nuts3_w1.			
if nuts3_fin="" and not nuts3_w5="" nuts3_fin=nuts3_w5.			
exe.			
			
fre nuts1_fin nuts2_fin nuts3_fin.			
* bohuzel prvni vydani generovanych dat 5. vlny obsahuje jednak netisknutelne znaky a jednak velke mnozstvi missing values. Z toho duvodu			
je v promennych "nuts1_fin" 12 % missing, "nuts2_fin" 22 % missing a v "nuts3_fin" 58 %. (U "nuts3_fin" vysoky pocet missing valuues take dan			
admistrativnim clenenim daneho statu - podrobne cleneni na nuts3 nebylo pro vyberove setreni pouzito.)			
			
*6. FINALNI UPRAVA DATOVEHO SOUBORU - SELEKCE PROMENNYCH.			
STRING hhid_fin (A11).			
compute hhid_fin=hhid5.			
if hhid_fin="" and not hhid4="" hhid_fin=hhid4.			
if hhid_fin="" and not hhid2="" hhid_fin=hhid2.			
if hhid_fin="" and not hhid1="" hhid_fin=hhid1.			
exe.			
			
MATCH FILES /FILE=*			
  /KEEP= mergeid hhid_fin  nuts1_fin nuts2_fin nuts3_fin.			
exe.			
sort cases by mergeid.			
SAVE OUTFILE='C:\SHARE\share_NUTS_fin.sav' 			
  /COMPRESSED.			
			
*7. MOZNOST VYTVORENI AGREGOVANEHO DATOVEHO SOUBORU s NUTS (jednotkou domacnost).			
SORT CASES BY hhid_fin(A) nuts1_fin. 			
DATASET DECLARE hh. 			
AGGREGATE 			
  /OUTFILE='hh' 			
  /BREAK=hhid_fin			
  /nuts1_FIN_last=last(nuts1_FIN) 			
  /nuts2_FIN_last=last(nuts2_FIN) 			
  /nuts3_FIN_last=last(nuts3_FIN).			
			
dataset activate hh.			
RENAME VARIABLES nuts1_fin_last=nuts1_fin.			
RENAME VARIABLES nuts2_fin_last=nuts2_fin.			
RENAME VARIABLES nuts3_fin_last=nuts3_fin.			
EXECUTE.			
			
SAVE OUTFILE='C:\SHARE\share_NUTS_fin_HH.sav' 			
  /COMPRESSED.