* 2009_panel_eu_silc_p_ver_2020_03.do * * STATA Command Syntax File * Stata 16.1; * * Transforms the EU-SILC CSV-data (as released by Eurostat) into a Stata systemfile * * EU-SILC Panel 2009 - / DOI: https://doi.org/10.2907/EUSILC2004-2018V.1 * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB – version of 2020-03" * * Personal data file: * This version of the EU-SILC has been delivered in form of seperate country files. * The following do-file transforms the raw data into a single Stata file using all available country files. * Country files are delivered in the format UDB_l*country_stub*09P.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: * L-2009 DIFFERENCES BETWEEN DATA COLLECTED.doc * * (c) GESIS 2020-12-02 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Heike Wirth; Florian Bains; Valentina Ponomarenko * https://www.gesis.org/gml/european-microdata/eu-silc/ * * Contact: heike.wirth@gesis.org /* Initialization commands */ clear capture log close set more off set linesize 250 set varabbrev off #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 where the CSV data files are stored * Change CSV_PATH to your file path (e.g.: C:/EU-SILC/Longitudinal 2005-2018) * Use forward slashes and keep path structure as delivered by Eurostat CSV_PATH/COUNTRY/YEAR; global csv_path "CSV_PATH" ; * The following command should contain the complete path and * name of the STATA file, usual file extension "dta". * Change STATA_FILENAME to your final filename ; local stata_file "STATA_FILENAME" ; * CONFIGURATION SECTION - End ; * There should be probably nothing to change below this line ; * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ; * Loop to open and convert csv country files into one dta file ; tempfile temp ; save `temp', emptyok ; foreach CC in AT BE BG CY CZ DK EE EL ES FI FR HU IE IS IT LT LU LV MT NL NO PL PT RO SE SI SK UK { ; cd "$csv_path/`CC'/2009" ; import delimited using "UDB_l`CC'09P.csv", case(upper) clear ; append using `temp', force ; save `temp', replace ; } ; * Countries in data file are sorted in alphanumeric order ; sort PB020 ; log using "`log_file'", replace text ; * Definition of variable labels ; label variable PB010 "Year of the survey" ; label variable PB020 "Country alphanumeric" ; label variable PB030 "Personal ID" ; label variable PB050 "Personal base weight" ; label variable PB050_F "Flag" ; label variable PB080 "Personal base weight for selected respondent" ; label variable PB080_F "Flag" ; label variable PB100 "Quarter of the personal interview" ; label variable PB100_F "Flag" ; label variable PB110 "Year of the personal interview" ; label variable PB110_F "Flag" ; label variable PB120 "Minutes to complete the personal questionnaire" ; label variable PB120_F "Flag" ; label variable PB130 "Quarter of birth" ; label variable PB130_F "Flag" ; label variable PB140 "Year of birth" ; label variable PB140_F "Flag" ; label variable PB150 "Sex" ; label variable PB150_F "Flag" ; label variable PB160 "Father ID" ; label variable PB160_F "Flag" ; label variable PB170 "Mother ID" ; label variable PB170_F "Flag" ; label variable PB180 "Spouse/partner ID" ; label variable PB180_F "Flag" ; label variable PB190 "Marital status" ; label variable PB190_F "Flag" ; label variable PB200 "Consensual union" ; label variable PB200_F "Flag" ; label variable PE040 "Highest ISCED level attained" ; label variable PE040_F "Flag" ; label variable PL030 "Self-defined current economic status" ; label variable PL030_F "Flag" ; label variable PL031 "Self-defined current economic status" ; label variable PL031_F "Flag" ; label variable PL020 "Actively looking for a job" ; label variable PL020_F "Flag" ; label variable PL025 "Available for work" ; label variable PL025_F "Flag" ; label variable PL040 "Status in employment" ; label variable PL040_F "Flag" ; label variable PL050 "Occupation (ISCO-88 (Com))" ; label variable PL050_F "Flag" ; label variable PL060 "Number of hours usually worked per week in main job" ; label variable PL060_F "Flag" ; label variable PL140 "Type of contract" ; label variable PL140_F "Flag" ; label variable PL160 "Change of job since last year" ; label variable PL160_F "Flag" ; label variable PL170 "Reason for change" ; label variable PL170_F "Flag" ; label variable PL180 "Most recent change in the individuals activity status" ; label variable PL180_F "Flag" ; label variable PL190 "When began regular first job" ; label variable PL190_F "Flag" ; label variable PL200 "Number of years spent in paid work" ; label variable PL200_F "Flag" ; label variable PL210A "Main activity on January" ; label variable PL210A_F "Flag" ; label variable PL210B "Main activity on February" ; label variable PL210B_F "Flag" ; label variable PL210C "Main activity on March" ; label variable PL210C_F "Flag" ; label variable PL210D "Main activity on april" ; label variable PL210D_F "Flag" ; label variable PL210E "Main activity on May" ; label variable PL210E_F "Flag" ; label variable PL210F "Main activity on June" ; label variable PL210F_F "Flag" ; label variable PL210G "Main activity on July" ; label variable PL210G_F "Flag" ; label variable PL210H "Main activity on August" ; label variable PL210H_F "Flag" ; label variable PL210I "Main activity on September" ; label variable PL210I_F "Flag" ; label variable PL210J "Main activity on October" ; label variable PL210J_F "Flag" ; label variable PL210K "Main activity on November" ; label variable PL210K_F "Flag" ; label variable PL210L "Main activity on December" ; label variable PL210L_F "Flag" ; label variable PL211A "Main activity on January"; label variable PL211A_F "Flag" ; label variable PL211B "Main activity on February"; label variable PL211B_F "Flag" ; label variable PL211C "Main activity on March"; label variable PL211C_F "Flag" ; label variable PL211D "Main activity on april"; label variable PL211D_F "Flag" ; label variable PL211E "Main activity on May"; label variable PL211E_F "Flag" ; label variable PL211F "Main activity on June"; label variable PL211F_F "Flag" ; label variable PL211G "Main activity on July"; label variable PL211G_F "Flag" ; label variable PL211H "Main activity on August"; label variable PL211H_F "Flag" ; label variable PL211I "Main activity on September"; label variable PL211I_F "Flag" ; label variable PL211J "Main activity on October"; label variable PL211J_F "Flag" ; label variable PL211K "Main activity on November"; label variable PL211K_F "Flag" ; label variable PL211L "Main activity on December"; label variable PL211L_F "Flag" ; label variable PH010 "General health" ; label variable PH010_F "Flag" ; label variable PH020 "Suffer from a chronic(long-standing) illness or condition" ; label variable PH020_F "Flag" ; label variable PH030 " Limitation in activities because of health problems" ; label variable PH030_F "Flag" ; label variable PY010N "Employee cash or near cash income(net)" ; label variable PY010N_F "Flag" ; label variable PY010N_I "Imputation factor" ; label variable PY020N "Non-Cash employee income(net)" ; label variable PY020N_F "Flag" ; label variable PY020N_I "Imputation Factor" ; label variable PY021N "Company car (in euros)" ; label variable PY021N_F "Flag" ; label variable PY035N "Contributions to individual private pension plans(net)" ; label variable PY035N_F "Flag" ; label variable PY035N_I "Imputation Factor" ; label variable PY050N " Cash benefits or losses from self-employment(net)" ; label variable PY050N_F "Flag" ; label variable PY050N_I "Imputation Factor" ; label variable PY070N "Value of goods produced by own-consumption (net)" ; label variable PY070N_F "Flag" ; label variable PY070N_I "Imputation factor" ; label variable PY080N "Pension from individual private plans(net)" ; label variable PY080N_F "Flag" ; label variable PY080N_I "Imputation factor" ; label variable PY090N "Unemployment benefits(net)" ; label variable PY090N_F "Flag" ; label variable PY090N_I "Imputation Factor" ; label variable PY100N "Old-age benefits(net)" ; label variable PY100N_F "Flag" ; label variable PY100N_I "Imputation Factor" ; label variable PY110N "Survivors Benefits (net)" ; label variable PY110N_F "Flag" ; label variable PY110N_I "Imputation Factor" ; label variable PY120N "Sickness Benefits(net)" ; label variable PY120N_F "Flag" ; label variable PY120N_I "Imputation Factor" ; label variable PY130N "Disability Benefits(net)" ; label variable PY130N_F "Flag" ; label variable PY130N_I "Imputation Factor" ; label variable PY140N "Education-related allowances" ; label variable PY140N_F "FlAG" ; label variable PY140N_I "Imputation factor" ; label variable PY010G "Employee Cash or near cash income(gross)" ; label variable PY010G_F "Flag" ; label variable PY010G_I "Imputation Factor" ; label variable PY020G "Non-Cash employee income(gross)" ; label variable PY020G_F "Flag" ; label variable PY020G_I "Imputation Factor" ; label variable PY021G "Company car (in euros)" ; label variable PY021G_F "Flag" ; label variable PY035G "Contributions to individual private pension plans(gross)" ; label variable PY035G_F "Flag" ; label variable PY035G_I "Imputation Factor" ; label variable PY050G "Cash benefits or losses from self-employment (gross)" ; label variable PY050G_F "Flag" ; label variable PY050G_I "Imputation Factor" ; label variable PY070G "Value of goods produced by own-consumption(gross)" ; label variable PY070G_F "Flag" ; label variable PY070G_I "Imputation Factor" ; label variable PY080G "Pension from individual private plans(gross)" ; label variable PY080G_F "Flag" ; label variable PY080G_I "Imputation Factor" ; label variable PY090G "Unemployment benefits (gross)" ; label variable PY090G_F "Flag" ; label variable PY090G_I "Imputation Factor" ; label variable PY100G "Old-age benefits(gross)" ; label variable PY100G_F "Flag" ; label variable PY100G_I "Imputation Factor" ; label variable PY110G "Survivor benefit" ; label variable PY110G_F "Flag" ; label variable PY110G_I "Imputation Factor" ; label variable PY120G "Sickness Benefits(gross)" ; label variable PY120G_F "Flag" ; label variable PY120G_I "Imputation Factor" ; label variable PY130G "Disability benefits(gross)" ; label variable PY130G_F "Flag" ; label variable PY130G_I "Imputation Factor" ; label variable PY140G "Education-related allowances(gross)" ; label variable PY140G_F "Flag" ; label variable PY140G_I "Imputation factor" ; label variable PX030 "Household ID" ; label variable PX040 "Respondent status" ; label variable PY021N_I "Imputation Factor" ; label variable PY021G_I "Imputation Factor" ; label variable PX020 "Age at the end of the income reference period" ; label variable PX010 "Exchange rate" ; * Definition of category labels ; label define PB050_F_VALUE_LABELS 1 "Filled" ; label define PB080_F_VALUE_LABELS 1 "Filled" -3 "not selected respondent" ; label define PB100_VALUE_LABELS 1 "January, February, March" 2 "April, May, June" 3 "July, August, September" 4 "October, November, December" ; label define PB100_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define PB110_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define PB120_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (information only extracted from registers)" ; label define PB130_VALUE_LABELS 1 "January,February,March" 2 "April, May, June" 3 "July, August, September" 4 "October, November, December" ; label define PB130_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define PB140_VALUE_LABELS 1928 "1928 or before" 1929 "PT: 1929 and before" 1933 "MT: 1929-1933" 1938 "MT: 1934-1938" 1943 "MT: 1939-1943" 1948 "MT: 1944-1948" 1953 "MT: 1949-1953" 1958 "MT: 1954-1958" 1963 "MT: 1959-1963" 1968 "MT: 1964-1968" 1973 "MT: 1969-1973" 1978 "MT: 1974-1978" 1983 "MT: 1979-1983" 1988 "MT: 1984-1988" 1993 "MT: 1989-1993" ; label define PB140_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define PB150_VALUE_LABELS 1 "male" 2 "female" ; label define PB150_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define PB160_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (father is not a household member)" ; label define PB170_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (mother is not a household member)" ; label define PB180_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (person has no spousepartner or spousepartner is not a household member)" ; label define PB190_VALUE_LABELS 1 "never married" 2 "married" 3 "separated" 4 "widowed" 5 "divorced" ; label define PB190_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define PB200_VALUE_LABELS 1 "yes, on a legal basis" 2 "yes, without a legal basis" 3 "no" ; label define PB200_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define PE040_VALUE_LABELS 0 "pre-primary education" 1 "primary education" 2 "lower secondary education" 3 "upper secondary education" 4 "post-secondary non-tertiary education" 5 "1st & 2nd stage of tertiary education " ; label define PE040_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "n.a. (the person has never been in education)" ; label define PL030_VALUE_LABELS 1 "working full-time" 2 "working part-time" 3 "Unemployed" 4 "Pupil, student, further training, unpaid work experience" 5 "In retirement or in early retirement or has given up business" 6 "Permanently disabled orand unfit to work" 7 "In compulsory military community or service" 8 "Fulfilling domestic tasks or care responsibilities" 9 "Other inactive person" ; label define PL030_F_VALUE_LABELS 1 "filled" -1 "missing" -5 "missing value of PL030 because PL031 is used" ; label define PL031_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or/and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL031_F_VALUE_LABELS 1 "filled" -1 "missing" -5 "missing value of PL031 because PL030 is still used" ; label define PL020_VALUE_LABELS 1 "Yes" 2 "No" ; label define PL020_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (PL031=1,2,3 or 4)" ; label define PL025_VALUE_LABELS 1 "Yes" 2 "No" ; label define PL025_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (PL020=2)" ; label define PL040_VALUE_LABELS 1 "Self-employed with employees" 2 "Self-employed without employees" 3 "Employee" 4 "Family worker" ; label define PL040_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (PL031 not=1,2,3 or 4 )" ; * PL030 not=1 or 2; label define PL050_VALUE_LABELS 01 "Armed Forces; MT:11-13 Legislators,senior officials & managers" 02 "MT:21-24 Professionals" 03 "MT:31-34 Technicians and associate professionals" 04 "MT:41-42 Clerks" 05 "MT:51-52 Service workers and shop and market sales workers" 06 "MT:61 Skilled agricultural and fishery workers" 07 "MT:71-74 Craft and related trades workers" 08 "MT:81-83 Plant and machine operators and assemblers" 09 "MT:91-93 Elementary occupations" 10 "MT:10 Armed forces" 11 "Legislators, senior officials and managers" 12 "corporate managers: only for PT, codes 11 & 12 grouped into 13" 13 "managers of small enterprises: only for PT, codes 11 & 12 grouped into 13" 21 "physical, mathematical and engineering professionals" 22 "life science and health professionals" 23 "teaching professionals" 24 "other professionals" 31" physical and engineering science associate professionals" 32 "life science and helath associate professionals" 33 "Teaching associate professionals" 34 "other associate professionals" 41 "office clerks" 42 "customer services clerks" 51 "personal and protective services workers" 52 "models, salespersons and demonstrators" 61 "skilled agricultural and fishery workers" 71 "extraction and building trades workers" 72 "metal, machinery and related trades workers" 73 "precision, handicraft, craft printing and related trades workers" 74 "other craft and related trades workers" 81 "stationary-plant and related operators" 82 "machine operators and assemblers" 83 "drivers and mobile plant operators" 91 "sales and services elementary occupations" 92 "agricultural, fishery and related labourers" 93 "labourers in ining, construction, manufacturing and transport" ; label define PL050_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "n.a." ; *PL031 not = 1, 2, 3 or 4; label define PL060_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "n.a. (PL031 not = 1, 2, 3 or 4)" -6 "Hours varying(even an average over 4 weeks is not possible)" ; label define PL140_VALUE_LABELS 1 "Permanent job work contract of unlimited duration" 2 "temporary jobwork contract of limited duration" ; label define PL140_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "n.a." -3 "not selected respondent" -4 "n.a.:person is employee (PL040 not=3) but has not any contract" ; label define PL160_VALUE_LABELS 1 "yes" 2 "no" ; label define PL160_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (PL031 not = 1, 2, 3 or 4)" -3 "not selected respondent" ; label define PL170_VALUE_LABELS 1 "To take up or seek better job" 2 "End of temporary contract" 3 "Obliged to stop by employer (business closure, redundancy, early retirement, dismissal etc." 4 "Sale or closure of ownfamily business" 5 "Child care and care for other dependant" 6 "Partners job required us to move to another area or marriage" 7 "Other reasons" ; label define PL170_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na" -3 "not selected respondent" ; * PL160 not=1 ; label define PL180_VALUE_LABELS 1 "employed-unemployed" 2 "employed-retired" 3 "employed-other inactive" 4 "unemployed-employed" 5 "unemployed - retired" 6 "unemployed - other inactive" 7 "retired - employed" 8 "retired - unemployed" 9 "retired - other inactive" 10 "other inactive - employed" 11 "other inactive - unemployed" 12 "other inactive - retired" ; label define PL180_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (no change since last year)" -3 "not selected respondent" ; label define PL190_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "n.a. (person never worked( PL031 not = 1, 2, 3 or 4))" -3 "not selected respondent" ; label define PL200_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "na (person never worked (PL031 not = 1, 2, 3 or 4 ))" -3 "not selected respondent" ; label define PL210A_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210A_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210B_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210B_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondend" -5 "missing value of PL210 because PL211 is used" ; label define PL210C_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210C_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210D_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210D_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210E_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210E_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210F_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210F_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210G_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210G_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210H_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210H_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210I_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210I_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210J_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210J_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210K_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210K_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL210L_VALUE_LABELS 1 "Employee (full-time)" 2 "Employee (part-time)" 3 "Self-employed (full-time)" 4 "Self-employed (part-time)" 5 "Unemployed" 6 "Retired" 7 "Student" 8 "Other inactive" 9 "Compulsory military service" ; label define PL210L_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL210 because PL211 is used" ; label define PL211A_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211A_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211B_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211B_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211C_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211C_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211D_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211D_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211E_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211E_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211F_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211F_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211G_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211G_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211H_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211H_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211I_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211I_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211J_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211J_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211K_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211K_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PL211L_VALUE_LABELS 1 "Employee working full-time" 2 "Employee working part-time" 3 "Self-employed working full-time (including family worker)" 4 "Self-employed working part-time (including family worker)" 5 "Unemployed" 6 "Pupil, student, further training, unpaid work experience" 7 "In retirement or in early retirement or has given up business" 8 "Permanently disabled or;and unfit to work" 9 "In compulsory military community or service" 10 "Fulfilling domestic tasks and care responsibilities" 11 "Other inactive person" ; label define PL211L_F_VALUE_LABELS 1 "filled" -1 "missing" -3 "not selected respondent" -5 "missing value of PL211 because PL210 is still used" ; label define PH010_VALUE_LABELS 1 "very good" 2 "good" 3 "fair" 4 "bad" 5 "very bad" ; label define PH010_F_VALUE_LABELS 1 "Filled" -1 "missing" -3 "not selected respondent" ; label define PH020_VALUE_LABELS 1 "yes" 2 "no" 8 "do not know (Germany only)" ; label define PH020_F_VALUE_LABELS 1 "Filled" -1 "missing" -3 "not selected respondent" ; label define PH030_VALUE_LABELS 1 "yes, strongly limited" 2 "yes, limited" 3 "no, not limited" 8 "do not know (Germany only)" ; label define PH030_F_VALUE_LABELS 1 "Filled" -1 "missing" -3 "not selected respondent" ; label define PY010N_F_VALUE_LABELS 0 "no income" 1 "net of tax on income at source and social contribution" 11 "collec. & recorded net of tax on income at source & social contrib." 12 "collec. net - recorded net of tax on income at source" 13 "collec. net - recorded net of tax on social contributions" 22 "collec. & recorded net of tax on income at source" 31 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 32 "collec. net of tax on social contrib.recorded net of tax on income at source" 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 43 "collec. gross-recorded net of tax on social contrib." 51 "collec. unknown-recorded net of tax on income & social contrib." 52 "collec. unknown-recorded net of tax on income at source" 53 "collec. unknown-recorded net of tax on social contrib." 55 "Type of collection & recording: unknown" -1 "missing" -2 "value not defined in data guidelines" -4 "amount included in another component" -5 "not filled: variable of gross series is filled" ; label define PY021N_VALUE_LABELS 0 "no income" ; label define PY035N_F_VALUE_LABELS 0 "no contribution" 1 "variable is filled" -1 "missing" -5 "not filled: variable of the gross series is filled" ; label define PY050N_VALUE_LABELS 0 "no income" ; label define PY010G_F_VALUE_LABELS 0 "no income" 1 "net of tax on income at source and social contribution" 2 "net of tax on income at source and social contribution" 3 "net of tax on social contribution" 4 "gross" 5 "unknown" -1 "missing" -5 "not filled:variable of net series is filled" ; label define PY020G_F_VALUE_LABELS 0 "no income" 1 "net of tax on income at source and social contribution" 2 "net of tax on income at source and social contribution" 3 "net of tax on social contribution" 4 "gross" 5 "unknown" -1 "missing" -2 "missing because the variable was not mandatory at that time (when PB010 < 2007, i.e. PB010=2003, 2004, 2005 or 2006)" -4 "amount included in another component" -5 "not filled:variable of net series is filled" ; label define PY021G_VALUE_LABELS 0 "no income" ; label define PY021G_F_VALUE_LABELS -5 "not filled: variable of net series is filled" -4 "amount included in another component" -1 "missing" 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" ; label define PY035G_F_VALUE_LABELS 0 "no contribution" 1 "variable is filled" -1 "missing" -5 "not filled: variable of net series is filled" ; label define PY050G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -5 "not filled:variable of net series is filled" ; label define PY070G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -2 "not defined in variable description unique to Norway" -5 "not filled:variable of net series is filled" ; label define PY080G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -5 "not filled:variable of net series is filled" ; label define PY090G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -5 "not filled:variable of net series is filled" ; label define PY100G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -4 "amount included in another component" -5 "not filled:variable of net series is filled" ; label define PY110G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -4 "amount included in another component" -5 "not filled:variable of net series is filled" ; label define PY120G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -4 "amount included in another component" -5 "not filled:variable of net series is filled" ; label define PY130G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -4 "amount included in another component" -5 "not filled:variable of net series is filled" ; label define PY140G_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source and social contribution+nc" 2 "collec. net of tax on income at source+nc" 3 "collec. net of tax on social contributions+nc" 4 "collec. gross" 5 "unknown" -1 "missing" -5 "not filled:variable of net series is filled" ; label define PX040_VALUE_LABELS 1 "current household member aged >=16 (All hhld members aged >=16 are interviewed)" 2 "selected respondent(Only selected hhld member aged >= 16 is interviewed)" 3 "not selected respondent (Only selected hhld member aged >= 16 is interviewed)" 4 "not eligible person (Hhld members aged < 16 at the time of interview)" ; * Attachement of category labels to variables ; label values PB050_F PB050_F_VALUE_LABELS ; label values PB080_F PB080_F_VALUE_LABELS ; label values PB100 PB100_VALUE_LABELS ; label values PB100_F PB100_F_VALUE_LABELS ; label values PB110_F PB110_F_VALUE_LABELS ; label values PB120_F PB120_F_VALUE_LABELS ; label values PB130 PB130_VALUE_LABELS ; label values PB130_F PB130_F_VALUE_LABELS ; label values PB140 PB140_VALUE_LABELS ; label values PB140_F PB140_F_VALUE_LABELS ; label values PB150 PB150_VALUE_LABELS ; label values PB150_F PB150_F_VALUE_LABELS ; label values PB160_F PB160_F_VALUE_LABELS ; label values PB170_F PB170_F_VALUE_LABELS ; label values PB180_F PB180_F_VALUE_LABELS ; label values PB190 PB190_VALUE_LABELS ; label values PB190_F PB190_F_VALUE_LABELS ; label values PB200 PB200_VALUE_LABELS ; label values PB200_F PB200_F_VALUE_LABELS ; label values PE040 PE040_VALUE_LABELS ; label values PE040_F PE040_F_VALUE_LABELS ; label values PL030 PL030_VALUE_LABELS ; label values PL030_F PL030_F_VALUE_LABELS ; label values PL031 PL031_VALUE_LABELS ; label values PL031_F PL031_F_VALUE_LABELS ; label values PL020 PL020_VALUE_LABELS ; label values PL020_F PL020_F_VALUE_LABELS ; label values PL025 PL025_VALUE_LABELS ; label values PL025_F PL025_F_VALUE_LABELS ; label values PL040 PL040_VALUE_LABELS ; label values PL040_F PL040_F_VALUE_LABELS ; label values PL050 PL050_VALUE_LABELS ; label values PL050_F PL050_F_VALUE_LABELS ; label values PL060_F PL060_F_VALUE_LABELS ; label values PL140 PL140_VALUE_LABELS ; label values PL140_F PL140_F_VALUE_LABELS ; label values PL160 PL160_VALUE_LABELS ; label values PL160_F PL160_F_VALUE_LABELS ; label values PL170 PL170_VALUE_LABELS ; label values PL170_F PL170_F_VALUE_LABELS ; label values PL180 PL180_VALUE_LABELS ; label values PL180_F PL180_F_VALUE_LABELS ; label values PL190_F PL190_F_VALUE_LABELS ; label values PL200_F PL200_F_VALUE_LABELS ; label values PL210A PL210A_VALUE_LABELS ; label values PL210A_F PL210A_F_VALUE_LABELS ; label values PL210B PL210B_VALUE_LABELS ; label values PL210B_F PL210B_F_VALUE_LABELS ; label values PL210C PL210C_VALUE_LABELS ; label values PL210C_F PL210C_F_VALUE_LABELS ; label values PL210D PL210D_VALUE_LABELS ; label values PL210D_F PL210D_F_VALUE_LABELS ; label values PL210E PL210E_VALUE_LABELS ; label values PL210E_F PL210E_F_VALUE_LABELS ; label values PL210F PL210F_VALUE_LABELS ; label values PL210F_F PL210F_F_VALUE_LABELS ; label values PL210G PL210G_VALUE_LABELS ; label values PL210G_F PL210G_F_VALUE_LABELS ; label values PL210H PL210H_VALUE_LABELS ; label values PL210H_F PL210H_F_VALUE_LABELS ; label values PL210I PL210I_VALUE_LABELS ; label values PL210I_F PL210I_F_VALUE_LABELS ; label values PL210J PL210J_VALUE_LABELS ; label values PL210J_F PL210J_F_VALUE_LABELS ; label values PL210K PL210K_VALUE_LABELS ; label values PL210K_F PL210K_F_VALUE_LABELS ; label values PL210L PL210L_VALUE_LABELS ; label values PL210L_F PL210L_F_VALUE_LABELS ; label values PL211A PL211A_VALUE_LABELS ; label values PL211A_F PL211A_F_VALUE_LABELS ; label values PL211B PL211B_VALUE_LABELS ; label values PL211B_F PL211B_F_VALUE_LABELS ; label values PL211C PL211C_VALUE_LABELS ; label values PL211C_F PL211C_F_VALUE_LABELS ; label values PL211D PL211D_VALUE_LABELS ; label values PL211D_F PL211D_F_VALUE_LABELS ; label values PL211E PL211E_VALUE_LABELS ; label values PL211E_F PL211E_F_VALUE_LABELS ; label values PL211F PL211F_VALUE_LABELS ; label values PL211F_F PL211F_F_VALUE_LABELS ; label values PL211G PL211G_VALUE_LABELS ; label values PL211G_F PL211G_F_VALUE_LABELS ; label values PL211H PL211H_VALUE_LABELS ; label values PL211H_F PL211H_F_VALUE_LABELS ; label values PL211I PL211I_VALUE_LABELS ; label values PL211I_F PL211I_F_VALUE_LABELS ; label values PL211J PL211J_VALUE_LABELS ; label values PL211J_F PL211J_F_VALUE_LABELS ; label values PL211K PL211K_VALUE_LABELS ; label values PL211K_F PL211K_F_VALUE_LABELS ; label values PL211L PL211L_VALUE_LABELS ; label values PL211L_F PL211L_F_VALUE_LABELS ; label values PH010 PH010_VALUE_LABELS ; label values PH010_F PH010_F_VALUE_LABELS ; label values PH020 PH020_VALUE_LABELS ; label values PH020_F PH020_F_VALUE_LABELS ; label values PH030 PH030_VALUE_LABELS ; label values PH030_F PH030_F_VALUE_LABELS ; label values PY010N_F PY020N_F PY021N_F PY050N_F PY070N_F PY080N_F PY090N_F PY100N_F PY110N_F PY120N_F PY130N_F PY140N_F PY010N_F_VALUE_LABELS ; label values PY021N PY021N_VALUE_LABELS ; label values PY035N_F PY035N_F_VALUE_LABELS ; label values PY050N PY050N_VALUE_LABELS ; label values PY010G_F PY010G_F_VALUE_LABELS ; label values PY020G_F PY020G_F_VALUE_LABELS ; label values PY021G PY021G_VALUE_LABELS ; label values PY021G_F PY021G_F_VALUE_LABELS ; label values PY035G_F PY035G_F_VALUE_LABELS ; label values PY050G_F PY050G_F_VALUE_LABELS ; label values PY070G_F PY070G_F_VALUE_LABELS ; label values PY080G_F PY080G_F_VALUE_LABELS ; label values PY090G_F PY090G_F_VALUE_LABELS ; label values PY100G_F PY100G_F_VALUE_LABELS ; label values PY110G_F PY110G_F_VALUE_LABELS ; label values PY120G_F PY120G_F_VALUE_LABELS ; label values PY130G_F PY130G_F_VALUE_LABELS ; label values PY140G_F PY140G_F_VALUE_LABELS ; label values PX020 PX020_VALUE_LABELS ; label values PX040 PX040_VALUE_LABELS ; label data "Personal data file 2009" ; compress ; save "`stata_file'", replace ; log close ; set more on #delimit cr