Login
Login
ENGLISH ARABIC
Microdata Catalog
  • Data Catalog
  • Citations
    Home / Central Data Catalog / EGY_HIECS_2017_HD_V2.0
central

Household Income, Expenditure, and Consumption Survey, HIECS 2017/2018

Egypt, Arab Rep., 2017 - 2018
Income and Expenditure Surveys
ERF Harmonized Datasets
Economic Research Forum, Central Agency For Public Mobilization & Statistics
Created on February 23, 2021 Last modified February 23, 2021 Page views 52094 Download 11797 Metadata DDI/XML JSON
  • Study description
  • Documentation
  • Data Description
  • Get Microdata
  • Identification
  • Version
  • Scope
  • Coverage
  • Producers and sponsors
  • Sampling
  • Data Collection
  • Questionnaires
  • Data Processing
  • Access policy
  • Disclaimer and copyrights
  • Metadata production

Identification

Survey ID Number
EGY_HIECS_2017_HD_V2.0
Title
Household Income, Expenditure, and Consumption Survey, HIECS 2017/2018
Country
Name Country code
Egypt EGY
Study type
Income/Expenditure/Household Survey [hh/ies]
Series Information
The first survey of income and expenditure, planned to be a pilot one, was undertaken in 1955. It was planned and carried out by the Committee of Statistic in three villages of Giza governorate on a sample of 750 households where the total sampling frame in this area was 4000 households.

In 1958/59, the first national survey was conducted in all governorates of Egypt on a sample of 6376 households distributed between urban and rural areas with a percentage of 51.5% and 48.5% respectively. All sample households were observed for the entire survey period (12 month).

In 1964/65, the second survey was conducted on a sample of 13818 households allocated between urban and rural areas such as 67.6% for urban and 32.4%for rural households. With the aim of reducing the burden on surveyed households, the whole sample was divided into four sub-samples where households of each sub-sample were observed for only three consecutive months.

In 1974/75, the third survey was carried out on a sample of 11995 households allocated between urban and rural areas in a similar way as the second survey. Like the second survey, households were observed only for three successive months.

In 1981/82, the fourth survey was conducted on a sample of 17000 households distributed equally between urban and rural areas. A new observation methodology, combing fixed and changeable observation of surveyed households, has been applied. A sub- sample of 1000 households were observed all over the survey period (12 months) while the remaining 16000 households were observed on a changeable basis.

In 1990/91, the name of household budgetary survey changed to income, expenditure and consumption survey. Under the new name, the fifth survey was conducted on a sample of 15000 households distributed between urban and rural areas with the percentage of 60% for urban and 40% for rural. The entire sample was divided into 12 sub-samples, each were observed for only one month.

In 1995/96, the sixth survey was conducted on a sample of 15090 households allocated between urban and rural areas such as 45.1% in urban and 54.9% in rural. The same observation scheme of the previous survey was applied, i.e., households were observed for one month only.

In 1999/2000, the seventh survey was conducted on a sample of 48000 households (4000 household monthly) distributed between urban and rural areas with the percentage of 60% for urban and 40% for rural.(households were observed for one month only).

In 2004/2005, the eighth survey was conducted on a sample of 48000 households (4000 households monthly) distributed in urban and rural areas with the percentage of 46.4% for urban and 53.6% rural (households were observed for one month only).

In 2008/2009 the ninth in the series was conducted on a sample of 48658 households (2000 households every 15 days) distributed between urban and rural areas with the percentage of 47.2% for urban and 52.8% rural.(households were observed every 15 days).

In 2010/2011, the tenth survey was conducted on a sample of 26.5 thousand households, out of which 16.5 thousands were new households and 10 thousands were panel households. 1100 household were collected every 15 days distributed between urban and rural areas with the percentage of 47.1% for urban and 52.9% rural (surveyed households were changed every 15 days).

In 2012/2013, the eleventh survey was conducted on a sample of 24863 households, out of which 16094 were new households and 8769 were panel households. 1036 household were collected every 15 days distributed between urban and rural areas with the percentage of 45.4% for urban and 54.6% rural (surveyed households were changed every 15 days).

