* Encoding: windows-1252. ****************************************************************************************. * 2006_c_y_panel_eu_silc_pers_data_p.sps * * SPSS Command Syntax File * Release 24.0.0.1 * * Transforms the EU-SILC CSV-data (as released by Eurostat) into an SPSS-Systemfile * * EU-SILC - Panel 2006_c_y * Personal data file: * This version of the EU-SILC has been delivered in form of seperate country files. * The following syntax transformes the raw data into one SPSS file using all available country files. * Country files are delivered in the format UDB_l*country_stub*06P.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-2006 DIFFERENCES BETWEEN DATA COLLECTED.doc * * (c) GESIS 2018-06-08 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Heike Wirth; Anika Herter * * https://www.gesis.org/gml/european-microdata/eu-silc/ * * Contact: heike.wirth@gesis.org ***************************************************************************************. set decimal=DOT. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode=OFF. * The csv file for Greece is not appropriately named. The following command changes the name on the hardrive in order for the macro to work properly. * The renaming is permanent and needs only to be executed once for every file. * Change csv_data_path_GR to the path where the csv file for Greece is stored. HOST COMMAND =['RENAME "csv_data_path_EL\UDB_lGR06P.csv" UDB_lEL06P.csv']. *----------------------------------------------------------------- Start definition macro ---------------------------------------------------------------. DEFINE !L2006_nP (). *-------------------------------------------------------- CONFIGURATION SECTION - Start ------------------------------------------------------. * The following command should contain the complete path where the CSV data files are stored; * 1) Change CSV_PATH to your file path; (E.g. C:\EU-SILC\Longitudinal 2005-2015\); * 2) But keep path structure as delivered by Eurostat CSV_PATH/COUNTRY/YEAR . !LET !csv_path ='CSV_PATH' * The following command should contain the complete path where the SPSS data files should be stored; * Change SPSS_PATH to your file path. !LET !spss_path ='SPSS_PATH' * The following command should contain the name of the SPSS data file (specify without .sav extension); * Change SPSS_FILENAME to your final filename. !LET !finalfile='SPSS_FILENAME' *----------------------------------------------------------- CONFIGURATION SECTION - End ---------------------------------------------------------. * There should be probably nothing to change below this line. * ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------. *------------------------------------------------------------- Definition of country stubs -----------------------------------------------------------------------. !LET !csvfiles= 'UDB_lAT UDB_lBE UDB_lCY UDB_lCZ UDB_lDK UDB_lEE UDB_lEL UDB_lES' + ' UDB_lFI UDB_lFR UDB_lHU UDB_lIE UDB_lIS UDB_lIT UDB_lLT UDB_lLU UDB_lLV UDB_lNL' + ' UDB_lNO UDB_lPL UDB_lPT UDB_lSE UDB_lSI UDB_lSK UDB_lUK'. !LET !CC= 'AT BE CY CZ DK EE EL ES FI FR HU IE IS IT LT LU LV NL NO PL PT SE SI SK UK'. !DO !i !IN (!CC) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2006\UDB_l',!i,'06P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4.0 PB020 A2 PB030 F7.0 PB050 COMMA8.0 PB050_F F1.0 PB080 COMMA8.0 PB080_F F2.0 PB100 F1.0 PB100_F F1.0 PB110 F4.0 PB110_F F1.0 PB120 F2.0 PB120_F F2.0 PB130 F1.0 PB130_F F1.0 PB140 F4.0 PB140_F F1.0 PB150 F1.0 PB150_F F1.0 PB160 F7.0 PB160_F F2.0 PB170 F7.0 PB170_F F2.0 PB180 F7.0 PB180_F F2.0 PB190 F1.0 PB190_F F1.0 PB200 F1.0 PB200_F F1.0 PE040 F1.0 PE040_F F1.0 PL030 F1.0 PL030_F F1.0 PL020 F1.0 PL020_F F2.0 PL025 F1.0 PL025_F F2.0 PL040 F1.0 PL040_F F2.0 PL050 F2.0 PL050_F F2.0 PL060 F2.0 PL060_F F2.0 PL140 F1.0 PL140_F F2.0 PL160 F1.0 PL160_F F2.0 PL170 F1.0 PL170_F F2.0 PL180 F2.0 PL180_F F2.0 PL190 F2.0 PL190_F F2.0 PL200 F2.0 PL200_F F2.0 PL210A F1.0 PL210A_F F1.0 PL210B F1.0 PL210B_F F1.0 PL210C F1.0 PL210C_F F1.0 PL210D F1.0 PL210D_F F1.0 PL210E F1.0 PL210E_F F1.0 PL210F F1.0 PL210F_F F1.0 PL210G F1.0 PL210G_F F1.0 PL210H F1.0 PL210H_F F1.0 PL210I F1.0 PL210I_F F1.0 PL210J F1.0 PL210J_F F1.0 PL210K F1.0 PL210K_F F1.0 PL210L F1.0 PL210L_F F1.0 PH010 F1.0 PH010_F F1.0 PH020 F1.0 PH020_F F1.0 PH030 F1.0 PH030_F F2.0 PY010N COMMA8.0 PY010N_F F2.0 PY010N_I COMMA9.0 PY020N COMMA4.2 PY020N_F F2.0 PY020N_I COMMA9.0 PY035N COMMA7.0 PY035N_F F1.0 PY035N_I COMMA9.0 PY050N COMMA8.0 PY050N_F F2.0 PY050N_I COMMA9.0 PY070N COMMA7.0 PY070N_F F2.0 PY070N_I COMMA9.0 PY080N COMMA4.0 PY080N_F F1.0 PY080N_I COMMA9.0 PY090N COMMA7.0 PY090N_F F2.0 PY090N_I COMMA9.0 PY100N COMMA8.0 PY100N_F F2.0 PY100N_I COMMA9.0 PY110N COMMA8.0 PY110N_F F2.0 PY110N_I COMMA9.0 PY120N COMMA7.0 PY120N_F F2.0 PY120N_I COMMA9.0 PY130N COMMA8.0 PY130N_F F2.0 PY130N_I COMMA9.0 PY140N COMMA7.0 PY140N_F F2.0 PY140N_I COMMA9.0 PY010G COMMA8.0 PY010G_F F1.0 PY010G_I COMMA9.0 PY020G COMMA4.2 PY020G_F F2.0 PY020G_I COMMA9.0 PY035G COMMA7.0 PY035G_F F1.0 PY035G_I COMMA9.0 PY050G COMMA8.0 PY050G_F F1.0 PY050G_I COMMA9.0 PY070G COMMA7.0 PY070G_F F1.0 PY070G_I COMMA9.0 PY080G COMMA4.0 PY080G_F F1.0 PY080G_I COMMA9.0 PY090G COMMA7.0 PY090G_F F1.0 PY090G_I COMMA9.0 PY100G COMMA8.0 PY100G_F F1.0 PY100G_I COMMA9.0 PY110G COMMA8.0 PY110G_F F1.0 PY110G_I COMMA9.0 PY120G COMMA7.0 PY120G_F F1.0 PY120G_I COMMA9.0 PY130G COMMA8.0 PY130G_F F1.0 PY130G_I COMMA9.0 PY140G COMMA7.0 PY140G_F F1.0 PY140G_I COMMA9.0 PX030 F3.0 PX040 F1.0 PX020 F2.0 PX010 COMMA9.0. Variable labels PB010 'Year of the Survey'/ PB020 'Country'/ PB030 'Personal ID'/ PB050 'Personal base weight' PB050_F 'Flag' PB080 'Personal base weight for selected respondent' PB080_F 'Flag' PB100 'Quarter of the personal interview'/ PB100_F 'Flag'/ PB110 'Year of the personal interview'/ PB110_F 'Flag'/ PB120 'Minutes to complete the personal interview'/ PB120_F 'Flag'/ PB130 'Quarter of birth'/ PB130_F 'Flag'/ PB140 'Year of birth (Bottom coding: year of survey -80 and below)'/ PB140_F 'Flag'/ PB150 'Sex'/ PB150_F 'Flag'/ PB160 'Father ID'/ PB160_F 'Flag'/ PB170 'Mother ID'/ PB170_F 'Flag'/ PB180 'Spouse/partner ID'/ PB180_F 'Flag'/ PB190 'Marital status'/ PB190_F 'Flag'/ PB200 'Consensual union'/ PB200_F 'Flag'/ PE040 'Highest ISCED level attained'/ PE040_F 'Flag'/ PL030 'Self-defined current economic status'/ PL030_F 'Flag'/ PL020 'Actively looking for a job'/ PL020_F 'Flag'/ PL025 'Available for work'/ PL025_F 'Flag'/ PL040 'Status in employment'/ PL040_F 'Flag'/ PL050 'Occupation (ISCO-88 (Com))'/ PL050_F 'Flag'/ PL060 'Number of hours usually worked per week in main job'/ PL060_F 'Flag'/ PL140 'Type of contract'/ PL140_F 'Flag' / PL160 'Change of job since last year'/ PL160_F 'Flag' / PL170 'Reason for change'/ PL170_F 'Flag'/ PL180 'Most recent change in the individuals activity status'/ Pl180_F 'Flag' / PL190 'When began regular first job'/ PL190_F 'Flag' / Pl200 'Number of years spent in paid work'/ pl200_F 'Flag' / PL210a 'Main activity on January'/ PL210a_F 'Flag'/ PL210B 'Main activity on February'/ PL210B_F 'Flag' / PL210C 'Main activity on March'/ PL210c_F 'Flag'/ PL210D 'Main activity on April'/ PL210D_F 'Flag'/ PL210E 'Main activity on May'/ Pl210E_F 'Flag' / PL210F 'Main activity on June'/ PL210f_F 'Flag' / PL210g 'Main activity on July'/ PL210g_F 'Flag' / PL210h 'Main activity on August'/ pl210h_F 'Flag'/ PL210I 'Main activity on September'/ PL210I_F 'Flag'/ PL210J 'Main activity on October'/ PL210J_F 'Flag'/ PL210K 'Main activity on November/' PL210K_F 'Flag'/ PL210L 'Main activity on December'/ PL210L_F 'Flag' / PH010 'General health'/ PH010_F 'Flag'/ PH020 'Suffer from a chronic(long-standing) illness or condition'/ PH020_F 'Flag'/ PH030 ' Limitation in activities because of health problems'/ PH030_F 'Flag' / PY010N 'Employee cash or near cash income(net)'/ PY010N_F 'Flag'/ PY010N_I 'Imputation factor'/ PY020N 'Non-Cash employee income(net)'/ PY020N_F 'Flag'/ PY020N_I 'Imputation Factor'/ PY035N 'Contributions to individual private pension plans(net)'/ PY035N_F 'Flag' / PY035N_I 'Imputation Factor'/ PY050N ' Cash benefits or losses from self-employment(net)'/ PY050N_F 'Flag'/ PY050N_I 'Imputation Factor'/ PY070N 'Value of goods produced by own-consumption (net)'/ PY070n_F 'Flag'/ PY070n_I 'Imputation factor'/ PY080N 'Pension from individual private plans(net)'/ PY080N_F 'Flag'/ PY080N_I 'Imputation factor'/ PY090N 'Unemployment benefits(net)'/ PY090N_F 'Flag'/ PY090N_I 'Imputation Factor'/ PY100N 'Old-age benefits(net)'/ PY100N_F 'Flag'/ PY100N_I 'Imputation Factor'/ PY110N 'Survivors Benefits (net)'/ PY110N_F 'Flag'/ PY110N_I 'Imputation Factor'/ PY120N 'Sickness Benefits(net)'/ PY120N_F 'Flag'/ PY120N_I 'Imputation Factor'/ PY130N 'Disability Benefits(net)'/ PY130N_F 'Flag'/ PY130N_I 'Imputation Factor'/ PY140N 'Education-related allowances'/ PY140N_F 'Flag'/ PY140n_I 'Imputation factor'/ PY010G 'Employee Cash or near cash income(gross)'/ PY010G_F 'Flag'/ PY010G_I 'Imputation Factor'/ PY020G 'Non-Cash employee income(gross)'/ PY020G_F 'Flag'/ PY020G_I 'Imputation'/ PY035G 'Contributions to individual private pension plans(gross)'/ PY035G_F 'Flag'/ PY035G_I 'Imputation Factor'/ PY050G 'Cash benefits or losses from self-employment (gross)'/ PY050G_F 'Flag'/ PY050G_I 'Imputation Factor'/ PY070G 'Value of goods produced by own-consumption(gross)'/ PY070G_F 'Flag'/ PY070G_I 'Imputation Factor'/ PY080G 'Pension from individual private plans(gross)'/ PY080G_F 'Flag'/ PY080G_I 'Imputation Factor'/ PY090G 'Unemployment benefits (gross)'/ PY090G_F 'Flag'/ PY090G_I 'Imputation Factor'/ PY100G 'Old-age benefits(gross)'/ PY100G_F 'Flag'/ PY100G_I 'Imputation Factor'/ PY110G 'Survivors benefits'/ PY110G_F 'Flag'/ PY110G_I 'Imputation factor'/ PY120G 'Sickness Benefits(gross)'/ PY120G_F 'Flag'/ PY120G_I 'Imputation Factor'/ PY130G 'Disability benefits(gross)'/ PY130G_F 'Flag'/ PY130G_I 'Imputation Factor'/ PY140G 'Education-related allowances(gross)'/ PY140G_F 'Flag'/ PY140G_I 'Imputation factor'/ PX030 'Household ID'/ PX040 'Respondent status'/ PX020 'Age at the end of the income reference period'/ PX010 'Exchange rate'. value labels PB020 'BE' "Belgique" 'DK' "Danmark" 'GR' "Ellada" 'ES' "Espana" 'FR' "France" 'IE' "Ireland" 'IT' "Italia" 'LU' "Luxembourg" 'NL' "Nederland" 'AT' "Oesterreich" 'PT' "Portugal" 'FI' "Suomi" 'SE' "Sverige" 'UK' "United Kingdom" 'CY' "Cyprus" 'CZ' "Czech Republic" 'EE' "Estonia" 'HU' "Hungary" 'LV' "Latvia" 'LT' "Lithuania" 'PL' "Poland" 'SK' "Slovak Republic" 'SI' "Slovenia" 'IS' "Iceland" 'NO' "Norway"/ PB050_F 1 'Filled'/ PB080_F 1 'Filled' -2 'not applicable (country does not use the selected respondent model)' -3 'not selected respondent'/ PB100 1 'January,February,March' 2 'April, May, June' 3 'July, August, September' 4 'October, November, December'/ PB100_F 1 'filled' -1 'missing'/ PB110_F 1 'filled' -1 'missing'/ PB120_F 1 'filled' -1 'missing' -2 'na (information only extracted from registers)'/ PB130 1 'January,February,March' 2 'April, May, June' 3 'July, August, September' 4 'October, November, December'/ PB130_F 1 'filled' -1 'missing'/ PB140_F 1 'filled' -1 'missing'/ PB150 1 'male' 2 'female'/ PB150_F 1 'filled' -1 'missing'/ PB160_F 1 'filled' -1 'missing' -2 'na (father is not a household member)'/ PB170_F 1 'filled' -1 'missing' -2 'na (mother is not a household member)'/ PB180_F 1 'filled' -1 'missing' -2 'not applicable (person has no spouse/partner or spouse/partner is not a household member)'/ PB190 1 ' never married' 2 'married' 3 'separated' 4 'widowed' 5 'divorced'/ PB190_F 1 'filled' -1 'missing'/ PB200 1 'yes, on a legal basis' 2 'yes, without a legal basis' 3 'no'/ PB200_F 1 'filled' -1 'missing'/ PE040 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 '/ PE040_F 1 'filled' -1 'missing' -2 'n.a. (the person has never been in education)'/ PL030 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 or/and unfit to work' 7 'In compulsory military community or service' 8 'Fulfilling domestic tasks or care responsibilities' 9 'Other inactive person'/ PL030_F 1 'filled' -1 'missing'/ Pl020 1 'Yes' 2 'No'/ PL020_F 1 'filled' -1 'missing' -2 'na (PL030=1 or 2)'/ PL025 1 'Yes' 2 'No'/ PL025_F 1 'filled' -1 'missing' -2 'na (PL020=2)'/ PL040 1 'Self-employed with employees' 2 'self-employed without employees' 3 'employee' 4 'family worker'/ PL040_F 1 'filled' -1 'missing' -2 'na' /* PL030 not=1 or 2 and PL015 not=1 and PL035 not=1*// PL050 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' 01 'armed forces'/ PL050_F 1 'filled' -1 'missing' -2 'n.a.' /*PL030 not=1 or 2 and PL015 not=1 and PL035 not=1*// PL060_F 1 'filled' -1 'missing' -2 'n.a.' -6 'Hours varying'/ PL140 1 'Permanent job/ work contract of unlimited duration' 2 'temporary job/work contract of limited duration'/ PL140_F 1 'filled' -1 'missing' -2 'n.a. *PL040 not=3*' -3 'not selected respondent' -4 'n.a.:person is employee (PL040 not=3) but has not any contract' / PL160 1 'yes' 2 'no'/ PL160_F 1 'filled' -1 'missing' -2 'na' /* PL30 not=1 or 2 */ -3 'not selected respondent'/ PL170 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 own/family business' 5 'Child care and care for other dependant' 6 'Partners job required us to move to another area or marriage' 7 'Other reasons'/ Pl170_F 1 'filled' -1 'missing' -2 'na' /* PL60 not=1 */ -3 'not selected respondent'/ PL180 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'/ PL180_F 1 'filled' -1 'missing' -2 'na (no change since last year)' -3 'not selected respondent'/ PL190_F 1 'filled' -1 'missing' -2 'n.a. (person never worked)' -3 'not selected respondent'/ PL200_F 1 'filled' -1 'missing' -2 'na (person never worked)' -3 'not selected respondent'/ PL210A 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'/ PL210A_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210B 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'/ PL210B_F 1 'filled' -1 'missing' -3 'not selected respondend'/ PL210C 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'/ PL210C_f 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210D 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'/ PL210D_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210E 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'/ PL210E_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210F 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'/ PL210F_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210G 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'/ PL210G_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210H 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'/ PL210H_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210I 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'/ PL210I_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210J 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'/ PL210J_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210K 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'/ PL210K_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210L 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'/ PL210L_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PH010 1 'very good' 2 'good' 3 'fair' 4 'bad' 5 'very bad'/ PH010_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH020 1 'yes' 2 'no'/ PH020_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH030 1 'yes, strongly limited' 2 'yes, limited' 3 'no, not limited'/ PH030_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PY010N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 13 'collec. net of tax on income at source & social contrib/record. net of tax on income at source' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 43 'collected gross/recorded net of tax on social contrib.' 51 'collected unknown/recorded net of tax on income & social contrib.' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ PY020N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled' -2 'value not defined in the data documentation'/ PY035N_F 0 'no contribution' 1 'variable is filled' -1 'missing' -5 'not filled: variable of the gross series is filled'/ PY050N 0 'no income'/ PY050N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 21 'collec. net of tax on income at source/recorded net of tax on income & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 43 'collected gross/recorded net of tax on social contrib.' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY070N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled' -2 'value not defined in the data documentation'/ Py080N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY090N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 21 'collec. net of tax on income at source/recorded net of tax on income & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 43 'collected gross/recorded net of tax on social contrib.' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY100N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY110N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY120N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY130N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY140N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY010G_F 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'/ PY020G_F 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' -4 'amount included in another component' -5 'not filled:variable of net series is filled' -2 'value not defined in data documentation'/ PY035G_F 0 'no contribution' 1 'variable is filled' -1 'missing' -5 'not filled: variable of net series is filled'/ PY050G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY070G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -2 'not defined in variable description; unique to Norway' -5 'not filled:variable of net series is filled'/ PY080G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY090G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY100G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY110G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY120G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY130G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY140G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PX020 80 '80 and over'/ PX040 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)'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_l',!i,'06P.sav')). !DOEND. *-------------------------------------------------- Compile and save final file -----------------------------------------------------------------------------------. !LET !firstfile=1. !DO !filestub !IN (!csvfiles). !IF (!firstfile=1) !THEN GET FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'06P.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'06P.sav')). !IFEND. !DOEND. SAVE OUTFILE=!QUOTE(!CONCAT(!spss_path,!finalfile,'.sav')). *--------------------------------------------------------Delete single country files -------------------------------------------------------------------------------. !DO !filestub !IN (!csvfiles). ERASE FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'06P.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !L2006_nP.