THE CLEANED AND HARMONIZED VERSION OF THE SURVEY DATA PRODUCED AND PUBLISHED BY THE ECONOMIC RESEARCH FORUM REPRESENTS 50% OF THE ORIGINAL SURVEY DATA COLLECTED BY THE CENTRAL AGENCY FOR PUBLIC MOBILIZATION AND STATISTICS (CAPMAS) <\/p> \n\nThe Central Agency for Public Mobilization And Statistics (CAPMAS) is responsible for Implementation of statistics and data collection of various kinds, specializations, levels and performs many of the general censuses and economic surveys. \nOne of the key aims of CAPMAS is to complete unified and comprehensive statistical work to keep up with all developments in various aspects of life and unifying standards, concepts and definitions of statistical terms, development of comprehensive information system as a tool for planning and development in all fields\n\nThe Household Income, Expenditure and Consumption Survey (HIECS) is one important source to rely on for economic, social and demographic indicators, that are conducted every few years.\n \nThe HIECS 1999\/2000 is the seventh Household Income, Expenditure and Consumption Survey that was carried out in 1999\/2000, among a long series of similar surveys that started back in 1955.\n\nThe survey main objectives are:\n- To estimate the quantities, values of commodities and services consumed by households during the survey period to estimate the current demand and determine the levels of consumption for commodities and services essential for national planning.\n- To measure mean household and per-capita expenditure on different goods and services in urban and rural areas.\n- To define mean household and per-capita income.\n- To define percentage distribution of expenditure for various expenditure items used in compiling consumer price indices for different expenditure levels on urban and rural levels.\n- To provide essential data to measure elasticity which reflects the percentage change in expenditure for various commodity and service groups against the percentage change in total expenditure for the purpose of predicting the levels of expenditure and consumption for different commodity and service items in urban and rural areas and different levels of total expenditure.\n- To provide data essential for comparing change in expenditure against change in income to measure income elasticity of expenditure.\n- To study the relationships between demographic, geographical, housing characteristics of households and their income and expenditure for commodities and services, in urban and rural areas.\n- To provide data necessary for national accounts especially in compiling inputs and outputs tables, and commodity balances.\n- To provide updated data on Income, Expenditure and Consumption estimates in 1999\/2000 to serve planners, investors and researchers.\n- To identify expenditure levels and patterns of population and consumers behavior in urban and rural areas.\n- To identify per capita food consumption and its main components of calories, proteins and fats according to its sources and the levels of expenditure in both urban and rural areas.\n- To identify the value of expenditure for food according to sources, either from household production or not, in addition to household expenditure for non food commodities and services.\n- To identify distribution of households according to the possession of some appliances and equipments such as (cars, satellites, mobiles ...) in urban and rural areas.\n- To identify the distribution of households according to the number of members, compared to the number of rooms occupied by the household.\n- To provide the distribution of households by income categories, income sources and number of income earners.\n- To provide the distribution of number of waged workers in the household by their income range, economic activity, sector and main occupation.\n\nA committee consisting of Experts of the Central Agency for Public Mobilization and Statistics, Experts of the Ministry of Planning, Experts from NIB and Egyptian university professors, has been formed based on the decree number (28) for the year 1998 of the Minister of State for Planning and International Cooperation, to study and prepare Expenditure and Consumption Estimates Survey in the Arab Republic of Egypt and follow up on the implementation of the research procedures. \n\nA timetable has been prepared for the implementation of every stage of this survey, which started in 01\/04\/1999. It was taken into account in this timetable the coordination between the work phases, so that these stages were conducted in parallel, where the coding and office audit would start immediately upon completion of the monthly data collection phase. Data for which forms are completed, coded and reviewed was entered on personal computers during the same month.\n\nSpecialized working groups were formed for each stage of the survey work and trained according to intensive training programs for each phase. Those stages were supervised by experts of the Central Agency for Public Mobilization and Statistics in the field of family research.\n\nAll collected data has been prepared on personal computers within the statistics division where 22 of the latest generations of devices were used, on which was installed the most updated software for data entry and validation.\n\nThe survey management prepared a report for essential commodities to indentify the minimum and maximum price for those goods during each month of the survey. This report was sent to the statistical offices in all governorates to be filled from their sources by auditors, supervisors and delivered to the survey management with all forms collected to be used during the central office audit stage.\n\nThe raw survey data provided by the Statistical Agency were cleaned and harmonized by the Economic Research Forum, in the context of a major project that started in 2009. During which extensive efforts have been exerted to acquire, clean, harmonize, preserve and disseminate micro data of existing household surveys in several Arab countries.","coll_dates":[{"start":"1999-10-01","end":"2000-09-30","cycle":"-"}],"nation":[{"name":"Egypt","abbreviation":"EGY"}],"geog_coverage":"Covering a sample of urban and rural areas in all the governorates.","analysis_unit":"1- Household\/family.\n2- Individual\/person.","universe":"The survey covered a national sample of households and all individuals permanently residing in surveyed households.","data_kind":"Sample survey data [ssd]","notes":"Household: Includes geographic, social, and economic characteristics of households, namely, household composition, dwelling characteristics, ownership of assets indicators, heads' and spouses' characteristics, annual household expenditure and income.\n\nIndividual: Includes demographic, migration, education, labor and health characteristics, as well as annual income for household members identified as earners. Moreover, fathers' and mothers' characteristics are generated for household members if possible."},"method":{"data_collection":{"data_collectors":[{"name":"Central Agency For Public Mobilization & Statistics","abbreviation":"CAPMAS","affiliation":"Egypt"}],"sampling_procedure":"
THE CLEANED AND HARMONIZED VERSION OF THE SURVEY DATA PRODUCED AND PUBLISHED BY THE ECONOMIC RESEARCH FORUM REPRESENTS 50% OF THE ORIGINAL SURVEY DATA COLLECTED BY THE CENTRAL AGENCY FOR PUBLIC MOBILIZATION AND STATISTICS (CAPMAS) <\/p> \n\nA large sample representative for urban and rural areas in all governorates has been designed by CAPMAS in March 1999 for the HIECS 1999\/2000.\n\nIn previous surveys, CAPMAS used to select a sample of around 15000 households from 500 Primary Sampling Units (PSUs). For HIECS 1999\/2000, a sample of about 48000 households has been considered from 600 PSUs, 28800 households in urban (360 PSUs) and 19200 households in rural (240 PSUs), distributed over 12 months (4000 households monthly).\n\nThe master sample is a strata-area-unbiased-probability proportion to size sample. The 1996 census data, the population estimates for the year 2000, as well as the number of shiakha\/village in each governorate were used for the distribution of PSUs on different strata during the first sampling stage.\nThe sampling unit in the first sampling stage was taken to be the PSU consisting of at least 1500 households in urban areas and 1000 households in rural areas.\nWhile the sampling unit for the second stage whether in urban or rural areas was the household.\n\nA more detailed description of the different sampling stages and allocation of sample across governorates is provided in the Methodology document available among the documentation materials published in both Arabic and English.","coll_mode":"Face-to-face [f2f]","research_instrument":"Three different questionnaires have been designed as following: \n1- Expenditure and consumption questionnaire 1999\/2000. \n2- Diary questionnaire for expenditure and consumption 1999\/2000. \n3- Income questionnaire. \n\nA brief description of each questionnaire is given next: \n\n1- Expenditure and Consumption Questionnaire\n--------------------------------------------------------------\nThis questionnaire comprises 14 tables in addition to identification and geographic data of household on the cover page. The questionnaire is divided into two main sections.\nSection one: Basic information which includes:\n- Demographic characteristics and basic data for all household individuals consisting of 15 questions for every person, in a table of 10 columns (1 column per person) on two pages so that each table contains data for 20 persons.\n- Household visitors during the month of the survey.\n- Members of household who are currently working abroad.\n- The household ration card.\n- The housing conditions including 18 questions.\n- The household possession of appliances including 23 type of appliance.\nThis section includes some questions which help to define the socio-economic level of households which in turn, help interviewers to check the plausibility of expenditure, consumption and income data.\n\nSection two: Expenditure and consumption data It includes 14 tables as follows:\n- The quantity and value of food and beverages commodities actually consumed.\n- The quantity and value of the actual consumption of tobacco and narcotics.\n- The quantity and value of the clothing and footwear.\n- The household expenditure for housing.\n- The household expenditure for furnishings, household equipment and services.\n- The household expenditure for health care services.\n- The household expenditure for transportation and communication.\n- The household expenditure for education.\n- The household expenditure for recreation and culture.\n- The household expenditure at restaurants and hotels.\n- The household expenditure for miscellaneous goods and services.\n- Transfer payments.\n- Installments and other amounts paid during the survey year.\n- Total annual household expenditure (prepared in office)\n\nThe tables from 1 to 13 include all types of commodities and services (578 Items), 37 Sub-group and 13 Main groups in addition to transfer payments.\nThis questionnaire has been designed to be pre coded for all expenditure items and household characteristics except occupation and industry. Whenever relevant, the questionnaire provides spaces for different reference periods such as two weeks, monthly, quarterly and annually.\n\n\n2 - Diary Questionnaire\n-----------------------------\nIt has been prepared to help households recording - on a daily basis- the quantity and value of what have been consumed of food and beverages during the survey month.\nThis form is thus the main source for expenditure and consumption data, therefore it was designed in a very simple form to be easily used whether by the household or the interviewers during their frequent visits to the household.\nAnd due to the importance of this form, it was decided that the household should record the expenditure data in this form, and the interviewers are instructed to check what households have recorded every three days during the 10 visits assigned to each household. In case of the inability of some households to record their daily expenditure, the interviewer has to do so. \n\nThe questionnaire includes:\na- Letter addressed to the head of household to inform him\/her about the importance of survey. \nb- Instructions of data recording for households and interviewers.\nc- Twenty pages (Form A) to record the daily consumed quantity and value of food and beverages during the month of the survey, in a page is divided into 4 columns and each column or a set of columns are assigned to one commodity, including date, source of commodity, quantity and value.\nd- Six pages (Form B), to record the value of expenses outside home, in a page or two for each of the household members who has spending outside home, such as: meals in restaurants or clubs, sandwiches, alcoholic and non-alcoholic beverages, expenditure on tobacco and accommodation expenses.\ne- One page (Form C) to record the household expenditure on education for each household member enrolled during the year ending by the end of the survey month, by the education level attended and the expenditure type.\n\n\n3- Income questionnaire\n-------------------------------\nThe questionnaire has been designed in a form that enables the interviewer to record the income data for each household member by source of income and the detailed items of each source. The total net income for each member and the annual net household income can then be computed.\n\nA new table has been added to this form to identify the household members who are active and income earners by type of person and work (primary\/secondary), in order to be able the estimate the person's wage through his primary or secondary job.\nThe table for annual net income from wages and salaries has been divided into main income and secondary income for each of the household members by income items of wages and salaries.\nGenerally, this form consists of 8 tables:\n1- Total annual net household income, prepared in the office, after recording income data by different sources for household members.\n2- Income earners who are active (inside labor force) by gender, type of work (primary\/secondary), work status, occupation, economic activity and sector of employment for both primary and secondary job.\n3- Net annual income from wages and salaries for waged workers among household members, consisting of 10 items.\n4- Net annual income from agriculture projects of household members, consisting of 16 items.\n5- Net annual income from non-agriculture projects of household members, consisting of 7 items.\n6- Net annual income from real properties of household members, consisting of 8 items.\n7- Net annual income from financial investments of household members, consisting of 9 items.\n8- Net annual income from regular revenues of household members, consisting of 6 items.","coll_situation":"The Preparation stage for the survey has started with the design of the master sample; for which the fieldwork implementation took place in 3 months (1\/3\/1999 to 31\/5\/1999).\nA pretest was conducted for all survey instruments (3 questionnaire forms and instructions manual) from 30\/6\/1999 to 7\/8\/1999, on a sample of 80 households (40 households in urban areas of Cairo and 40 households in rural areas of Giza and Menoufia).\nThe survey period of the HIECS 1999\/2000 extended for around 12 month-period, starting from October 1999 and ending in September 2000, to cover 48000 households (4000 households monthly). \nThe structure and the number of field workers that worked monthly in all governorates is 32 field supervisors, 200 field editors, 400 interviewers and 15 field experts.\nThe entire survey period was divided into four exclusive quarters and hence the entire sample was divided among the four quarters. The 80 households representing the sample of each PSU were then divided into 4 sub-samples of 20 households each, to be surveyed in one month during the quarter.","act_min":"The field staff was selected from among the efficient experienced persons working in CAPMAS and new graduates specially females.\nIntensive training program for supervisors was conducted at CAPMAS in Cairo and locally in governorates for interviewers and field editors.\nSupervision program was implemented monthly in all governorates to check the field work to overcome the field problems.\nData were collected using personal interview method for household in dwelling and it had been obtained from the head of household or wife or any eligible person in case of their absence.\nDuties and responsibilities of all levels of field staff (interviewer, editor and supervisor) were defined to insure the accuracy and timing. These are outlined next:\n\nA- Interviewers\n--------------------\n400 female interviewers from statistical offices, public services or government agencies workers were selected monthly in all governorates.\nEvery one of them was responsible for data collection of ten households during one month with ten visits as follows:\n\nThe first visit should be conducted with the editor, before the survey month by one or two days. Its purpose is to ensure the existence of the household, meet the head of household, present herself and her CAPMAS card to him. She also gives the household a simple idea about the survey (its objectives, importance and required data especially expenditure and consumption data).\nShowing households the methods of recording their daily data and knowing the suitable time for visiting them. Also delivering the diary book to the household.\nThe following visits should take place weekly with the rate of two visits each week during which the interviewer makes sure the family record all expenditure data and daily consumption in the diary questionnaire (this form is considered an essential component of the field work and the crucial source to fill the expenditure and consumption questionnaire in order to enhance data quality) in addition to the completion of data for some tables in the basic questionnaire according to a timetable prepared for this purpose.\nThe tenth visit takes place during the first day of the month following the end of the survey month and during which the interviewer completes missing data in the expenditure and consumption form, in addition to filling income data for income earners (previously identified in the tables of basic information of all household members in the first form) in the third form by source of income except for servants. Thus, it was possible to avoid any impact of income data on expenditure and consumption data given the sensitivity of income data for some of the household members.\n\nB- Editor\n------------\nThe Editors, selected from best workers in statistical offices, were responsible for checking the work of the interviewers working immediately under his guidance. Each editor is responsible to follow-up on two interviewers' work, in addition to revising data collected during the field work to ensure its accuracy and completion.\n\nC- Field Expert \n---------------------\nField experts were selected from highly experienced workers in the field of household surveys at CAPMAS. Schedules of monthly passes have been set up for them to follow-up on all stages of the survey work implemented in all governorates and address any problems that appear during fieldwork.\n\nD- Supervisor \n-----------------\nThe supervisor is the head of the statistical office in the governorate, thus there is a supervisor in each governorate, except in Cairo where there is 3 supervisors, an Alexandria and Giza where there is 2 supervisors.\nThe supervisor is the person responsible administratively and technically of all work stages of the survey in the governorate or part of the governorate.","cleaning_operations":"Raw Data\n=======\nOffice Editing:\nIt is one of the main stages of the survey. It started as soon as the questionnaires were received from the field and accomplished by selected work groups. It includes:\na- Editing of coverage and completeness\nb- Editing of consistency \nc- Arithmetic editing of quantities and values.\n\nData Coding:\nSpecialized staff has coded the data of industry, occupation and geographical identification.\n\nData Processing and preparing final results\nIt included machine data entry, data validation and tabulation and preparing final survey volumes. \n\n\nHarmonized Data\n============\n- The Statistical Package for Social Science (SPSS) is used to clean and harmonize the datasets.\n- The harmonization process starts with cleaning all raw data files received from the Statistical Agency.\n- Cleaned data files are then all merged to produce one data file on the individual level containing all variables subject to harmonization.\n- A country-specific program is generated for each dataset to generate\/compute \/recode\/rename\/format\/label harmonized variables.\n- A post-harmonization cleaning process is then conducted on the data.\n- Harmonized data is saved on the household as well as the individual level, in SPSS and converted to STATA format."},"analysis_info":{"sampling_error_estimates":"The estimate of sampling error at 95% confidence intervals was computed using the coefficient of variation for as well as the estimate of average total consumption expenditure from the previous survey.\nFor the 28800 households in urban, the estimate of sampling error was 0.7%, while for the 19200 households in rural, the estimate of sampling error was 0.9%. \n\nEquations used to calculate the sampling error are provided in the Methodology document available among the documentation materials published."}},"data_access":{"dataset_use":{"conf_dec":[{"txt":"To access the micro data, researchers are required to register on the ERF website and comply with the data access agreement. \n\nThe data will be used only for scholarly research, or educational purposes. Users are prohibited from using data acquired from the Economic Research Forum in the pursuit of any commercial or private ventures.","required":"yes","form_no":"","uri":""}],"contact":[{"name":"Economic Research Forum","affiliation":"(ERF)","email":"erfdataportal@erf.org.eg","uri":"www.erf.org.eg"}],"cit_req":"The users should cite the Economic Research Forum and the Central Agency For Public Mobilization & Statistics as follows:\n\nOAMDI, 2014. Harmonized Household Income and Expenditure Surveys (HHIES), http:\/\/www.erf.org.eg\/cms.php?id=erfdataportal. Version 2.0 of Licensed Data Files; HIECS 1999\/2000 - Central Agency for Public Mobilization and Statistics (CAPMAS). Egypt: Economic Research Forum (ERF).","conditions":"Licensed datasets, accessible under conditions.","disclaimer":"The Economic Research Forum and the Central Agency For Public Mobilization & Statistics have granted the researcher access to relevant data following exhaustive efforts to protect the confidentiality of individual data. The researcher is solely responsible for any analysis or conclusions drawn from available data."}}},"schematype":"survey"}