In 2015, the twelfth survey that was carried out in 2015 on a sample of 25000 households, distributed between urban and rural areas with the percentage of 45% for urban and 55% rural. Data collection period was distributed into 24 waves. Each wave consisted of one week, and 1042 household were collected every wave during the first half of 2015. In the second half of 2015, households were re-visited to capture seasonal expenditures and consumptions.

The current survey is the Thirteenth survey that was carried out in 2017/ 2018 on a sample of 26000 households, distributed between urban and rural areas with the percentage of 45% for urban and 55% rural. Data collection period was distributed into 24 waves. Each wave consisted of one week, and 1075 household were collected every wave during the first half of the survey year. In the second half of the year, households were re-visited to capture seasonal expenditures and consumptions.
Abstract

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)



The Household Income, Expenditure and Consumption Survey (HIECS) is of great importance among other household surveys conducted by statistical agencies in various countries around the world. This survey provides a large amount of data to rely on in measuring the living standards of households and individuals, as well as establishing databases that serve in measuring poverty, designing social assistance programs, and providing necessary weights to compile consumer price indices, considered to be an important indicator to assess inflation.

The First Survey that covered all the country governorates was carried out in 1958/1959 followed by a long series of similar surveys. The current survey, HIECS 2017/2018, is the Thirteenth in this long series.
Starting 2008/2009, Household Income, Expenditure and Consumption Surveys were conducted each two years instead of five years. this would enable better tracking of the rapid changes in the level of the living standards of the Egyptian households.

CAPMAS started in 2010/2011 to follow a panel sample of around 40% of the total household sample size. The current survey is the fourth one to follow a panel sample. This procedure will provide the necessary data to extract accurate indicators on the status of the society.
The CAPMAS also is pleased to disseminate the results of this survey to policy makers, researchers and scholarly to help in policy making and conducting development related researches and studies

The survey main objectives are:

- To identify expenditure levels and patterns of population as well as socio- economic and demographic differentials.

- To measure average household and per-capita expenditure for various expenditure items along with socio-economic correlates.

- To Measure the change in living standards and expenditure patterns and behavior for the individuals and households in the panel sample, previously surveyed in 2008/2009, for the first time during 12 months representing the survey period.

- To define percentage distribution of expenditure for various items used in compiling consumer price indices which is considered important indicator for measuring inflation.

- To estimate the quantities, values of commodities and services consumed by households during the survey period to determine the levels of consumption and estimate the current demand which is important to predict future demands.

- To define average household and per-capita income from different sources.

- To provide data necessary to measure standard of living for households and individuals. Poverty analysis and setting up a basis for social welfare assistance are highly dependent on the results of this survey.

- 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.

- To provide data essential for comparing change in expenditure against change in income to measure income elasticity of expenditure.

- To study the relationships between demographic, geographical, housing characteristics of households and their income.

- To provide data necessary for national accounts especially in compiling inputs and outputs tables.

- To identify consumers behavior changes among socio-economic groups in urban and rural areas.

- To identify per capita food consumption and its main components of calories, proteins and fats according to its nutrition components and the levels of expenditure in both urban and rural areas.

- To identify the value of expenditure for food according to its sources, either from household production or not, in addition to household expenditure for non-food commodities and services.

- To identify distribution of households according to the possession of some appliances and equipments such as (cars, satellites, mobiles ,…etc) in urban and rural areas that enables measuring household wealth index.

- To identify the percentage distribution of income earners according to some background variables such as housing conditions, size of household and characteristics of head of household.

- To provide a time series of the most important data related to dominant standard of living from economic and social perspective. This will enable conducting comparisons based on the results of these time series. In addition to, the possibility of performing geographical comparisons.


The 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.
Kind of Data
Sample survey data [ssd]
Unit of Analysis
1- Household/family.
2- Individual/person.

Version

Version Description
V1.0: A cleaned and a harmonized version of the survey dataset, produced by the Economic Research Forum for dissemination.

V2.0: A cleaned and a harmonized version of the survey dataset, including all variables in V1.0 in addition to a number of new/detailed-composite coded version of the variables considered essential on the household as well as the individual level, produced by the Economic Research Forum for dissemination.
Production Date
2021-02
Version Notes
All documentation available for the original survey provided by the Statistical Agency, and for the harmonized datasets produced by the Economic Research Forum, has been published, along with a copy of all international classifications of expenditures, occupations and economic activities used during the harmonization process.
However, as far as the datasets are concerned, the Economic Research Forum produces and releases only the harmonized versions in both SPSS and STATA formats.

