*--------------------------------------------------------------------------------------------------------------------------. * EU-Labour Force Survey - Data Service - German Microdata Lab * This routine converts EU-LFS 2012-2013 QUARTERLY data formatted in CSV into DTA * Checked for the December 2014 release of the EU-LFS, as provided by Eurostat * The whole routine consists of two files: * Setup_EULFS_2012-2013_q.do * Labels_EULFS_1983-2013.do * Version 1 of the routine, April 2015 * Stata/MP 13.0 * (c) GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Andrea Lengerer, Ina Rüber, Bianca Dungl * http://www.gesis.org/en/institute/ * Contact: gml@gesis.org * This Stata code is protected under the creative commons licence. *--------------------------------------------------------------------------------------------------------------------------. * CONFIGURATION. * Line 47: Change CSV_DATA_PATH to the path where the csv files are stored * (e.g. E:/data/EU-LFS/csv/). * Line 48: Change FILENAMES to the expression of files you want to convert from csv to dta * (without file extension, e.g. "*_y.csv" for application on all yearly data sets stored in CSV_DATA_PATH). * Line 581: Change LABEL_SYNTAX_PATH to the path where the file "Labels_EULFS_1983-2013.do" is stored * (e.g. E:/data/EU-LFS/syntax/Labels_EULFS_1983-2013.do). * Line 584: Change DTA_DATA_PATH to the path where you want the dta (Stata format) files to be stored * (e.g. E:/data/EU-LFS/dta/). * Line 587: similar to line 47 * Line 595: similar to line 584 *------------------------------------------- Initialization commands ----------------------------------------------------. set more off clear all cd "CSV_DATA_PATH" //Verzeichnis anpassen local filelist : dir . files "FILENAMES" foreach file in `filelist' { insheet using "`file'", clear comma drop _all import delimited using "`file'", stringcols (11 22 30 76 79 81 91 92 93) numericcols (51 87 96 98) *--- Add Release-Variable --- gen release = "DEC 2014" *--------------------------------------------- Set String Variables -----------------------------------------------------. tostring qhhnum quarter country region national yearesid countryb countryw regionw /// hatlev1d nace1d na111d na11pr1d na112j1d /// nace2j1d nacepr1d, replace *----------------------------------------- Recode Alphanumeric Variables ---------------------------------------------------. *recodification of quarter rename quarter quarter_s generate quarter=.a replace quarter=1 if quarter_s=="Q1" replace quarter=2 if quarter_s=="Q2" replace quarter=3 if quarter_s=="Q3" replace quarter=4 if quarter_s=="Q4" *recodification of country rename country country_s generate country=.a replace country=1 if country_s=="AT" replace country=2 if country_s=="BE" replace country=3 if country_s=="BG" replace country=4 if country_s=="CH" replace country=5 if country_s=="CY" replace country=6 if country_s=="CZ" replace country=7 if country_s=="DE" replace country=8 if country_s=="DK" replace country=9 if country_s=="EE" replace country=10 if country_s=="ES" replace country=11 if country_s=="FI" replace country=12 if country_s=="FR" replace country=13 if country_s=="GR" replace country=14 if country_s=="HR" replace country=15 if country_s=="HU" replace country=16 if country_s=="IE" replace country=17 if country_s=="IS" replace country=18 if country_s=="IT" replace country=19 if country_s=="LT" replace country=20 if country_s=="LU" replace country=21 if country_s=="LV" replace country=22 if country_s=="MT" replace country=23 if country_s=="NL" replace country=24 if country_s=="NO" replace country=25 if country_s=="PL" replace country=26 if country_s=="PT" replace country=27 if country_s=="RO" replace country=28 if country_s=="SE" replace country=29 if country_s=="SI" replace country=30 if country_s=="SK" replace country=31 if country_s=="UK" *recodification of national and countryb foreach var of varlist national countryb { rename `var' `var'_s generate `var'=.a replace `var'=0 if `var'_s=="000-OWN COUNTRY" replace `var'=1 if `var'_s=="001-EU15" replace `var'=2 if `var'_s=="002-NMS10" replace `var'=3 if `var'_s=="003-NMS3" replace `var'=4 if `var'_s=="004-NMS13" replace `var'=5 if `var'_s=="005-EU27" replace `var'=5 if `var'_s=="005-EU28" replace `var'=6 if `var'_s=="006-EFTA" replace `var'=7 if `var'_s=="007-OTHER EUROPE" replace `var'=8 if `var'_s=="008-EUROPE OUTSIDE EU27" replace `var'=8 if `var'_s=="008-EUROPE OUTSIDE EU28" replace `var'=9 if `var'_s=="009-NORTH AFRICA" replace `var'=10 if `var'_s=="010-OTHER AFRICA" replace `var'=11 if `var'_s=="011-NEAR MIDDLE EAST" replace `var'=12 if `var'_s=="012-EAST ASIA" replace `var'=13 if `var'_s=="013-SOUTH S-EAST ASIA" replace `var'=14 if `var'_s=="014-NORTH AFRICA AND NEAR" replace `var'=15 if `var'_s=="015-EAST AND SOUTH ASIA" replace `var'=16 if `var'_s=="016-NORTH AMERICA" replace `var'=17 if `var'_s=="017-CENTRAL AMERICA" replace `var'=18 if `var'_s=="018-SOUTH AMERICA" replace `var'=19 if `var'_s=="019-AUSTRALIA OCEANIA" replace `var'=20 if `var'_s=="020-LATIN AMERICA" replace `var'=21 if `var'_s=="021-NORTH AMERICA AND AUS" replace `var'=.a if `var'_s=="NO ANSWER" replace `var'=.a if `var'_s=="999" } *recodification of na111d, na112j1d and na11pr1d foreach var of varlist na111d na11pr1d na112j1d { rename `var' `var'_s generate `var'=.a replace `var'= 1 if `var'_s== "A" replace `var'= 2 if `var'_s== "B" replace `var'= 3 if `var'_s== "C" replace `var'= 4 if `var'_s== "D" replace `var'= 5 if `var'_s== "E" replace `var'= 6 if `var'_s== "F" replace `var'= 7 if `var'_s== "G" replace `var'= 8 if `var'_s== "H" replace `var'= 9 if `var'_s== "I" replace `var'= 10 if `var'_s== "J" replace `var'= 11 if `var'_s== "K" replace `var'= 12 if `var'_s== "L" replace `var'= 13 if `var'_s== "M" replace `var'= 14 if `var'_s== "N" replace `var'= 15 if `var'_s== "O" replace `var'= 16 if `var'_s== "P" replace `var'= 17 if `var'_s== "Q" replace `var'=.b if `var'_s== "9" } *recodification of hatlev1d foreach var of varlist hatlev1d { rename `var' `var'_s generate `var'=.a replace `var'= 1 if `var'_s=="L" replace `var'= 2 if `var'_s=="M" replace `var'= 3 if `var'_s=="H" replace `var'= 8 if `var'_s=="8" replace `var'=.a if `var'_s=="" } *recodification of nace1d, nace2j1d and nacepr1d foreach var of varlist nace1d nacepr1d nace2j1d { rename `var' `var'_s generate `var'=.a replace `var'= 1 if `var'_s== "A" replace `var'= 2 if `var'_s== "B" replace `var'= 3 if `var'_s== "C" replace `var'= 4 if `var'_s== "D" replace `var'= 5 if `var'_s== "E" replace `var'= 6 if `var'_s== "F" replace `var'= 7 if `var'_s== "G" replace `var'= 8 if `var'_s== "H" replace `var'= 9 if `var'_s== "I" replace `var'= 10 if `var'_s== "J" replace `var'= 11 if `var'_s== "K" replace `var'= 12 if `var'_s== "L" replace `var'= 13 if `var'_s== "M" replace `var'= 14 if `var'_s== "N" replace `var'= 15 if `var'_s== "O" replace `var'= 16 if `var'_s== "P" replace `var'= 17 if `var'_s== "Q" replace `var'= 18 if `var'_s== "R" replace `var'= 19 if `var'_s== "S" replace `var'= 20 if `var'_s== "T" replace `var'= 21 if `var'_s== "U" replace `var'= 9 if `var'_s== ".b" replace `var'=.a if `var'_s== "" } *recodification of countryw foreach var of varlist countryw { rename `var' `var'_s generate `var'=.a replace `var'= 1 if `var'_s== "AD" replace `var'= 2 if `var'_s== "AL" replace `var'= 3 if `var'_s== "AT" replace `var'= 4 if `var'_s== "BA" replace `var'= 5 if `var'_s== "BE" replace `var'= 6 if `var'_s== "BG" replace `var'= 7 if `var'_s== "BY" replace `var'= 8 if `var'_s== "CH" replace `var'= 9 if `var'_s== "CY" replace `var'= 10 if `var'_s== "CZ" replace `var'= 11 if `var'_s== "DE" replace `var'= 12 if `var'_s== "DK" replace `var'= 13 if `var'_s== "EE" replace `var'= 14 if `var'_s== "GR" replace `var'= 15 if `var'_s== "ES" replace `var'= 16 if `var'_s== "FI" replace `var'= 17 if `var'_s== "FO" replace `var'= 18 if `var'_s== "FR" replace `var'= 19 if `var'_s== "GG" replace `var'= 20 if `var'_s== "GI" replace `var'= 21 if `var'_s== "HR" replace `var'= 22 if `var'_s== "HU" replace `var'= 23 if `var'_s== "IE" replace `var'= 24 if `var'_s== "IM" replace `var'= 25 if `var'_s== "IS" replace `var'= 26 if `var'_s== "IT" replace `var'= 27 if `var'_s== "JE" replace `var'= 28 if `var'_s== "LI" replace `var'= 29 if `var'_s== "LT" replace `var'= 30 if `var'_s== "LU" replace `var'= 31 if `var'_s== "LV" replace `var'= 32 if `var'_s== "MC" replace `var'= 33 if `var'_s== "MD" replace `var'= 34 if `var'_s== "ME" replace `var'= 34 if `var'_s== "XM" replace `var'= 35 if `var'_s== "MK" replace `var'= 36 if `var'_s== "MT" replace `var'= 37 if `var'_s== "NL" replace `var'= 38 if `var'_s== "NO" replace `var'= 39 if `var'_s== "PL" replace `var'= 40 if `var'_s== "PT" replace `var'= 41 if `var'_s== "RO" replace `var'= 42 if `var'_s== "RS" replace `var'= 42 if `var'_s== "XS" replace `var'= 43 if `var'_s== "RU" replace `var'= 44 if `var'_s== "SE" replace `var'= 45 if `var'_s== "SI" replace `var'= 46 if `var'_s== "SK" replace `var'= 47 if `var'_s== "SM" replace `var'= 48 if `var'_s== "TR" replace `var'= 49 if `var'_s== "UA" replace `var'= 50 if `var'_s== "UK" replace `var'= 51 if `var'_s== "VA" replace `var'= 52 if `var'_s== "XK" replace `var'= 60 if `var'_s== "CS" replace `var'= 61 if `var'_s== "SU" replace `var'= 62 if `var'_s== "YU" replace `var'= 90 if `var'_s== "NN" replace `var'= 110 if `var'_s== "01" replace `var'= 120 if `var'_s== "02" replace `var'= 130 if `var'_s== "03" replace `var'= 140 if `var'_s== "04" replace `var'= 150 if `var'_s== "15" replace `var'= 0500 if `var'_s== "05" replace `var'= 0501 if `var'_s== "DZ" replace `var'= 0502 if `var'_s== "EG" replace `var'= 0503 if `var'_s== "LY" replace `var'= 0504 if `var'_s== "MA" replace `var'= 0505 if `var'_s== "TN" replace `var'= 0600 if `var'_s== "06" replace `var'= 0601 if `var'_s== "AO" replace `var'= 0602 if `var'_s== "BF" replace `var'= 0603 if `var'_s== "BI" replace `var'= 0604 if `var'_s== "BJ" replace `var'= 0605 if `var'_s== "BW" replace `var'= 0606 if `var'_s== "CD" replace `var'= 0607 if `var'_s== "CF" replace `var'= 0608 if `var'_s== "CG" replace `var'= 0609 if `var'_s== "CI" replace `var'= 0610 if `var'_s== "CM" replace `var'= 0611 if `var'_s== "CV" replace `var'= 0612 if `var'_s== "DJ" replace `var'= 0613 if `var'_s== "ER" replace `var'= 0614 if `var'_s== "ET" replace `var'= 0615 if `var'_s== "GA" replace `var'= 0616 if `var'_s== "GH" replace `var'= 0617 if `var'_s== "GM" replace `var'= 0618 if `var'_s== "GN" replace `var'= 0619 if `var'_s== "GQ" replace `var'= 0620 if `var'_s== "GW" replace `var'= 0621 if `var'_s== "KE" replace `var'= 0622 if `var'_s== "KM" replace `var'= 0623 if `var'_s== "LR" replace `var'= 0624 if `var'_s== "LS" replace `var'= 0625 if `var'_s== "MG" replace `var'= 0626 if `var'_s== "ML" replace `var'= 0627 if `var'_s== "MR" replace `var'= 0628 if `var'_s== "MU" replace `var'= 0629 if `var'_s== "MW" replace `var'= 0630 if `var'_s== "MZ" replace `var'= 0631 if `var'_s== "NA" replace `var'= 0632 if `var'_s== "NE" replace `var'= 0633 if `var'_s== "NG" replace `var'= 0634 if `var'_s== "RW" replace `var'= 0635 if `var'_s== "SC" replace `var'= 0636 if `var'_s== "SD" replace `var'= 0637 if `var'_s== "SH" replace `var'= 0638 if `var'_s== "SL" replace `var'= 0639 if `var'_s== "SN" replace `var'= 0640 if `var'_s== "SO" replace `var'= 0641 if `var'_s== "SS" replace `var'= 0642 if `var'_s== "ST" replace `var'= 0643 if `var'_s== "SZ" replace `var'= 0644 if `var'_s== "TD" replace `var'= 0645 if `var'_s== "TG" replace `var'= 0646 if `var'_s== "TZ" replace `var'= 0647 if `var'_s== "UG" replace `var'= 0648 if `var'_s== "YT" replace `var'= 0649 if `var'_s== "ZA" replace `var'= 0650 if `var'_s== "ZM" replace `var'= 0651 if `var'_s== "ZW" replace `var'= 0700 if `var'_s== "07" replace `var'= 0701 if `var'_s== "BM" replace `var'= 0702 if `var'_s== "CA" replace `var'= 0703 if `var'_s== "GL" replace `var'= 0704 if `var'_s== "PM" replace `var'= 0705 if `var'_s== "US" replace `var'= 0800 if `var'_s== "08" replace `var'= 0801 if `var'_s== "AG" replace `var'= 0802 if `var'_s== "AI" replace `var'= 0803 if `var'_s== "AN" replace `var'= 0804 if `var'_s== "AW" replace `var'= 0805 if `var'_s== "BB" replace `var'= 0806 if `var'_s== "BL" replace `var'= 0807 if `var'_s== "BS" replace `var'= 0808 if `var'_s== "BZ" replace `var'= 0809 if `var'_s== "CR" replace `var'= 0810 if `var'_s== "CU" replace `var'= 0811 if `var'_s== "DM" replace `var'= 0812 if `var'_s== "DO" replace `var'= 0813 if `var'_s== "GD" replace `var'= 0814 if `var'_s== "GT" replace `var'= 0815 if `var'_s== "HN" replace `var'= 0816 if `var'_s== "HT" replace `var'= 0817 if `var'_s== "JM" replace `var'= 0818 if `var'_s== "KN" replace `var'= 0819 if `var'_s== "KY" replace `var'= 0820 if `var'_s== "LC" replace `var'= 0821 if `var'_s== "MF" replace `var'= 0822 if `var'_s== "MS" replace `var'= 0823 if `var'_s== "MX" replace `var'= 0824 if `var'_s== "NI" replace `var'= 0825 if `var'_s== "PA" replace `var'= 0826 if `var'_s== "PR" replace `var'= 0827 if `var'_s== "SV" replace `var'= 0828 if `var'_s== "TC" replace `var'= 0829 if `var'_s== "TT" replace `var'= 0830 if `var'_s== "VC" replace `var'= 0831 if `var'_s== "VG" replace `var'= 0900 if `var'_s== "09" replace `var'= 0901 if `var'_s== "AR" replace `var'= 0902 if `var'_s== "BO" replace `var'= 0903 if `var'_s== "BR" replace `var'= 0904 if `var'_s== "CL" replace `var'= 0905 if `var'_s== "CO" replace `var'= 0906 if `var'_s== "EC" replace `var'= 0907 if `var'_s== "FK" replace `var'= 0908 if `var'_s== "GY" replace `var'= 0909 if `var'_s== "PE" replace `var'= 0910 if `var'_s== "PY" replace `var'= 0911 if `var'_s== "SR" replace `var'= 0912 if `var'_s== "TF" replace `var'= 0913 if `var'_s== "UY" replace `var'= 0914 if `var'_s== "VE" replace `var'= 1000 if `var'_s== "10" replace `var'= 1001 if `var'_s== "CN" replace `var'= 1002 if `var'_s== "JP" replace `var'= 1003 if `var'_s== "KP" replace `var'= 1004 if `var'_s== "KR" replace `var'= 1005 if `var'_s== "MN" replace `var'= 1006 if `var'_s== "TW" replace `var'= 1100 if `var'_s== "11" replace `var'= 1101 if `var'_s== "AE" replace `var'= 1102 if `var'_s== "AM" replace `var'= 1103 if `var'_s== "AZ" replace `var'= 1104 if `var'_s== "BH" replace `var'= 1105 if `var'_s== "GE" replace `var'= 1106 if `var'_s== "IL" replace `var'= 1107 if `var'_s== "IQ" replace `var'= 1108 if `var'_s== "IR" replace `var'= 1109 if `var'_s== "JO" replace `var'= 1110 if `var'_s== "KG" replace `var'= 1111 if `var'_s== "KW" replace `var'= 1112 if `var'_s== "KZ" replace `var'= 1113 if `var'_s== "LB" replace `var'= 1114 if `var'_s== "OM" replace `var'= 1115 if `var'_s== "PS" replace `var'= 1116 if `var'_s== "QA" replace `var'= 1117 if `var'_s== "SA" replace `var'= 1118 if `var'_s== "SY" replace `var'= 1119 if `var'_s== "TJ" replace `var'= 1120 if `var'_s== "TM" replace `var'= 1121 if `var'_s== "UZ" replace `var'= 1122 if `var'_s== "YE" replace `var'= 1200 if `var'_s== "12" replace `var'= 1201 if `var'_s== "AF" replace `var'= 1202 if `var'_s== "BD" replace `var'= 1203 if `var'_s== "BN" replace `var'= 1204 if `var'_s== "BT" replace `var'= 1205 if `var'_s== "ID" replace `var'= 1206 if `var'_s== "IN" replace `var'= 1207 if `var'_s== "KH" replace `var'= 1208 if `var'_s== "LA" replace `var'= 1209 if `var'_s== "LK" replace `var'= 1210 if `var'_s== "MM" replace `var'= 1211 if `var'_s== "MV" replace `var'= 1212 if `var'_s== "MY" replace `var'= 1213 if `var'_s== "NP" replace `var'= 1214 if `var'_s== "PH" replace `var'= 1215 if `var'_s== "PK" replace `var'= 1216 if `var'_s== "SG" replace `var'= 1217 if `var'_s== "TH" replace `var'= 1218 if `var'_s== "TL" replace `var'= 1219 if `var'_s== "VN" replace `var'= 1300 if `var'_s== "13" replace `var'= 1301 if `var'_s== "AU" replace `var'= 1302 if `var'_s== "FJ" replace `var'= 1303 if `var'_s== "FM" replace `var'= 1304 if `var'_s== "KI" replace `var'= 1305 if `var'_s== "MH" replace `var'= 1306 if `var'_s== "NC" replace `var'= 1307 if `var'_s== "NR" replace `var'= 1308 if `var'_s== "NZ" replace `var'= 1309 if `var'_s== "PF" replace `var'= 1310 if `var'_s== "PG" replace `var'= 1311 if `var'_s== "PN" replace `var'= 1312 if `var'_s== "PW" replace `var'= 1313 if `var'_s== "SB" replace `var'= 1314 if `var'_s== "TO" replace `var'= 1315 if `var'_s== "TV" replace `var'= 1316 if `var'_s== "VU" replace `var'= 1317 if `var'_s== "WF" replace `var'= 1318 if `var'_s== "WS" replace `var'= 1400 if `var'_s== "14" replace `var'=160 if `var'_s== "111" replace `var'=170 if `var'_s== "991" replace `var'=.a if `var'_s== "" replace `var'=.b if `var'_s== "999" replace `var'=.b if `var'_s== "99" } * Variable countryw is coded differently in Malta and Slovenia than in other countries replace countryw=36 if countryw_s=="000-OWN COUNTRY" & country==22 replace countryw=180 if countryw_s=="005-EU28" & country==22 replace countryw=180 if countryw_s=="005-EU27" & country==22 replace countryw=.a if countryw_s=="NO ANSWER" & country==22 replace countryw=45 if countryw_s=="000-OWN COUNTRY" & country==29 replace countryw=180 if countryw_s=="005-EU28" & country==29 replace countryw=180 if countryw_s=="005-EU27" & country==29 replace countryw=190 if countryw_s=="008-EUROPE OUTSIDE EU28" & country==29 replace countryw=190 if countryw_s=="008-EUROPE OUTSIDE EU27" & country==29 replace countryw=.a if countryw_s=="NO ANSWER" & country==29 *recodification of yearesid rename yearesid yearesid_s generate yearesid=.a replace yearesid=0 if yearesid_s=="00" replace yearesid=1 if yearesid_s=="01" replace yearesid=2 if yearesid_s=="02" replace yearesid=3 if yearesid_s=="03" replace yearesid=4 if yearesid_s=="04" replace yearesid=5 if yearesid_s=="05" replace yearesid=6 if yearesid_s=="06" replace yearesid=7 if yearesid_s=="07" replace yearesid=8 if yearesid_s=="08" replace yearesid=9 if yearesid_s=="09" replace yearesid=10 if yearesid_s=="10" replace yearesid=2 if yearesid_s=="01-04" replace yearesid=6 if yearesid_s=="05-10" replace yearesid=12 if yearesid_s=="11-14" replace yearesid=17 if yearesid_s=="15-19" replace yearesid=22 if yearesid_s=="20-24" replace yearesid=27 if yearesid_s=="25-29" replace yearesid=32 if yearesid_s=="30-34" replace yearesid=37 if yearesid_s=="35-39" replace yearesid=42 if yearesid_s=="40-44" replace yearesid=47 if yearesid_s=="45-49" replace yearesid=52 if yearesid_s=="50-54" replace yearesid=57 if yearesid_s=="55-59" replace yearesid=62 if yearesid_s=="60-64" replace yearesid=67 if yearesid_s=="65-69" replace yearesid=72 if yearesid_s=="70-74" replace yearesid=77 if yearesid_s=="75-79" replace yearesid=82 if yearesid_s=="80-84" replace yearesid=87 if yearesid_s=="85-89" replace yearesid=92 if yearesid_s=="90-94" replace yearesid=97 if yearesid_s=="95-99" replace yearesid=77 if yearesid_s=="75-99" *Values of region & regionw have country-specific meaning (according to the NUTS classification) egen region_ = concat(country_s region) if region!="00" egen regionw_ = concat(countryw_s regionw) if regionw!="00" replace region_=".e" if region=="00" replace regionw_=".e" if regionw=="00" replace regionw_=".a" if regionw=="" | countryw_s=="" replace regionw_=".b" if regionw=="99" | countryw_s=="99" *Separate coding of regionw for Slovenia (due to the separate coding of COUNTRYW in Slovenia) replace regionw_="SI01" if countryw==45 & regionw_=="000-OWN COUNTRY01" replace regionw_="SI02" if countryw==45 & regionw_=="000-OWN COUNTRY02" drop region regionw rename region_ region rename regionw_ regionw *--------------------------------------------------- Recode Missing Values ---------------------------------------------. #delimit ; recode ageresid (.=.a) ; recode leavclas (.=.i) ; recode hhinst proxy stapro ftpt temp tempdur wishmore lookoj exist2j stapro2j existpr stapropr seektype seekdur wantwork availble educstat educlevl couratt na11s na112js na11prs durune educ4wn (.=.a) (9=.b) ; recode mstartwk hwusual hwactual hwoverp hwoverpu hourreas hwwish hwactua2 monthpr hat97lev (.=.a) (99=.b) ; recode iscopr3d courlen isco1d iscopr1d isco3d startime leavtime is881d is88pr1d is883d is88pr3d (.=.a) (999=.b) ; recode ystartwk yearpr (.=.a) (9999=.b) ; recode wstator signisal seekwork methoda methodb methodc methodd methode methodf methodg methodh methodi methodj methodk methodl methodm ilostat (9=.b); recode nowkreas (99=.b) ; *Recode Variables in Countries which did not deliver any information for this Variable ; recode signisal (4=.), gen(signisal_) ; foreach x in hhseqnum refyear refweek intweek region degurba hhinst intwave intquest rem hhpriv sex age national yearesid countryb proxy wstator nowkreas stapro countryw regionw ystartwk mstartwk ftpt temp tempdur hwusual hwactual hwoverp hwoverpu hourreas wishmore hwwish lookoj exist2j stapro2j hwactua2 existpr yearpr monthpr stapropr iscopr3d seekwork seektype seekdur methoda methodb methodc methodd methode methodf methodg methodh methodi methodj methodk methodl methodm wantwork availble educstat educlevl couratt courlen hat97lev ilostat na111d na11s isco1d na112j1d na112js na11pr1d na11prs iscopr1d durune educ4wn hatlev1d isco3d startime leavtime leavclas nace1d nace2j1d nacepr1d ageresid is881d is88pr3d is88pr1d is883d signisal_ { ; tab `x', nofreq ; if r(r)==0 recode `x' (missing=.c) ; } ; recode signisal_ (.=4) ; drop signisal ; rename signisal_ signisal ; #delimit cr *----------------------------------------- Delete Recoded Alphanumeric Variables -------------------------------------------. drop country_s national_s countryb_s countryw_s na111d_s na11pr1d_s na112j1d_s /// hatlev1d_s nace1d_s nacepr1d_s nace2j1d_s yearesid_s quarter_s *--------------------------------------------------------- Save File -------------------------------------------------. do "LABEL_SYNTAX_PATH" local file : subinstr local file ".csv" "", all cd "DTA_DATA_PATH" save "`file'.dta" label drop _all cd "CSV_DATA_PATH" } *-------------------------------------------------- Combine all Country Files ---------------------------------------. clear all set more off cd "DTA_DATA_PATH" * with the append command, one can combine the single country files to one file containing all countries. * e.g. all files of 2013 foreach x in "at" "be" "bg" "ch" "cy" "cz" "de" "dk" "ee" "es" "fi" "fr" /// "gr" "hr" "hu" "ie" "is" "it" "lt" "lu" "lv" "mt" "nl" "no" "pl" /// "pt" "ro" "se" "si" "sk" "uk" { use `x'2013q1.dta foreach y in "2" "3" "4" { append using `x'2013q`y'.dta } save `x'2013q, replace } clear all set more off use at2013q.dta foreach x in "be" "bg" "ch" "cy" "cz" "de" "dk" "ee" "es" "fi" "fr" "gr" /// "hr" "hu" "ie" "is" "it" "lt" "lu" "lv" "mt" "nl" "no" "pl" "pt" /// "ro" "se" "si" "sk" "uk" { append using `x'2013q.dta, force } save 2013_q, replace *end