* 2011_cross_eu_silc_person_register_r.do * * STATA Command Syntax File * Stata 12.0; * * Transforms the EU-SILC CSV-data (as released by Eurostat) into an Stata-Systemfile * * EU-SILC - Cross 2011 * Personal register file: * UDB_c11R_ver 2011-2 from 01-08-13.csv * * * PLEASE NOTE * For Differences between data as described in the guidelines * and the anonymised user database as well as country specific anonymisation measures see: * C-2011 DIFFERENCES BETWEEN DATA COLLECTED AND UDB 13-03-01.doc * * * (c) GESIS * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Heike Wirth; Florian Bains * http://www.gesis.org/en/institute/ * * Contact: heike.wirth@gesis.org * /* Initialization commands */ clear capture log close set more off version 12.0 set linesize 250 set varabbrev off set memory 1G // not necessary in Stata 12 #delimit ; * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ; * CONFIGURATION SECTION - Start ; * The following command should contain the complete path and name of the Stata log file. Change LOG_FILENAME to your filename ; local log_file "LOG_FILENAME" ; * The following command should contain the complete path and name of the CSV data file. Change CSV_FILENAME to your filename ; local csv_file "CSV_FILENAME" ; * The following command should contain the complete path and name of the STATA file, usual file extension "dta". Change STATA_FILENAME to your filename ; local stata_file "STATA_FILENAME" ; * CONFIGURATION SECTION - End ; * There should be probably nothing to change below this line ; * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ; log using "`log_file'", replace text ; insheet using "`csv_file'", comma names case; * Note that some variables in the csv-data file might be in lowercase * To ensure that the dataset contains only variable names in uppercase ; foreach var of varlist _all { ; local newname = upper("`var'") ; cap rename `var' `newname' ; } ; label define RB020_neu 1 "BE" 2 "DK" 3 "DE" 4 "EL" 5 "ES" 6 "FR" 7 "IE" 8 "IT" 9 "LU" 10 "NL" 11 "AT" 12 "PT" 13 "FI" 14 "SE" 15 "UK" 16 "BG" 17 "CY" 18 "CZ" 19 "EE" 20 "HU" 21 "LV" 22 "LT" 23 "MT" 24 "PL" 25 "RO" 26 "SK" 27 "SI" 28 "IS" 29 "NO" 30 "CH" 31 "HR" 32 "TR" ; encode RB020, gen(RB020_neu) ; rename RB020_neu RB020_num ; label define RB020_num_VALUE_LABELS 1 "BE Belgique" 2 "DK Danmark" 3 "DE Deutschland" 4 "EL Ellada" 5 "ES Espana" 6 "FR France" 7 "IE Ireland" 8 "IT Italia" 9 "LU Luxembourg" 10 "NL Nederland" 11 "AT Oesterreich" 12 "PT Portugal" 13 "FI Suomi" 14 "SE Sverige" 15 "UK United Kingdom" 16 "BG Bulgaria" 17 "CY Cyprus" 18 "CZ Czech Republic" 19 "EE Estonia" 20 "HU Hungary" 21 "LV Latvia" 22 "LT Lithuania" 23 "MT Malta" 24 "PL Poland" 25 "RO Romania" 26 "SK Slovak Republic" 27 "SI Slovenia" 28 "IS Iceland" 29 "NO Norway" 30 "CH Switzerland" 31 "HR Croatia" 32 "TR Turkey" ; * Definition of variable labels ; label variable RB010 "Year of the survey" ; label variable RB020 "Country alphanumerisch" ; label variable RB020_num "country numerisch" ; label variable RB030 "Personal ID" ; label variable RB031 "Year of Immigration" ; label variable RB031_F "Flag" ; label variable RB070 "Quarter of Birth" ; label variable RB070_F "Flag" ; label variable RB080 "Year of birth" ; label variable RB080_F "Flag" ; label variable RB090 "Sex" ; label variable RB090_F "Flag" ; label variable RB200 "Residential Status" ; label variable RB200_F "Flag" ; label variable RB210 "Basic activity status" ; label variable RB210_F "Flag" ; label variable RB220 "Father ID" ; label variable RB220_F "Flag" ; label variable RB230 "Mother ID" ; label variable RB230_F "Flag" ; label variable RB240 "SpousePartner ID" ; label variable RB240_F "Flag" ; label variable RB245 "Respondent status" ; label variable RB245_F "Flag" ; label variable RB250 "Data status" ; label variable RB250_F "Flag" ; label variable RB260 "Type of interview" ; label variable RB260_F "Flag" ; label variable RB270 "Personal ID of proxy" ; label variable RB270_F "Flag" ; label variable RX020 "Age at the end of the income reference period" ; label variable RX010 "Age at the date of the interview" ; label variable RB050 "Personal cross-sectional weight" ; label variable RB050_F "Flag" ; label variable RL010 "Education at pre-school:hours of education during an usual week" ; label variable RL010_F "Flag" ; label variable RL020 "Education at compulsory school:hours of education during an usual week" ; label variable RL020_F "Flag" ; label variable RL030 "Childcare at centre-based services:hours of child care during an usual week" ; label variable RL030_F "Flag" ; label variable RL040 "Childcare at day-care centre:hours of child care during an usual week" ; label variable RL040_F "Flag" ; label variable RL050 "Child care by a professional child-miner:hours of child care during an usual week" ; label variable RL050_F "Flag" ; label variable RL060 "Child care by grand-parents/other hhld members/relatives etc: ours during an usual week" ; label variable RL060_F "Flag" ; label variable RL070 "Children cross-sectional weight for child care" ; label variable RL070_F "Flag" ; label variable RX030 "Household ID" ; label variable RX040 "Work intensity" ; label variable RX050 "Low work intensity status"; label variable RX060 "Severely materially deprived household"; label variable RX070 "At risk of poverty or social exclusion"; * Definition of category labels ; label define RB031_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (no immigration for the person)" ; label define RB070_VALUE_LABELS 1 "January, February, March" 2 "April, May, June" 3 "July, August, September" 4 "October, November, December" ; label define RB070_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define RB080_VALUE_LABELS 1930 "1930 or before" ; label define RB080_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define RB090_VALUE_LABELS 1 "Male" 2 "Female" ; label define RB090_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define RB200_VALUE_LABELS 1 "currently living in the household" 2 "temporarily absent" ; label define RB200_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (RB110 not = 1, 2, 3 or 4)" ; label define RB210_VALUE_LABELS 1 "at work" 2 "unemployed" 3 "in retirement or early retirement" 4 "other inactive person" ; label define RB210_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (RB110 not = 1, 2, 3 or 4)" ; label define RB220_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (father is not a household member) or (RB110 not = 1, 2, 3 or 4)" ; label define RB230_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (mother is not a household member) or (RB110 not = 1, 2, 3 or 4)" ; label define RB240_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (spouse/partner is not a household member) or (RB110 not = 1,2, 3 or 4)" ; label define RB245_VALUE_LABELS 1 "current household member aged 16 and over (all hm aged 16+ interviewed)" 2 "selected respondent (only selected hm aged 16+ interviewed)" 3 "not selected respondent(only selected hm aged 16+ interviewed)" 4 "not eligible person(Hm aged less than 16)" ; label define RB245_F_VALUE_LABELS 1 "filled" -2 "not applicable (RB110 not = 1, 2, 3 or 4)" ; label define RB250_VALUE_LABELS 11 "information only completed from interview (information or interview completed)" 12 "information only completed from registers(information or interview completed) " 13 "information completed from both: interview and registers(information or interview completed) " 14 "information completed from full-record imputation (information or interview completed)" 21 "individual unable to respond and no proxy possible(Interview not completed though contact made)" 22 "failed to return self-completed questionnaire (Interview not completed though contact made)" 23 "refusal to cooperate(Interview not completed though contact made) " 31 "Individual not contacted because temporarily away and no proxy possible " 32 "Individual not contacted for other reasons" 33 "information not completed: reason unknown" ; label define RB250_F_VALUE_LABELS 1 "filled" -2 "na (RB245 not = 1,2 or 3)" ; label define RB260_VALUE_LABELS 1 "face to face interview-PAPI" 2 "face to face interview-CAPI" 3 "CATI, telephone interview" 4 "self-administered by respondent" 5 "proxy interview" ; label define RB260_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (RB250 not=11 or 13)" ; label define RB270_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (RB260 not=5)" ; label define RX010_VALUE_LABELS 80 "80 or over" ; label define RX020_VALUE_LABELS 80 "80 or over" ; label define RB050_F_VALUE_LABELS 1 "filled" ; label define RL010_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (person not admitted to pre-school because of her age)" ; label define RL020_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (person is not admitted to compulsory school)" ; label define RL030_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (person is neither at pre-school nor at school or is more than twelve years old" ; label define RL040_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (person is more than twelve years old)" ; label define RL050_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (person is more than twelve years old)" ; label define RL060_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (person is more than twelve years old)" ; label define RL070_F_VALUE_LABELS 1 "filled" -2 "na (children born in year N or persons aged more than 12 years old at the 3112N-1)" ; label define RX050_VALUE_LABELS 0 "no low work intensity" 1 "low work intensity" 2 "not applicable" ; label define RX060_VALUE_LABELS 0 "not severely deprived" 1 "severely deprived" ; label define RX070_VALUE_LABELS 000 "not ARP/not severely materially deprived/no low work intensity" 001 "not ARP/not severely materially deprived/low work intensity" 010 "not ARP/severely materially deprived/no low work intensity" 011 "not ARP/severely materially deprived/low work intensity" 100 "ARP/not severely materially deprived/no low work intensity" 101 "ARP/not severely materially deprived/low work intensity" 110 "ARP/severely materially deprived/no low work intensity" 111 "ARP/severely materially deprived/low work intensity" ; * Attachement of category labels to variable ; label values RB020_num RB020_num_VALUE_LABELS ; label values RB031_F RB031_F_VALUE_LABELS ; label values RB070 RB070_VALUE_LABELS ; label values RB070_F RB070_F_VALUE_LABELS ; label values RB080 RB080_VALUE_LABELS ; label values RB080_F RB080_F_VALUE_LABELS ; label values RB090 RB090_VALUE_LABELS ; label values RB090_F RB090_F_VALUE_LABELS ; label values RB200 RB200_VALUE_LABELS ; label values RB200_F RB200_F_VALUE_LABELS ; label values RB210 RB210_VALUE_LABELS ; label values RB210_F RB210_F_VALUE_LABELS ; label values RB220_F RB220_F_VALUE_LABELS ; label values RB230_F RB230_F_VALUE_LABELS ; label values RB240_F RB240_F_VALUE_LABELS ; label values RB245 RB245_VALUE_LABELS ; label values RB245_F RB245_F_VALUE_LABELS ; label values RB250 RB250_VALUE_LABELS ; label values RB250_F RB250_F_VALUE_LABELS ; label values RB260 RB260_VALUE_LABELS ; label values RB260_F RB260_F_VALUE_LABELS ; label values RB270_F RB270_F_VALUE_LABELS ; label values RX010 RX010_VALUE_LABELS ; label values RX020 RX020_VALUE_LABELS ; label values RX050 RX050_VALUE_LABELS ; label values RL010_F RL010_F_VALUE_LABELS ; label values RL020_F RL020_F_VALUE_LABELS ; label values RL030_F RL030_F_VALUE_LABELS ; label values RL040_F RL040_F_VALUE_LABELS ; label values RL050_F RL050_F_VALUE_LABELS ; label values RL060_F RL060_F_VALUE_LABELS ; label values RL070_F RL070_F_VALUE_LABELS ; label values RB050_F RB050_F_VALUE_LABELS ; label values RX060 RX060_VALUE_LABELS ; label values RX070 RX070_VALUE_LABELS ; compress ; save "`stata_file'", replace ; log close ; set more on #delimit cr