Scope

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.

Individual: 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.
Topics
Topic Vocabulary
Poverty ERF
Expenditure ERF
Income ERF
Infrastructure ERF
Education ERF
Labor ERF
Health ERF

Coverage

Geographic Coverage
Covering a sample of urban and rural areas in all the governorates.
Universe
The survey covered a national sample of households and all individuals permanently residing in surveyed households.

Producers and sponsors

Primary investigators
Name Affiliation
Economic Research Forum ERF
Central Agency For Public Mobilization & Statistics CAPMAS

Sampling

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)



The sample of HIECS 2017/2018 is a self-weighted two-stage stratified cluster sample.
The main elements of the sampling design are described in the following.

1- Sample Size
The sample size is around 26 thousand households. It was distributed between urban and rural with the percentages of 45% and 55%, respectively.

2- Cluster size
The cluster size is 20 households in all governorates.

3- Sample allocation in different governorates
45% of the survey sample was allocated to urban areas (12020 households) and the other 55% was allocated to rural areas (13780 households).
The sample was distributed on urban/rural areas in different governorates proportionally with the household size
A sample size of a minimum of 1000 households was allocated to each governorate to ensure accuracy of poverty indicators.
Therefore, the sample size was increased in Port-Said, Suez, Ismailiya, kafr el-Sheikh, Damietta, Bani Suef, Fayoum, Qena, Luxor and Aswan, by compensation from other governorates where the sample size exceeds a 1000 households. All Frontier governorates were considered as one governorate.

4- Core Sample
The core sample is the master sample of any household sample required to be pulled for the purpose of studying the properties of individuals and families. It is a large sample and distributed on urban and rural areas of all governorates. It is a representative sample for the individual characteristics of the Egyptian society.
This sample was implemented in January 2010 and its size reached more than 1 million household selected from 5024 enumeration areas distributed on all governorates (urban/rural) proportionally with the sample size (the enumeration area size is around 200 households).
The core sample is the sampling frame from which the samples for the surveys conducted by CAPMAS are pulled, such as the Labor Force Surveys, Income, Expenditure And Consumption Survey, Household Urban Migration Survey, ...etc, in addition to other samples that may be required for outsources.



A more detailed description of the different sampling stages and allocation of sample across governorates is provided in the Methodology document available among external resources in Arabic.
Response Rate
For the new sample, the response rate was 96.8% (94.2% in urban areas and 99.03% in rural areas).

Response rates on the governorate level at each sampling stage are presented in the methodology document attached to the documentation materials published in Arabic.
Weighting
In order for the sample estimates for the HIECS to be representative of the population, it is necessary to multiply the data by a sampling weight, or expansion factor. The basic weight for each sample household would be equal to the inverse of its probability of selection (calculated by multiplying the probabilities at each sampling stage).
The HIECS sample is approximately self-weighting at national level and strictly self-weighting at the governorate level, it should be easy to attach a weight to each sample household record in the computer files, and the tabulation programs can weight the data automatically. The sampling probabilities at each stage of selection will be maintained in an Excel spreadsheet so that the overall probability and corresponding weight can be calculated for each sample cluster.

The procedures for calculating the weights and variances are described in details in the methodology technical document attached to the documentation materials published in Arabic.

Data Collection

Dates of Data Collection
Start End Cycle
2017-10-01 2018-09-30 -
Data Collection Mode
Face-to-face [f2f]
Supervision
The field staff was selected from among the efficient experienced persons working in CAPMAS and new graduates specially females who live in the survey sampled aread.
Intensive training program for supervisors was conducted at CAPMAS in Cairo and locally in governorates for interviewers and field editors.
Supervision program was implemented in all governorates to check the field work to overcome the fieldwork problems.
Data were collected by 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.
The Fieldwork took place during the period of 1/10/2017 to 30/9/2018
Duties and responsibilities of all levels of field staff (260 interviewer, 130 field editor and 65 supervisor) were defined to insure the accuracy and timing. These are outlined next:

