*-------------------------------------------------------------------------------------------------------------------. * REGISTER CENSUS 2011 * Dataset DWELLING * * This STATA 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 * STATA 9.2 * * Social Science Data Archives, University of Ljubljana * Sebastian Kocar * http://www.adp.fdv.uni-lj.si/ * Contact:arhiv.podatkov@fdv.uni-lj.si * * This STATA code is protected under the Creative Commons licence. *-------------------------------------------------------------------------------------------------------------------. *--- CONFIGURATION SECTION --- START --- * The following commands should contain the complete path and * name of the .txt file to be read (e.g. 'C:/Census2011_v1.txt') * and the .dta file to be saved (e.g. 'C:/Census2011_v1.dta') * Change TXT_DATA_PATH to your filename. * Change DTA_DATA_PATH to your filename. *--- CONFIGURATION SECTION --- END --- *-------------------------------------------------------------------------------------------------------------------. *----------------------------------------------Start data processing------------------------------------------------. *--- importing data insheet using "TXT_DATA_PATH", tab *--- adding labels for variables label variable dst_sid "Building part ID (RER)" label variable id_lega "Position of dwelling in multi-dwelling building" label variable id_duplex "Duplex" label variable id_kuhinja "Kitchen in the dwelling" label variable id_kopalnica "Bathroom in the dwelling" label variable id_stranisce "Toilet in the dwelling" label variable st_sob "Number of rooms excluding kitchen" label variable upor_pov_stan "Useful floor space" label variable neto_tloris_pov_dst "Net ground plan of building part" label variable id_pocit_raba "Seasonal or secondary use" label variable id_prijava_dejav "Business use of building part" label variable st_sob_dejavnost "Number of rooms for business use" label variable povr_sob_dejavnost "Useful floor space for business use" label variable id_vr_najema "Type of rent" label variable dejanska_raba_ccsi "Actual use of part of the building - LOOK UP CC_SI_REN CODEBOOK" label variable stat_samo_za_dejavnost "Business use of dwelling only" label variable skupin_enota "Collective living quarter indicator" label variable obc "Location of dwelling - municipality - LOOK UP RPE_POPIS_2011 CODEBOOK" label variable nas "Location of dwelling - settlement - LOOK UP RPE_POPIS_2011 CODEBOOK" label variable reg "Location of dwelling - statistical region - LOOK UP RPE_POPIS_2011 CODEBOOK" label variable tip_naselja "Type of settlement / area (dwelling)" label variable st_preb_popis "Number of population in the dwelling" label variable st_gosp_popis "Number of households in the dwelling" label variable hs_mid_nast "Type of accommodation" label variable tip_stan_enote "Type of living quarters" label variable nasel_obic_stan "Occupancy of conventional dwelling" label variable tip_lastnistva "Dwelling ownership" label variable upor_povr_oseba "Useful floor space per person" label variable st_stanovalcev_raz "Number of occupants - range" label variable upor_povr_raz "Useful floor space - range" label variable gostota_raz "Density standard" label variable leto_zgr_eu "Period of construction" label variable st_sob_raz_eu "Number of rooms including kitchen" label variable st_sob_raz_slo "Number of rooms excluding kitchen - range" label variable st_sob_brezdej_eu "Number of rooms including kitchen and excluding rooms for business use" label variable st_sob_brezdej_eu_oseba "Number of rooms per person including kitchen and excluding rooms for business use" label variable gostota_raz_sob_eu "Density standard including kitchen and excluding rooms for business use - range" label variable voda_vstan "Piped water in the dwelling" label variable last1 "Ownership by type of owner" label variable last2 "Ownership by type of sector" label variable st_gosp_last "Number of households of which a member is the owner of the dwelling" label variable upor_pov_stan_brezdej "Useful floor space without space for business use" label variable upor_pov_stan_brezdej_raz "Useful floor space without space for business use - range" label variable st_sob_brezdej_slo "Number of rooms without rooms for business use" label variable st_sob_brezdej_slo_raz "Number of rooms without rooms for business use - range" label variable vel_naselja "Size of locality of dwelling" label variable leto_izg_sta "Year of construction" label variable id_konstrukcije "Main structural material" label variable id_dvigalo "Lift" label variable id_ogrevanje "Type of heating" label variable id_vodovod "Water supply system in the dwelling" label variable id_elektrika "Electricity in the dwelling" label variable id_telefon "Telephone in the dwelling" label variable id_kanalizacija "Sewage disposal system in the dwelling" label variable id_plin "Piped gas in the dwelling" label variable id_tip_stavbe "Type of building" label variable dejanska_raba_stavbe "Actual use of the building - LOOK UP CC_SI_REN CODEBOOK" label variable id_kabelska_tv "Cable TV" label variable raba_stav "Use of building" label variable vrsta_stav_eu "Type of building" label variable centr_ogr "Central heating" *--- adding labels for variable values label define id_lega 1"Cellar" 2"Groud floor" 3"Floor" 4"Attic" 5"Other" label define id_duplex 1"Yes" 2"No" label define id_kuhinja 1"Kitchen" 2"No kitchen" label define id_kopalnica 1"Fixed bath or shower in the housing unit" 2"No fixed bath or shower in the housing unit" 3"Not stated" label define id_stranisce 1"Flush toilet in the housing unit" 2"No flush toilet in the housing unit" 3"Not stated" label define id_pocit_raba 1"Seasonal or secondary use of dwelling" 2"No seasonal or secondary use of dwelling" 3"Vacant dwelling" label define id_prijava_dejav 1"Yes" 2"No" label define id_vr_najema 1"Not rented dwelling" 2"Non-profit rented dwelling" 3"Market rented dwelling" 4"Company rented dwelling" 5"Dedicated rented dwelling (for older people, pensioners or s" label define stat_samo_za_dejavnost 0"No" 1"Yes" label define skupin_enota 0"Not a collective living quarter" 1"Collective living quarter" label define hs_mid_nast 1"Social work center without conventional dwellings" 2"Residence for pupils and students" 3"Postgraduate´s house" 4"Special social care institute" 5"Community" 6"Prison" 7"Religious institution" 8"Elderly home" 9"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 ho" 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 dw" 20"Religious institution, residence for students and private ho" 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 dwellin" 26"Residence for pupils and students without institutional hous" 27"Religious institution without institutional household" 28"Special social care institute without institutional househol" 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" label define tip_stan_enote 1"Conventional dwelling" 2"Collective living quarter" 3"Other housing unit" 4"Different intitutions dealling also with homless people like" 5"Unknown" 6"Other parts of buildings" label define nasel_obic_stan 0"Not a conventional dwelling" 1"Occupied convential dwelling" 2"Dwelling for seasonal or secondary use" 3"Vacant dewlling" label define tip_lastnistva 1"Owner-occupied dwellings" 2"Dwellings in cooperative ownership" 3"Rented dwellings" 4"Dwellings in other types of ownership" 5"Not stated" 6"Not applicable" label define st_stanovalcev_raz 1"1 person" 2"2 persons" 3"3 persons" 4"4 persons" 5"5 persons" 6"6 persons" 7"7 persons" 8"8 persons" 9"9 persons" 10"10 persons" 11"11 or more persons" label define upor_povr_raz 1"Under 30 square metres" 2"30 - less than 40 square metres" 3"40 - less than 50 square metres" 4"50 - less than 60 square metres" 5"60 - less than 80 square metres" 6"80 - less than 100 square metres" 7"100 - less than 120 square metres" 8"120 - less than 150 square metres" 9"150 square metres and over" 10"Not stated" label define gostota_raz 1"less than 10 m2" 2"10 - less than 15 m2" 3"15 - less than 20 m2" 4"20 - less than 30 m2" 5"30 - less than 40 m2" 6"40 - less than 60 m2" 7"60 - less than 80 m2" 8"80 m2 and more" 9"Not stated" label define leto_zgr_eu 1"Before 1919" 2"1919 - 1945" 3"1946 - 1960" 4"1961 - 1970" 5"1971 - 1980" 6"1981 - 1990" 7"1991 - 2000" 8"2001 - 2005" 9"2006 and later" 10"Not stated" label define st_sob_raz_eu 1"1 room" 2"2 rooms" 3"3 rooms" 4"4 rooms" 5"5 rooms" 6"6 rooms" 7"7 rooms" 8"8 rooms" 9"9 rooms and more" 10"Not stated" label define st_sob_raz_slo 1"1 room" 2"2 rooms" 3"3 rooms" 4"4 rooms" 5"5 rooms" 6"6 rooms" 7"7 rooms" 8"8 rooms" 9"9 rooms and more" 10"Not stated" label define gostota_raz_sob_eu 1"Less than 0.5 rooms per occupant" 2"0.5 - less than 1.0 rooms per occupant" 3"1.0 - less than 1.25 rooms per occupant" 4"1.25 - less than 1.5 rooms per occupant" 5"1.5 - less than 2.0 rooms per occupant" 6"2.0 - less than 2.5 rooms per occupant" 7"2.5 - less than 3.0 rooms per occupant" 8"3.0 and more rooms per occupant" 9"Not stated" label define voda_vstan 1"Piped water in the housing unit" 2"No piped water in the housing unit" 3"Not stated" label define last1 1"Owned by physical persons" 2"Owned by public sector" 3"Other" 4"Unknown" label define last2 1"Owned by private sector" 2"Owned by public sector" 3"Other" 4"Unknown" label define upor_pov_stan_brezdej_raz 1"Under 30 square metres" 2"30 - less than 40 square metres" 3"40 - less than 50 square metres" 4"50 - less than 60 square metres" 5"60 - less than 80 square metres" 6"80 - less than 100 square metres" 7"100 - less than 120 square metres" 8"120 - less than 150 square metres" 9"150 square metres and over" 10"Not stated" label define st_sob_brezdej_slo_raz 1"1 room" 2"2 rooms" 3"3 rooms" 4"4 rooms" 5"5 rooms" 6"6 rooms" 7"7 rooms" 8"8 rooms" 9"9 rooms and more" 10"Not stated" label define vel_naselja 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" 17"No inhabitants" label define id_konstrukcije 1"bricks" 2"concrete, ironed concrete" 3"rock" 4"wood" 5"combination of different materials" 6"metal construction" 7"montage building" 8"other material" label define id_dvigalo 1"Lift" 2"No lift" label define id_ogrevanje 1"Heating by community heating centre" 2"Central heating" 3"Other type of heating" 4"No heating" label define id_vodovod 1"Yes" 2"No" label define id_elektrika 1"Electricity grid" 2"No electricity grid" label define id_telefon 1"Availabitiy of telephone connection" 2"No availabitiy of telephone connection" label define id_kanalizacija 1"Sewage disposal system" 2"No sewage disposal system" label define id_plin 1"Piped gas available" 2"No piped gas available" label define id_tip_stavbe 1"Detached house" 2"Semidetached house" 3"End-row house" 4"Middle row house" label define id_kabelska_tv 1"Yes" 2"No" label define raba_stav 1"Residential building" 2"Non-residential building" label define vrsta_stav_eu 1"One dwelling building" 2"Two dwelling building" 3"Two or more dwelling building" 4"Non dwelling building" 5"Not specified" label define centr_ogr 1"Central heating" 2"No central heating" 3"Not stated" *----------------------------------------------End data processing------------------------------------------------. *--- displaying all labels label list *--- saving dta dataset with labels save "DTA_DATA_PATH"