*------------------------------------------------------------------------------------------------------------------------------. * EU-Labour Force Survey - Data Service - German Microdata Lab * * This routine converts EU-LFS 2006-2008 YEARLY data formatted in CSV into SAV. * Checked for the December 2012 release of the EU-LFS, as provided by Eurostat. * * The whole routine consists of two files: * Setup_EULFS_2006-2008_y.sps * Labels_EULFS_1983-2011.sps * * Version 1 of the routine, March 2013 * IBM SPSS Statistics 21.0 * (c) GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Andrea Lengerer * http://www.gesis.org/en/institute/ * Contact: gml@gesis.org * * This SPSS code is protected under the creative commons licence. * *------------------------------------------------------------------------------------------------------------------------------. * CONFIGURATION. * Line 55: Change CSV_DATA_PATH to the path where the csv files are stored (e.g. E:\data\EU-LFS\csv\). * Line 447: Change LABEL_SYNTAX_PATH to the path where the file "Labels_EULFS_1983-2011.sps" is stored (e.g. E:\data\EU-LFS\syntax\). * Line 452: Change SPSS_DATA_PATH to the path where you want the sav files to be stored (e.g. E:\data\EU-LFS\sav\). * Line 469: Change FILENAMES to a list of files you want to convert from csv to sav (without file extension, e.g. dk2006_y gr2007_y be2008_y). *--------------------------------------------- Start Definition Macro ---------------------------------------------. DEFINE !readmac (datfile=!CHAREND('%')). !DO !i !IN (!datfile). *--- Read Raw Data ---. GET DATA / TYPE=TXT / FILE=!QUOTE(!CONCAT('CSV_DATA_PATH',!i,'.csv')) / DELCASE=LINE / DELIMITERS="," / ARRANGEMENT=DELIMITED / FIRSTCASE=2 / IMPORTCASE=ALL / VARIABLES= QHHNUM A9 COEFF COMMA9.7 QUARTER A2 HHNUM A9 REC F8.0 HHSEQNUM F2.0 REFYEAR F4.0 REFWEEK F2.0 INTWEEK F2.0 COUNTRY_ A2 REGION A2 DEGURBA F2.0 HHTYPE F2.0 HHINST F2.0 INTWAVE F2.0 INTQUEST F2.0 REM F8.0 YEAR F4.0 HHPRIV F2.0 HHLINK F2.0 HHSPOU F2.0 HHFATH F2.0 HHMOTH F2.0 SEX F2.0 AGE F2.0 MARSTAT F2.0 NATIONAL_ A3 YEARESID_ A5 COUNTRYB_ A3 PROXY F2.0 WSTATOR F2.0 NOWKREAS F2.0 STAPRO F2.0 SIGNISAL F2.0 SUPVISOR F2.0 SIZEFIRM F2.0 COUNTRYW_ A2 REGIONW A2 YSTARTWK F4.0 MSTARTWK F2.0 WAYJFOUN F2.0 FTPT F2.0 FTPTREAS F2.0 TEMP F2.0 TEMPREAS F2.0 TEMPDUR F2.0 TEMPAGCY F2.0 SHIFTWK F2.0 EVENWK F2.0 NIGHTWK F2.0 SATWK F2.0 SUNWK F2.0 HWUSUAL F8.0 HWACTUAL F8.0 HWOVERP F8.0 HWOVERPU F8.0 HOURREAS F2.0 WISHMORE F2.0 WAYMORE F2.0 HWWISH F8.0 HOMEWK F2.0 LOOKOJ F2.0 LOOKREAS F2.0 EXIST2J F2.0 STAPRO2J F2.0 HWACTUA2 F8.0 EXISTPR F2.0 YEARPR F4.0 MONTHPR F2.0 LEAVREAS F2.0 STAPROPR F2.0 ISCOPR3D F3.0 SEEKWORK F2.0 SEEKREAS F2.0 SEEKTYPE F2.0 SEEKDUR F2.0 METHODA F2.0 METHODB F2.0 METHODC F2.0 METHODD F2.0 METHODE F2.0 METHODF F2.0 METHODG F2.0 METHODH F2.0 METHODI F2.0 METHODJ F2.0 METHODK F2.0 METHODL F2.0 METHODM F2.0 WANTWORK F2.0 AVAILBLE F2.0 AVAIREAS F2.0 PRESEEK F2.0 NEEDCARE F2.0 REGISTER F2.0 MAINSTAT F2.0 EDUCSTAT F2.0 EDUCLEVL F2.0 EDUCFILD F3.0 COURATT F2.0 COURLEN F3.0 COURPURP F2.0 COURFILD F3.0 COURWORH F2.0 HATLEVEL F2.0 HATFIELD F3.0 HATYEAR F4.0 WSTAT1Y F2.0 STAPRO1Y F2.0 NA111Y1D_ A1 COUNTR1Y_ A2 REGION1Y A2 ILOSTAT F2.0 NA111D_ A1 NA11S F2.0 ISCO1D F2.0 NA112J1D_ A1 NA112JS F2.0 NA11PR1D_ A1 NA11PRS F2.0 ISCOPR1D F2.0 DURUNE F2.0 EDUC4WN F2.0 HATLEV1D_ A1 NA111YS F2.0 METHFW F2.0 LENTR4W F2.0 PURP4W F2.0 HWUSTRAI F8.0 ISCO3D F3.0 STARTIME F8.0 LEAVTIME F8.0 LEAVCLAS F2.0 INCDECIL F2.0 NACE1D_ A1 NACE1Y1D_ A1 NACE2J1D_ A1 NACEPR1D_ A1 AGERESID F2.0 HHCHILDR F2.0 HHWKSTAT F2.0 HHPARTNR F2.0 HHPARENT F2.0 HHCOMP F2.0 HATLFATH_ A1 HATLMOTH_ A1 HHNBCHLD F2.0 HHNB0014 F2.0 HHNBCH2 F2.0 HHNBCH5 F2.0 HHNBCH8 F2.0 HHNBCH11 F2.0 HHNBCH14 F2.0 HHNBCH17 F2.0 HHNBCH24 F2.0 HHNBPERS F2.0 HHNBEMPL F2.0 HHNBINAC F2.0 HHNBUNEM F2.0 HHNBWORK F2.0 HHAGEYG F2.0 HHAGE14 F2.0 HHNBOLD F2.0 HHPERS F2.0. EXECUTE. *--- Add Release-Variable ---. STRING RELEASE (A8). RECODE RELEASE (ELSE='DEC 2012'). *--- Recode Alphanumeric Variables ---. * Variables which remain alphanumeric: HHNUM and QHHNUM (too many values); QUARTER (only one value); REGION, REGIONW and REGION1Y (values have country-specific meaning). RECODE COUNTRY_ ('AT'=1) ('BE'=2) ('BG'=3) ('CH'=4) ('CY'=5) ('CZ'=6) ('DE'=7) ('DK'=8) ('EE'=9) ('ES'=10) ('FI'=11) ('FR'=12) ('GR'=13) ('HU'=14) ('IE'=15) ('IS'=16) ('IT'=17) ('LT'=18) ('LU'=19) ('LV'=20) ('MT'=21) ('NL'=22) ('NO'=23) ('PL'=24) ('PT'=25) ('RO'=26) ('SE'=27) ('SI'=28) ('SK'=29) ('UK'=30) INTO COUNTRY. RECODE COUNTRYB_ ('000'=0) ('001'=1) ('002'=2) ('003'=3) ('004'=4) ('005'=5) ('006'=6) ('007'=7) ('008'=8) ('009'=9) ('010'=10) ('011'=11) ('012'=12) ('013'=13) ('014'=14) ('015'=15) ('016'=16) ('017'=17) ('018'=18) ('019'=19) ('020'=20) ('021'=21) ('NO'=-1) INTO COUNTRYB. RECODE NATIONAL_ ('000'=0) ('001'=1) ('002'=2) ('003'=3) ('004'=4) ('005'=5) ('006'=6) ('007'=7) ('008'=8) ('009'=9) ('010'=10) ('011'=11) ('012'=12) ('013'=13) ('014'=14) ('015'=15) ('016'=16) ('017'=17) ('018'=18) ('019'=19) ('020'=20) ('021'=21) ('NO'=-1) INTO NATIONAL. RECODE NA111Y1D_ NA111D_ NA112J1D_ NA11PR1D_ ('A'=1) ('B'=2) ('C'=3) ('D'=4) ('E'=5) ('F'=6) ('G'=7) ('H'=8) ('I'=9) ('J'=10) ('K'=11) ('L'=12) ('M'=13) ('N'=14) ('O'=15) ('P'=16) ('Q'=17) (' '=-1) ('9'=-2) INTO NA111Y1D NA111D NA112J1D NA11PR1D. RECODE HATLEV1D_ HATLFATH_ HATLMOTH_ ('L'=1) ('M'=2) ('H'=3) ('9'=-2) ('8'=8) (' '=-1) INTO HATLEV1D HATLFATH HATLMOTH. RECODE NACE1D_ NACE1Y1D_ NACE2J1D_ NACEPR1D_ ('A'=1) ('B'=2) ('C'=3) ('D'=4) ('E'=5) ('F'=6) ('G'=7) ('H'=8) ('I'=9) ('J'=10) ('K'=11) ('L'=12) ('M'=13) ('N'=14) ('O'=15) ('P'=16) ('Q'=17) ('R'=18) ('S'=19) ('T'=20) ('U'=21) (' '=-1) ('9'=-2) INTO NACE1D NACE1Y1D NACE2J1D NACEPR1D. RECODE COUNTRYW_ COUNTR1Y_ ('AD'=01) ('AL'=02) ('AT'=03) ('BA'=04) ('BE'=05) ('BG'=06) ('BY'=07) ('CH'=08) ('CY'=09) ('CZ'=10) ('DE'=11) ('DK'=12) ('EE'=13) ('GR'=14) ('ES'=15) ('FI'=16) ('FO'=17) ('FR'=18) ('GG'=19) ('GI'=20) ('HR'=21) ('HU'=22) ('IE'=23) ('IM'=24) ('IS'=25) ('IT'=26) ('JE'=27) ('LI'=28) ('LT'=29) ('LU'=30) ('LV'=31) ('MC'=32) ('MD'=33) ('ME'=34) ('XM'=34) ('MK'=35) ('MT'=36) ('NL'=37) ('NO'=38) ('PL'=39) ('PT'=40) ('RO'=41) ('RS'=42) ('XS'=42) ('RU'=43) ('SE'=44) ('SI'=45) ('SK'=46) ('SM'=47) ('TR'=48) ('UA'=49) ('UK'=50) ('VA'=51) ('XK'=52) ('CS'=60) ('SU'=61) ('YU'=62) ('NN'=90) ('01'=110) ('02'=120) ('03'=130) ('04'=140) ('15'=150) ('05'=0500) ('DZ'=0501) ('EG'=0502) ('LY'=0503) ('MA'=0504) ('TN'=0505) ('06'=0600) ('AO'=0601) ('BF'=0602) ('BI'=0603) ('BJ'=0604) ('BW'=0605) ('CD'=0606) ('CF'=0607) ('CG'=0608) ('CI'=0609) ('CM'=0610) ('CV'=0611) ('DJ'=0612) ('ER'=0613) ('ET'=0614) ('GA'=0615) ('GH'=0616) ('GM'=0617) ('GN'=0618) ('GQ'=0619) ('GW'=0620) ('KE'=0621) ('KM'=0622) ('LR'=0623) ('LS'=0624) ('MG'=0625) ('ML'=0626) ('MR'=0627) ('MU'=0628) ('MW'=0629) ('MZ'=0630) ('NA'=0631) ('NE'=0632) ('NG'=0633) ('RW'=0634) ('SC'=0635) ('SD'=0636) ('SH'=0637) ('SL'=0638) ('SN'=0639) ('SO'=0640) ('ST'=0642) ('SZ'=0643) ('TD'=0644) ('TG'=0645) ('TZ'=0646) ('UG'=0647) ('YT'=0648) ('ZA'=0649) ('ZM'=0650) ('ZW'=0651) ('07'=0700) ('BM'=0701) ('CA'=0702) ('GL'=0703) ('PM'=0704) ('US'=0705) ('08'=0800) ('AG'=0801) ('AI'=0802) ('AN'=0803) ('AW'=0804) ('BB'=0805) ('BL'=0806) ('BS'=0807) ('BZ'=0808) ('CR'=0809) ('CU'=0810) ('DM'=0811) ('DO'=0812) ('GD'=0813) ('GT'=0814) ('HN'=0815) ('HT'=0816) ('JM'=0817) ('KN'=0818) ('KY'=0819) ('LC'=0820) ('MF'=0821) ('MS'=0822) ('MX'=0823) ('NI'=0824) ('PA'=0825) ('PR'=0826) ('SV'=0827) ('TC'=0828) ('TT'=0829) ('VC'=0830) ('VG'=0831) ('09'=0900) ('AR'=0901) ('BO'=0902) ('BR'=0903) ('CL'=0904) ('CO'=0905) ('EC'=0906) ('FK'=0907) ('GY'=0908) ('PE'=0909) ('PY'=0910) ('SR'=0911) ('TF'=0912) ('UY'=0913) ('VE'=0914) ('10'=1000) ('CN'=1001) ('JP'=1002) ('KP'=1003) ('KR'=1004) ('MN'=1005) ('TW'=1006) ('11'=1100) ('AE'=1101) ('AM'=1102) ('AZ'=1103) ('BH'=1104) ('GE'=1105) ('IL'=1106) ('IQ'=1107) ('IR'=1108) ('JO'=1109) ('KG'=1110) ('KW'=1111) ('KZ'=1112) ('LB'=1113) ('OM'=1114) ('PS'=1115) ('QA'=1116) ('SA'=1117) ('SY'=1118) ('TJ'=1119) ('TM'=1120) ('UZ'=1121) ('YE'=1122) ('12'=1200) ('AF'=1201) ('BD'=1202) ('BN'=1203) ('BT'=1204) ('ID'=1205) ('IN'=1206) ('KH'=1207) ('LA'=1208) ('LK'=1209) ('MM'=1210) ('MV'=1211) ('MY'=1212) ('NP'=1213) ('PH'=1214) ('PK'=1215) ('SG'=1216) ('TH'=1217) ('TL'=1218) ('VN'=1219) ('13'=1300) ('AU'=1301) ('FJ'=1302) ('FM'=1303) ('KI'=1304) ('MH'=1305) ('NC'=1306) ('NR'=1307) ('NZ'=1308) ('PF'=1309) ('PG'=1310) ('PN'=1311) ('PW'=1312) ('SB'=1313) ('TO'=1314) ('TV'=1315) ('VU'=1316) ('WF'=1317) ('WS'=1318) ('14'=1400) (' '=-1) ('99'=-2) INTO COUNTRYW COUNTR1Y. RECODE YEARESID_ (' '=-1) ('00'=0) ('01'=1) ('02'=2) ('03'=3) ('04'=4) ('05'=5) ('06'=6) ('07'=7) ('08'=8) ('09'=9) ('10'=10) ('11'=11) ('11-14'=12) ('15-19'=17) ('20-24'=22) ('25-29'=27) ('30-34'=32) ('35-39'=37) ('40-44'=42) ('45-49'=47) ('50-54'=52) ('55-59'=57) ('60-64'=62) ('65-69'=67) ('70-74'=72) ('75-79'=77) ('80-84'=82) ('85-89'=87) ('90-94'=92) ('95-99'=97) INTO YEARESID. * Variable COUNTRYW is coded differently in Slovenia than in other countries. DO IF COUNTRY=28. RECODE COUNTRYW_ ('00'=45) ('NO'=-1) INTO COUNTRYW. END IF. FORMATS COUNTRY COUNTRYB NATIONAL NA111Y1D NA111D NA112J1D NA11PR1D HATLEV1D HATLFATH HATLMOTH NACE1D NACE1Y1D NACE2J1D NACEPR1D YEARESID (F2.0). FORMATS COUNTRYW COUNTR1Y (F4.0). *--- Recode Missing Values ---. RECODE MARSTAT AGERESID (SYSMIS=-1). RECODE LEAVCLAS (SYSMIS=-9). RECODE HHINST PROXY STAPRO SUPVISOR WAYJFOUN FTPT FTPTREAS TEMP TEMPREAS TEMPDUR TEMPAGCY SHIFTWK EVENWK NIGHTWK SATWK SUNWK WISHMORE WAYMORE HOMEWK LOOKOJ LOOKREAS EXIST2J STAPRO2J EXISTPR STAPROPR SEEKREAS SEEKTYPE SEEKDUR WANTWORK AVAILBLE AVAIREAS PRESEEK NEEDCARE REGISTER MAINSTAT EDUCSTAT EDUCLEVL COURATT COURPURP COURWORH WSTAT1Y STAPRO1Y NA11S NA112JS NA11PRS DURUNE EDUC4WN NA111YS HATLFATH HATLMOTH LENTR4W PURP4W (SYSMIS=-1) (9=-2). RECODE SIZEFIRM MSTARTWK HWUSUAL HWACTUAL HWOVERP HWOVERPU HOURREAS HWWISH HWACTUA2 MONTHPR LEAVREAS HATLEVEL METHFW COUNTRYW COUNTR1Y INCDECIL (SYSMIS=-1) (99=-2). RECODE HHAGE14 HHAGEYG (SYSMIS=-4) (99=-2). RECODE ISCOPR3D EDUCFILD COURLEN COURFILD HATFIELD ISCO1D ISCOPR1D ISCO3D STARTIME LEAVTIME (SYSMIS=-1) (999=-2). RECODE YSTARTWK YEARPR HATYEAR (SYSMIS=-1) (9999=-2). RECODE WSTATOR SIGNISAL SEEKWORK METHODA METHODB METHODC METHODD METHODE METHODF METHODG METHODH METHODI METHODJ METHODK METHODL METHODM ILOSTAT HHLINK HHCHILDR HHWKSTAT HHPARTNR HHPARENT HHPERS (9=-2). RECODE NOWKREAS HHSPOU HHFATH HHMOTH HHNBPERS HHNB0014 HHNBOLD HHNBCHLD HHNBCH2 HHNBCH5 HHNBCH8 HHNBCH11 HHNBCH14 HHNBCH17 HHNBCH24 HHCOMP HHNBEMPL HHNBUNEM HHNBINAC HHNBWORK (99=-2). RECODE REGIONW REGION1Y (' '='-1') ('99'='-2'). EXECUTE. *--- Recode Variables in Countries which did not deliver any Information for this Variable ---. DO REPEAT var=REC HHSEQNUM REFYEAR REFWEEK INTWEEK DEGURBA HHTYPE HHINST INTWAVE INTQUEST REM HHPRIV HHLINK HHSPOU HHFATH HHMOTH SEX AGE MARSTAT NATIONAL YEARESID COUNTRYB PROXY WSTATOR NOWKREAS STAPRO SUPVISOR SIZEFIRM COUNTRYW YSTARTWK MSTARTWK WAYJFOUN FTPT FTPTREAS TEMP TEMPREAS TEMPDUR TEMPAGCY SHIFTWK EVENWK NIGHTWK SATWK SUNWK HWUSUAL HWACTUAL HWOVERP HWOVERPU HOURREAS WISHMORE WAYMORE HWWISH HOMEWK LOOKOJ LOOKREAS EXIST2J STAPRO2J HWACTUA2 EXISTPR YEARPR MONTHPR LEAVREAS STAPROPR ISCOPR3D SEEKWORK SEEKREAS SEEKTYPE SEEKDUR METHODA METHODB METHODC METHODD METHODE METHODF METHODG METHODH METHODI METHODJ METHODK METHODL METHODM WANTWORK AVAILBLE AVAIREAS PRESEEK NEEDCARE REGISTER MAINSTAT EDUCSTAT EDUCLEVL EDUCFILD COURATT COURLEN COURPURP COURFILD COURWORH HATLEVEL HATFIELD HATYEAR WSTAT1Y STAPRO1Y NA111Y1D COUNTR1Y ILOSTAT NA111D NA11S ISCO1D NA112J1D NA112JS NA11PR1D NA11PRS ISCOPR1D DURUNE EDUC4WN HATLEV1D NA111YS METHFW LENTR4W PURP4W HWUSTRAI ISCO3D STARTIME LEAVTIME LEAVCLAS INCDECIL NACE1D NACE1Y1D NACE2J1D NACEPR1D AGERESID HHCHILDR HHWKSTAT HHPARTNR HHPARENT HHCOMP HATLFATH HATLMOTH HHNBCHLD HHNB0014 HHNBCH2 HHNBCH5 HHNBCH8 HHNBCH11 HHNBCH14 HHNBCH17 HHNBCH24 HHNBPERS HHNBEMPL HHNBINAC HHNBUNEM HHNBWORK HHAGEYG HHAGE14 HHNBOLD HHPERS SIGNISAL / varx=x1 TO x155. COMPUTE varx=var. END REPEAT. EXECUTE. RECODE x1 TO x155 (SYSMIS=-5) (ELSE=COPY). RECODE SIGNISAL (4=-1) (SYSMIS=-5) (ELSE=COPY) INTO x155. RECODE REGION ('00'=-1) (' '=-5) (ELSE=1) INTO x156. RECODE REGIONW REGION1Y ('-1'=-1) ('-2'=-2) (ELSE=1) INTO x157 x158. EXECUTE. AGGREGATE OUTFILE=* MODE=ADDVARIABLES OVERWRITE=YES / x1 TO x158=MAX(x1 TO x158). EXECUTE. DO REPEAT var=REC HHSEQNUM REFYEAR REFWEEK INTWEEK DEGURBA HHTYPE HHINST INTWAVE INTQUEST REM HHPRIV HHLINK HHSPOU HHFATH HHMOTH SEX AGE MARSTAT NATIONAL YEARESID COUNTRYB PROXY WSTATOR NOWKREAS STAPRO SUPVISOR SIZEFIRM COUNTRYW YSTARTWK MSTARTWK WAYJFOUN FTPT FTPTREAS TEMP TEMPREAS TEMPDUR TEMPAGCY SHIFTWK EVENWK NIGHTWK SATWK SUNWK HWUSUAL HWACTUAL HWOVERP HWOVERPU HOURREAS WISHMORE WAYMORE HWWISH HOMEWK LOOKOJ LOOKREAS EXIST2J STAPRO2J HWACTUA2 EXISTPR YEARPR MONTHPR LEAVREAS STAPROPR ISCOPR3D SEEKWORK SEEKREAS SEEKTYPE SEEKDUR METHODA METHODB METHODC METHODD METHODE METHODF METHODG METHODH METHODI METHODJ METHODK METHODL METHODM WANTWORK AVAILBLE AVAIREAS PRESEEK NEEDCARE REGISTER MAINSTAT EDUCSTAT EDUCLEVL EDUCFILD COURATT COURLEN COURPURP COURFILD COURWORH HATLEVEL HATFIELD HATYEAR WSTAT1Y STAPRO1Y NA111Y1D COUNTR1Y ILOSTAT NA111D NA11S ISCO1D NA112J1D NA112JS NA11PR1D NA11PRS ISCOPR1D DURUNE EDUC4WN HATLEV1D NA111YS METHFW LENTR4W PURP4W HWUSTRAI ISCO3D STARTIME LEAVTIME LEAVCLAS INCDECIL NACE1D NACE1Y1D NACE2J1D NACEPR1D AGERESID HHCHILDR HHWKSTAT HHPARTNR HHPARENT HHCOMP HATLFATH HATLMOTH HHNBCHLD HHNB0014 HHNBCH2 HHNBCH5 HHNBCH8 HHNBCH11 HHNBCH14 HHNBCH17 HHNBCH24 HHNBPERS HHNBEMPL HHNBINAC HHNBUNEM HHNBWORK HHAGEYG HHAGE14 HHNBOLD HHPERS SIGNISAL / varx=x1 TO x155. IF varx<0 var=-3. END REPEAT. EXECUTE. DO IF x156<0. RECODE REGION (ELSE='-3'). END IF. DO IF x157<0. RECODE REGIONW (ELSE='-3'). END IF. DO IF x158<0. RECODE REGION1Y (ELSE='-3'). END IF. EXECUTE. DELETE VARIABLES x1 TO x158. EXECUTE. *--- Recode or Rename Variabels in Specific Cases ---. * in Slovenia children were not ask for MARSTAT. DO IF COUNTRY=28 AND AGE<=12. RECODE MARSTAT (-1=-2). END IF. * revision of the International Standard Classification of Occupations (ISCO-88 COM until 2010, ISCO-08 from 2011). RENAME VARIABLES (ISCO3D=ISCO3D_88) (ISCOPR3D=ISCOPR3D_88). FORMATS ISCO3D_88 ISCOPR3D_88 (F3.0). EXECUTE. * in certain cases, members of the armed forces had been coded wrong in the 3-digit ISCO. RECODE ISCO3D_88 ISCOPR3D_88 (11=10) (ELSE=COPY). EXECUTE. *--- Declare User-Missing Values ---. MISSING VALUES REC HHSEQNUM REFYEAR REFWEEK INTWEEK COUNTRY DEGURBA HHTYPE HHINST INTWAVE INTQUEST REM YEAR HHPRIV HHLINK HHSPOU HHFATH HHMOTH SEX AGE MARSTAT NATIONAL YEARESID COUNTRYB PROXY WSTATOR NOWKREAS STAPRO SIGNISAL SUPVISOR SIZEFIRM COUNTRYW YSTARTWK MSTARTWK WAYJFOUN FTPT FTPTREAS TEMP TEMPREAS TEMPDUR TEMPAGCY SHIFTWK EVENWK NIGHTWK SATWK SUNWK HWUSUAL HWACTUAL HWOVERP HWOVERPU HOURREAS WISHMORE WAYMORE HWWISH HOMEWK LOOKOJ LOOKREAS EXIST2J STAPRO2J HWACTUA2 EXISTPR YEARPR MONTHPR LEAVREAS STAPROPR ISCOPR3D_88 SEEKWORK SEEKREAS SEEKTYPE SEEKDUR METHODA METHODB METHODC METHODD METHODE METHODF METHODG METHODH METHODI METHODJ METHODK METHODL METHODM WANTWORK AVAILBLE AVAIREAS PRESEEK NEEDCARE REGISTER MAINSTAT EDUCSTAT EDUCLEVL EDUCFILD COURATT COURLEN COURPURP COURFILD COURWORH HATLEVEL HATFIELD HATYEAR WSTAT1Y STAPRO1Y NA111Y1D COUNTR1Y ILOSTAT NA111D NA11S ISCO1D NA112J1D NA112JS NA11PR1D NA11PRS ISCOPR1D DURUNE EDUC4WN HATLEV1D NA111YS METHFW LENTR4W PURP4W HWUSTRAI ISCO3D_88 STARTIME LEAVTIME LEAVCLAS INCDECIL NACE1D NACE1Y1D NACE2J1D NACEPR1D AGERESID HHCHILDR HHWKSTAT HHPARTNR HHPARENT HHCOMP HATLFATH HATLMOTH HHNBCHLD HHNB0014 HHNBCH2 HHNBCH5 HHNBCH8 HHNBCH11 HHNBCH14 HHNBCH17 HHNBCH24 HHNBPERS HHNBEMPL HHNBINAC HHNBUNEM HHNBWORK HHAGEYG HHAGE14 HHNBOLD HHPERS (-9 THRU -1). MISSING VALUES REGION REGIONW REGION1Y ('-1','-2','-3'). EXECUTE. *--- Delete Recoded Alphanumeric Variables ---. DELETE VARIABLES COUNTRY_ COUNTRYB_ COUNTRYW_ COUNTR1Y_ NATIONAL_ NA111Y1D_ NA111D_ NA112J1D_ YEARESID_ NA11PR1D_ HATLEV1D_ NACE1D_ NACE1Y1D_ NACE2J1D_ NACEPR1D_ HATLFATH_ HATLMOTH_. EXECUTE. *--- Define Variable and Value Labels ---. INCLUDE FILE='LABEL_SYNTAX_PATH/Labels_EULFS_1983-2011.sps'. *--- Save SAV-Files ---. SAVE OUTFILE= !QUOTE(!CONCAT('SPSS_DATA_PATH',!i,'.sav')). !DOEND. !ENDDEFINE. *---------------------------------------------- End Definition Macro ----------------------------------------------. *-------------------------------------------------- Invoke Macro --------------------------------------------------. !readmac datfile=FILENAMES %. * e.g. all files for 2008. * !readmac datfile=at2008_y be2008_y bg2008_y ch2008_y cy2008_y cz2008_y de2008_y dk2008_y ee2008_y es2008_y fi2008_y fr2008_y gr2008_y hu2008_y ie2008_y is2008_y it2008_y lt2008_y lu2008_y lv2008_y nl2008_y no2008_y pl2008_y pt2008_y ro2008_y se2008_y si2008_y sk2008_y uk2008_y %. * e.g. all files for 2007. * !readmac datfile=at2007_y be2007_y bg2007_y ch2007_y cy2007_y cz2007_y de2007_y dk2007_y ee2007_y es2007_y fi2007_y fr2007_y gr2007_y hu2007_y ie2007_y is2007_y it2007_y lt2007_y lu2007_y lv2007_y nl2007_y no2007_y pl2007_y pt2007_y ro2007_y se2007_y si2007_y sk2007_y uk2007_y %. * e.g. all files for 2006. * !readmac datfile=at2006_y be2006_y bg2006_y ch2006_y cy2006_y cz2006_y de2006_y dk2006_y ee2006_y es2006_y fi2006_y fr2006_y gr2006_y hu2006_y ie2006_y is2006_y it2006_y lt2006_y lu2006_y lv2006_y nl2006_y no2006_y pl2006_y pt2006_y ro2006_y se2006_y si2006_y sk2006_y uk2006_y %.