A more detailed description of the survey implementation stages is provided in the Methodology document available among external resources in Arabic.
Data Collection Notes
The reference period over which data was collected varies according to the type of data item as follows:

One week: for expenditure on food and beverages.
Monthly: for expenditure on alcoholic beverages, tobacco and narcotics, housing and its accessories goods and services for routine household maintenance, health, operation of personal transport equipments, transport services, restaurants and hotels, personal care and other services n.e.c.
Quarterly: for expenditure on health, Communication.
Annually: for expenditure on clothing and footwear, housing and its accessories, furnishings, household equipments and routine maintenance of the house, health, transport, communication, recreation and culture, education, restaurants and hotels and miscellaneous goods and services.

It is worth noting that in some cases the groups of commodities or services include more than one period such as health which has monthly, quarterly and annually items, on which the expenditure ends by the end of the survey period, depending upon the consumption frequency of these items.
Data Collectors
Name Abbreviation Affiliation
Central Agency For Public Mobilization & Statistics CAPMAS Egypt

Questionnaires

Questionnaires
Three different questionnaires have been designed as following:

1- Expenditure and Consumption Questionnaire.
2- Assisting questionnaire.
3- Income Questionnaire.

In designing the questionnaires of expenditure, consumption and income, we were taking into our consideration the following:
- Using the recent concepts and definitions of International Labor Organization approved in the International Convention of Labor Statisticians held in Geneva, 2003.
- Using the recent Classification of Individual Consumption According to Purpose (COICOP).
- Using more than one approach of expenditure measurement to serve many purposes of the survey.

A brief description of each questionnaire is given next:

----> 1- Expenditure and Consumption Questionnaire
This 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.

Section one: Household schedule and other information, it includes:
- Demographic characteristics and basic data for all household individuals consisting of 25 questions for every person.
- Members of household who are currently working abroad.
- The household ration card.
- The main outlets that provide food and beverage.
- Domestic and foreign tourism.
- The housing conditions including 16 questions.
- Household ownership of means of transportation, communication and domestic appliances.
- Date of purchase, status at purchase, purchase value and current imputed value of the
household possessed appliances and means of transportation.
- The Duration since the household was established
- The main outlet that provides fabrics, clothes and footwear.
-This section includes some questions which help to define the social and economic level of households which in turn, help interviewers to check the plausibility of expenditure, consumption and income data.

Section two: Expenditure and consumption data It includes 14 tables as follows:
1- The quantity and value of food and beverages commodities actually consumed.
2- The quantity and value of the actual consumption of alcoholic beverages, tobacco and narcotics.
3- The quantity and value of the clothing and footwear.
4- The household expenditure on housing.
5- The household expenditure on furnishings, household equipment and routine maintenance of the house.
6- The household expenditure on health care services.
7- The household expenditure on transportation.
8- The household expenditure on communication.
9- The household expenditure on recreation and culture
10- The household expenditure on education.
11- The household expenditure at restaurants and hotels.
12- The household expenditure on miscellaneous goods and services.
13- Transfer payments.
14- Total annual household expenditure

The tables from 1 to 13 include all types of commodities and services (850 Items), 50 Sub-group and 12 Main groups in addition to transfer payments.

This questionnaire has been designed to be pre-coded for all expenditure items and household characteristics, to avoid possible coding mistakes, except for the occupation and industry. Those were coded at the office following the International classifications for occupation and industry. On the questionnaire cover, geographic information were coded at the office, as well, following the Administrative Classification.

The questionnaire was designed to cover different reference periods for expenditure data, since they differ based on the expenditure nature. The reference period agreed upon for regular consumption of commodities such as those related to food and beverage is two weeks. Alcoholic beverages and Tobacco are collected for a reference of one month ending by the end of the survey period. Commodities and services consumed on a semi-regular basis are collected for a reference of 3 month while commodities and services consumed less regularly are collected on annual basis, ending by the end of the survey period.
The total number of items increased to 850 commodity and service compared to 778 in 2012/2013 survey.

----> 2 - Assisting questionnaire
The assisting questionnaire 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 reference period.
Therefore, this questionnaire is considered the main source of expenditure data on food and beverage, and was designed in a very simple form to facilitate using it by the surveyed household and the interviewers during their frequent visits to the household.
Due to the importance of such a questionnaire, the households are required to record their expenses daily, and the interviewers are instructed to check what households have recorded during their 6 visits to the household during the survey period. In case of the inability of some households to record their daily expenditure, the interviewer has to do so.

