*-----------------------------------------------------------------------------------------------------------------------------. * REGISTER CENSUS 2011 * Dataset FAMILY * * This SPSS routine adds variable and value labels. * It works with Register Census 2011 microdata, prepared by SORS in April 2014. * Your dataset might have a smaller set of variables. * * Version 1, December 2014 * IBM SPSS Statistics 22.0 * * Social Science Data Archives, University of Ljubljana * Sebastian Kocar * http://www.adp.fdv.uni-lj.si/ * Contact:arhiv.podatkov@fdv.uni-lj.si * * This SPSS code is protected under the Creative Commons licence. *-----------------------------------------------------------------------------------------------------------------------------. *--- CONFIGURATION SECTION --- START --- * The following command should contain the complete path and * name of the .txt file to be read (e.g. 'C:/Census2011_v1.txt') * Change TXT_DATA_PATH to your filename, below: FILE HANDLE txtfile/NAME='TXT_DATA_PATH'. * The following command should contain the complete path and * name of the .sav file to be saved (e.g. 'C:/Census2011_v1.sav') * Chabge SAV_DATA_PATH to your filename, below: FILE HANDLE savfile/NAME='SAV_DATA_PATH'. *--- CONFIGURATION SECTION --- END --- *-----------------------------------------------------------------------------------------------------------------------------. *----------------------------------------------Start data processing------------------------------------------------. * Firstly we use SET LOCALE command to import dots as decimal separators. SET LOCALE='sl_SI'. SHOW LOCALE. SET UNICODE=YES. *Then we import ASCII dataset (space delimited) into SPSS package. GET DATA /TYPE=TXT /FILE="txtfile" /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= ID_DRUZ F6.0 TIP_DRUZ F2.0 DRUZ_OS F1.0 VZP_DRUZ_IND F1.0 TIP_VZP_DRUZ F1.0 ID_GO F6.0 TIP_GO F1.0 GO_OS F1.0 ST_DRUZ_GO F1.0 STAR_M F2.0 STAR_O F2.0 ST_OT_DRUZ F1.0 STAR_OT_1 F2.0 STAR_OT_2 F2.0 STAR_OT_3 F2.0 STAR_OT_4 F2.0 STAR_OT_5 F1.0 STAR_OT_6 F1.0 STAR_OT_7 F1.0 STAR_OT_8 F1.0 STAR_OT_9 F1.0 STAR_OT_10 F1.0 STAR_OT_11 F1.0 STAR_OT_12 F1.0 STAR_OT_13 F1.0 STAR_MIN F2.0 STAR_MAX F2.0 ST_OT_DRUZ_0_5 F1.0 ST_OT_DRUZ_0_14 F1.0 ST_OT_DRUZ_0_17 F1.0 ST_OT_DRUZ_0_24 F1.0 TIP_DRUZ_OT_0_5 F1.0 TIP_DRUZ_OT_0_14 F1.0 TIP_DRUZ_OT_0_17 F1.0 TIP_DRUZ_OT_0_24 F1.0 ZS_M F1.0 ZS_O F1.0 DRZ_M F3.0 DRZ_O F3.0 PREB_M F1.0 PREB_O F1.0 DRZ_HOM_ZP F1.0 AKT_M F2.0 AKT_O F2.0 AKT_ZP F1.0 IZB_M F5.0 IZB_O F5.0 IZB_ZP F1.0 PRIS_M F2.0 PRIS_O F2.0 PRIS_ZP_2 F2.0 ROJ_IND F1.0 ROJ_ST F1.0 MATI F1.0 OCE F1.0 STARSI F2.0 HS_MID_NAST F1.0 ID_KOHEZIJSKA F1.0 ID_STATISTICNA F2.0 ID_OBCINA F3.0 NA_ID F3.0 TIP_NASELJA A3 VEL_NAS F2.0. CACHE. EXECUTE. * We then add variable labels. VARIABLE LABELS ID_DRUZ "Family ID" TIP_DRUZ "Type of family" DRUZ_OS "Family size" VZP_DRUZ_IND "Reconstituted family indicator" TIP_VZP_DRUZ "Type of reconstituted family" ID_GO "Household ID" TIP_GO "Type of household" GO_OS "Household size" ST_DRUZ_GO "Number of families in the household" STAR_M "Age of mother / spouse / partner / grandmother" STAR_O "Age of father / spouse / partner / grandfather" ST_OT_DRUZ "Number of children in the family" STAR_OT_1 "Age of first child" STAR_OT_2 "Age of second child" STAR_OT_3 "Age of third child" STAR_OT_4 "Age of fourth child" STAR_OT_5 "Age of fifth child" STAR_OT_6 "Age of sixth child" STAR_OT_7 "Age of seventh child" STAR_OT_8 "Age of eighth child" STAR_OT_9 "Age of ninth child" STAR_OT_10 "Age of tenth child" STAR_OT_11 "Age of eleventh child" STAR_OT_12 "Age of twelfth child" STAR_OT_13 "Age of thirteenth child" STAR_MIN "Age of youngest child" STAR_MAX "Age of oldest child" ST_OT_DRUZ_0_5 "Number of children aged 0-5 years in the family" ST_OT_DRUZ_0_14 "Number of children aged 0-14 years in the family" ST_OT_DRUZ_0_17 "Number of children aged 0-17 years in the family" ST_OT_DRUZ_0_24 "Number of children aged 0-24 years in the family" TIP_DRUZ_OT_0_5 "Type of family by children aged 0-5 years" TIP_DRUZ_OT_0_14 "Type of family by children aged 0-14 years" TIP_DRUZ_OT_0_17 "Type of family by children aged 0-17 years" TIP_DRUZ_OT_0_24 "Type of family by children aged 0-24 years" ZS_M "Marital status of mother" ZS_O "Marital status of father" DRZ_M "Citizenship of mother" DRZ_O "Citizenship of father" PREB_M "Type of resident - mother" PREB_O "Type of resident - father" DRZ_HOM_ZP "Citizenship of spouse / partners" AKT_M "Current activity status of father" AKT_O "Current activity status of mother" AKT_ZP "Current activity status of spouse / partners" IZB_M "Educational attainment of mother" IZB_O "Educational attainment of father" IZB_ZP "Educational attainment of spouse / partners" PRIS_M "Immigrant background of mother" PRIS_O "Immigrant background of father" PRIS_ZP_2 "Immigrant background of spouse / partners" ROJ_IND "Birth indicator" ROJ_ST "Number of live-born children" MATI "Status of biological mother" OCE "Status of biological father" STARSI "Status of spouse" HS_MID_NAST "Type of accommodation" ID_KOHEZIJSKA "Usual residence - cohesion region - LOOK UP RPE_POPIS_2011 CODEBOOK" ID_STATISTICNA "Usual residence - statistical region - LOOK UP RPE_POPIS_2011 CODEBOOK" ID_OBCINA "Usual residence - municipality - LOOK UP RPE_POPIS_2011 CODEBOOK" NA_ID "Usual residence - settlement - LOOK UP RPE_POPIS_2011 CODEBOOK" TIP_NASELJA "Type of settlement / area" VEL_NAS "Size of locality". * And then we add value labels to the non-numeric variable values. VALUE LABELS AKT_M AKT_O 1 'Employed' 2 'Self employed' 3 'Farmer / contributing family worker' 4 'Unemployed, never worked before' 5 'Unemployed, previously in employment' 6 'Person aged 0-14 years' 7 'Pupil' 8 'Student' 9 'Pension recipient' 10 'Social transfers recipient' 11 'Other inactive person' /AKT_ZP 1 'Husband/male partner and wife/female partner are employed' 2 'Husband/male partner is employed, wife/female partner is unemployed or vice versa' 3 'Husband/male partner is employed, wife/female partner is inactive or vice versa' 4 'Husband/male partner and wife/female partner are unemployed' 5 'Husband/male partner is unemployed, wife/female partner is inactive or vice versa' 6 'Husband/male partner and wife/female partner are inactive' /DRZ_HOM_ZP 1 'Husband/male partner and wife/female partner are citizens of the RS' 2 'Husband/male partner is a citizen of the RS, wife/female partner is a foreign citizen' 3 'Husband/male partner is a foreign citizen, wife/female partner is a citizen of the RS' 4 'Husband/male partner and wife/female partner are foreign citizens' /DRZ_M DRZ_O 004'Afghanistan' 008'Albania' 009'Kosovo' 012'Algeria' 016'American Samoa' 020'Andorra' 024'Angola' 031'Azerbaijan' 032'Argentina' 036'Australia' 040'Austria' 044'Bahamas' 050'Bangladesh' 051'Armenia' 052'Barbados' 056'Belgium' 068'Bolivia, Plurinational State of' 070'Bosnia and Herzegovina' 072'Botswana' 076'Brazil' 084'Belize' 086'British Indian Ocean Territory' 090'Solomon Islands' 096'Brunei Darussalam' 100'Bulgaria' 104'Myanmar' 108'Burundi' 112'Belarus' 116'Cambodia' 120'Cameroon' 124'Canada' 132'Cape Verde' 136'Cayman Islands' 140'Central African Republic' 144'Sri Lanka' 148'Chad' 152'Chile' 156'China' 158'Taiwan, province of China' 170'Colombia' 174'Comoros' 178'Congo' 180'Congo, the Democratic Republic of the' 188'Costa Rica' 191'Croatia' 192'Cuba' 196'Cyprus' 200'Czechoslovakia' 203'Czech Republic' 204'Benin' 208'Denmark' 212'Dominica' 214'Dominican Republic' 218'Ecuador' 222'El Salvador' 231'Ethiopia' 232'Eritrea' 233'Estonia' 242'Fiji' 246'Finland' 250'France' 254'French Guiana' 258'French Polynesia' 262'Djibouti' 266'Gabon' 268'Georgia' 270'Gambia' 275'Palestinian Territory, occupied' 276'Germany' 288'Ghana' 300'Greece' 320'Guatemala' 324'Guinea' 328'Guyana' 332'Haiti' 336'Holy See (Vatican City State)' 340'Honduras' 344'Hong Kong' 348'Hungary' 352'Iceland' 356'India' 360'Indonesia' 364'Iran, Islamic Republic of' 368'Iraq' 372'Ireland' 376'Israel' 380'Italy' 384'Cote D´Ivoire' 388'Jamaica' 392'Japan' 398'Kazakhstan' 400'Jordan' 404'Kenya' 408'Korea, Democratic People´s Republic of' 410'Korea, Republic of' 414'Kuwait' 417'Kyrgyzstan' 418'Lao People´s Democratic Republic' 422'Lebanon' 428'Latvia' 430'Liberia' 434'Libya' 438'Liechtenstein' 440'Lithuania' 442'Luxembourg' 450'Madagascar' 454'Malawi' 458'Malaysia' 466'Mali' 470'Malta' 480'Mauritius' 484'Mexico' 492'Monaco' 496'Mongolia' 498'Moldova, Republic of' 499'Montenegro' 500'Montserrat' 504'Morocco' 508'Mozambique' 512'Oman' 516'Namibia' 524'Nepal' 528'Netherlands' 530'Netherlands Antilles' 533'Aruba' 554'New Zealand' 558'Nicaragua' 566'Nigeria' 578'Norway' 586'Pakistan' 591'Panama' 598'Papua New Guinea' 600'Paraguay' 604'Peru' 608'Philippines' 616'Poland' 620'Portugal' 624'Guinea-Bissau' 626'Timor-Leste' 630'Puerto Rico' 634'Qatar' 642'Romania' 643'Russian federation' 646'Rwanda' 659'Saint Kitts and Nevis' 662'Saint Lucia' 682'Saudi Arabia' 686'Senegal' 688'Serbia' 694'Sierra Leone' 702'Singapore' 703'Slovakia' 704'Viet Nam' 705'Slovenia' 706'Somalia' 710'South Africa' 716'Zimbabwe' 724'Spain' 729'Sudan' 732'Western Sahara' 736'Sudan' 740'Suriname' 752'Sweden' 756'Switzerland' 760'Syrian Arab republic' 762 'Tajikistan' 764 'Thailand' 768 'Togo' 780 'Trinidad and Tobago' 784 'United Arab Emirates' 788 'Tunisia' 792 'Turkey' 795 'Turkmenistan' 800 'Uganda' 804 'Ukraine' 807 'Macedonia, the Former Yugoslav Republic of' 810 'USSR' 818 'Egypt' 826 'United Kingdom' 834 'Tanzania, United Republic of' 840 'United States' 854 'Burkina Faso' 858 'Uruguay' 860 'Uzbekistan' 862 'Venezuela, Bolivarian Republic of' 876 'Wallis and Futuna' 887 'Yemen' 890 'Yugoslavia' 891 'Serbia and Montenegro' 894 'Zambia' 901 'Kosovo' 995 'Palestinian Territory, Occupied' 998 'Abroad' 999 'Unknown country' /HS_MID_NAST 01 'Social work center without conventional dwellings' 02 'Residence for pupils and students' 03 'Postgraduate´s house' 04 'Special social care institute' 05 'Community' 06 'Prison' 07 'Religious institution' 08 'Elderly home' 09 'Elderly home with private households' 10 'Residence for students and religious institution' 11 'Elderly home, religious institution and private households' 12 'Elderly home and private households' 13 'Residence for students, religious institution and private households' 14 'Worker dormitory in non-residential building' 15 'Worker dormitory with short-term settlement' 16 'Worker dormitory for communities' 17 'Worker dormitory in one-dwelling building' 18 'Worker dormitory in multi-dwelling building' 19 'Residence for students, worker dormitory and conventional dwellings' 20 'Religious institution, residence for students and private households' 21 'Special social care institute with private households' 22 'Roma settlement' 23 'Social work center with conventional dwellings' 24 'Special accommodation center' 25 'Residence for students in building with conventional dwellings' 26 'Residence for pupils and students without institutional household' 27 'Religious institution without institutional household' 28 'Special social care institute without institutional household' 29 'Hotel and other tourist accommodation' 30 'Collective living quarter as a part of the building' 31 'Collective living quarter with 7 or less residents' /IZB_M IZB_O 0 'No education' 11001 'First stage of basic education/Incomplete first stage of basic education' 11002 'First stage of basic education/Complete first stage of basic education' 11003 'Fulfilled basic education requirement/Incomplete second stage of basic education' 12001 'Second stage of basic education/Basic education' 13001 'Short-term vocational upper secondary education/Short-term vocational upper secondary education' 14001 'Vocational upper secondary education/Vocational upper secondary education' 15001 'Technical upper secondary education/Technical upper secondary education' 15002 'General upper secondary education/General upper secondary education' 16101 'Higher vocational education/Higher vocational education' 16102 'Short-term higher education (former)/Short-term higher education (former)' 16201 'Specialization after short-term higher education (former)/Specialization after short-term higher education (former)' 16202 'Professional higher education (former)/Professional higher education (former)' 16203 'Professional higher education (first Bologna cycle)/Professional higher education (first Bologna cycle)' 16204 'Academic higher education (first Bologna cycle)/Academic higher education (first Bologna cycle)' 17001 'Specialization after professional higher education (former)/Specialization after professional higher education (former)' 17002 'Academic higher education (former)/Academic higher education (former)' 17003 'Master´s education (second Bologna cycle)/Master (second Bologna cycle)' 18101 'Specialization after academic higher education (former)/Specialization after academic higher education (former)' 18102 'Education leading to "magisterij" of science (former)/"Magisterij" of science (former)' 18201 'Education leading to doctorate of science (former)/Doctorate of science (former)' 18202 'Education leading to doctorate of science (third Bologna cycle)/Doctorate of science (third Bologna cycle)' /IZB_ZP 1 'Husband/male partner and wife/female partner have basic education or less' 2 'Husband/male partner has basic education or less, wife/female partner has upper secondary education or vice versa' 3 'Husband/male partner has basic education or less, wife/female partner has tertiary education or vice versa' 4 'Husband/male partner and wife/female partner have upper secondary education' 5 'Husband/male partner has tertiary education, wife/female partner has upper secondary education or vice versa' 6 'Husband/male partner and wife/female partner have tertiary education' /MATI 1 'Mother lives in the same family' 2 'Mother lives in the same household' 3 'Mother lives in an other household in Slovenia' 4 'Mother is not the resident of Slovenia' 5 'No data' /OCE 1 'Father lives in the same family' 2 'Father lives in the same household' 3 'Father lives in an other household in Slovenia' 4 'Father is not the resident of Slovenia' 5 'No data' /PREB_M PREB_O 1 'Citizen of the RS with permanent residence' 2 'Citizen of the RS with temporary residence' 3 'Foreigner with permanent residence' 4 'Foreigner with temporary residence' 5 'Citizen of the RS with usual residence abroad' 6 'Person with registered residence in Slovenia not included in population' /PRIS_M PRIS_O 1 'First generation' 2 'Second generation, both of parents first generation immigrants' 3 'Second generation, only father first generation immigrant' 4 'Second generation, only mother first generation immigrant' 5 'Third generation, both of parents second generation immigrants' 6 'Third generation, only father second generation immigrant' 7 'Third generation, only mother second generation immigrant' 8 'No immigrant background, father and mother not immigrants' 9 'No immigrant background, father is not immigrant, no data on immigrant background of mother' 10 'No immigrant background, mother is not immigrant, no data on immigrant background of father' 11 'No data on immigrant background of parents' /PRIS_ZP_2 1 'Husband/male partner and wife/female partner are first generation immigrants' 2 'Husband/male partner is a first generation immigrant, wife/female partner is a second generation immigrant or vice versa' 3 'Husband/male partner is a first generation immigrant, wife/female partner is a third generation immigrant or vice versa' 4 'Husband/male partner and wife/female partner are second generation immigrants' 5 'Husband/male partner is a second generation immigrant, wife/female partner is a third generation immigrant or vice versa' 6 'Husband/male partner and wife/female partner are third generation immigrants' 7 'Husband/male partner is a first generation immigrant, wife/female partner has no immigrant background or vice versa' 8 'Husband/male partner is a second generation immigrant, wife/female partner has no immigrant background or vice versa' 9 'Husband/male partner is a third generation immigrant, wife/female partner has no immigrant background or vice versa' 10 'Husband/male partner and wife/female partner have no immigrant background' 11 'No data on immigrant background' /ROJ_IND 1 'Have not given birth' 2 'Have given birth' /STARSI 1 'Parents live in the same family' 2 'Parents live in the same household' 3 'One parent lives in the same family, the other one in the same household' 4 'Mother lives in the same family or in the same household, father lives in an other household in Slovenia' 5 'Father lives in the same family or in the same household, mother lives in an other household in Slovenia' 6 'Parents live in an other household in Slovenia' 7 'Mother lives in the same family or in the same household, father is not the resident of Slovenia' 8 'Father lives in the same family or in the same household, mother is not the resident of Slovenia' 9 'One parent lives in an other household in Slovenia, the other one is not the resident of Slovenia' 10 'Parents are not the residents of Slovenia' 11 'Mother lives in an other household in Slovenia, no data on father' 12 'Father lives in an other household in Slovenia, no data on mother' 13 'One parent is not the resident of Slovenia, no data on the other one' 14 'No data' /TIP_DRUZ_OT_0_5 TIP_DRUZ_OT_0_14 TIP_DRUZ_OT_0_17 TIP_DRUZ_OT_0_24 1 'All children in family younger than x years' 2 'At least one child in family younger than x years' 3 'All children in family aged x years or more' /TIP_DRUZ 1 'Married couple, no children' 2 'Married couple with children' 3 'Mother with children' 4 'Father with children' 5 'Unmarried couple, no children' 6 'Unmarried couple with children' 7 'Grandparents with grandchildren' 8 'Grandparent with grandchildren' 9 'Siblings' 10 'Non-family member' 11 'Institutional household member' 12 'Other household member' /TIP_GO 1 'One-person' 2 'Multi-person non-family of relatives and non-relatives' 3 'Multi-person non-family of grandparents, grandchildren or siblings' 4 'Multi-person one-family' 5 'Multi-person one-family extended' 6 'Multi-person two or more-family' 7 'Multi-person two or more-family extended' 8 'Institutional household' 9 'Other household' /TIP_NASELJA "DN" Non-urban settlement "M" Urban settlement "NMO" Settlement within urban area /TIP_VZP_DRUZ 1 'No common children, biological mother lives in a family, biological mother lives in an other household/family' 2 'No common children, biological father lives in a family, biological father lives in an other household/family' 3 'At least one common child, biological father of non-common children lives in an other household/family' 4 'At least one common child, biological mother of non-common children lives in an other household/family' 5 'Biological father and/or mother of at least one child live in an other household/family' 6 'Reconstituted family - one of the biological parents is not a resident of Slovenia' 7 'Not reconstituted family' 8 'No data on reconstituted family available' /VEL_NAS 1 '1,000,000 inhabitants or more' 2 'From 500,000 to 999,999 inhabitants' 3 'From 200,000 to 499,999 inhabitants' 4 'From 100,000 to 199,999 inhabitants' 5 'From 50,000 to 99,999 inhabitants' 6 'From 20,000 to 49,999 inhabitants' 7 'From 10,000 to 19,999 inhabitants' 8 'From 5,000 to 9,999 inhabitants' 9 'From 2,000 to 4,999 inhabitants' 10 'From 1,000 to 1,999 inhabitants' 11 'From 500 to 999 inhabitants' 12 'From 200 to 499 inhabitants' 13 'From 100 to 199 inhabitants' 14 'From 50 to 99 inhabitants' 15 'From 25 to 49 inhabitants' 16 'From 1 to 24 inhabitants' /VZP_DRUZ_IND 1 'Reconstituted family - one of the biological parents lives in an other household/family' 2 'Reconstituted family - one of the biological parents is not a resident of Slovenia' 3 'Not reconstituted family' 4 'No data on reconstituted family available' /ZS_M ZS_O 1 'Single' 2 'Married' 3 'Widow/er' 4 'Divorced' 5 'Same gender partnership' 6 'Terminated IPS -death' 7 'Terminated IPS - other' 9 'Unknown'. *----------------------------------------------End data processing------------------------------------------------. * At the end we save the final database SAVE OUTFILE='savfile' /COMPRESSED.