The questionnaire includes:
a- Letter addressed to the head of household to inform him/her about the importance of survey so that his/her cooperation may be stimulated.
b- Instructions of data recording for households and interviewers.
c- A group of modules to record daily consumption of household as follows:

Module (A): Includes twenty pages to record the daily consumed quantity and value of food and beverages, during the survey period. Each pages consists of 4 columns and each column is used to register the data of one good, including:
Date, source of commodity, quantity and value.
Module (B): Includes ten pages to record the value of expenditure for meals and tobacco outside the house, in addition to the value of expenditure for food prepared outside the house and consumed inside the house.
Module (C1): Includes 12 pages to record the total of quantity and value of consumed food and beverages according to source, either from household production or in-kind transfer, during the survey period using the data recorded in Module (A).
Module (C2): Includes 6 pages to record the total of quantity and value of actually consumed food and beverages according to source, either from household production or in-kind transfer, during the survey period using the data recorded in Module (A).
Module (D): Includes two pages to record total expenditure on food and beverages consumed outside home during the survey period using the data recorded in Module (B).

----> 3- Income questionnaire
It includes annual household income data according to income sources (excluding irregular incomes).
It consists of several tables; each is designated to a specific income source. These sources are:
- Wages and salaries for wage/salary for earners among household members.
- Self-employed income from agriculture projects.
- Self-employed income from non Agriculture projects.
- Financial properties such as stocks, bonds, deposits and investment certificates.
- Non- financial properties such as agriculture or non-agriculture land and rented to others properties.
- Imputed rent of owner-occupied dwellings.
- Received cash and in kind transfers

Data Processing

Data Editing
----> Raw Data

- Data entry was conducted using the tablets carried by interviewers upon data collection, during visits.
- Data entry programs were designed and implemented by data experts in CAPMAS
- Those programs are flexible and user friendly.
- Validation rules were further added to the entry programs to ensure data is correctly entered.
- Further errors are produced in reports through the same program.
- Errors are then corrected to ensure data files produced are free of error.

----> Harmonized Data

- The Statistical Package for Social Science (SPSS) is used to clean and harmonize the datasets.
- The harmonization process starts with cleaning all raw data files received from the Statistical Agency.
- Cleaned data files are then all merged to produce one data file on the individual level containing all variables subject to harmonization.
- A country-specific program is generated for each dataset to generate/compute /recode/rename/format/label harmonized variables.
- A post-harmonization cleaning process is then conducted on the data.
- Harmonized data is saved on the household as well as the individual level, in SPSS and converted to STATA format.

Access policy

Access authority
Name Affiliation Email URL
Economic Research Forum (ERF) erfdataportal@erf.org.eg www.erf.org.eg
Contacts
Name Affiliation Email URL
Economic Research Forum (ERF) - 21 Al-Sad Al-Aaly St., Dokki, Giza, Egypt ERF erfdataportal@erf.org.eg www.erf.org.eg
Confidentiality
To access the micro data, researchers are required to register on the ERF website and comply with the data access agreement. The 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.
Access conditions
Licensed datasets, accessible under conditions.
Citation requirements
The users should cite the Economic Research Forum and Central Agency For Public Mobilization & Statistics as follows:

OAMDI, 2021. Harmonized Household Income and Expenditure Surveys (HHIES), http://www.erf.org.eg/cms.php?id=erfdataportal. Version 2.0 of Licensed Data Files; HIECS 2017 - Central Agency for Public Mobilization and Statistics (CAPMAS). Egypt: Economic Research Forum (ERF).

Disclaimer and copyrights

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.
Copyright
(c) 2021, Economic Research Forum | (c) 2018, CAPMAS, Egypt

Metadata production

DDI Document ID
EGY_HIECS_2017_HD_V2.0
Producers
Name Abbreviation Role
Economic Research Forum ERF Cleaning and harmonizing raw data received from the Statistical Agency
Date of Metadata Production
2021-02
DDI Document version
Version 2.0
ERF NADA

© ERF NADA, All Rights Reserved.