The Harmonized Employment, Wage and Working Hours, HEWW 2022 - Egypt, Arab Rep.

Abstract --------------------------- ********************************************************************************************************************************************************************* ********************************************************************************************************************************************************************* THE CLEANED AND HARMONIZED VERSION OF THE SURVEY DATA PRODUCED AND PUBLISHED BY THE ECONOMIC RESEARCH FORUM REPRESENTS 100% OF THE ORIGINAL SURVEY DATA COLLECTED BY THE CENTRAL AGENCY FOR PUBLIC MOBILIZATION AND STATISTICS (CAPMAS) ********************************************************************************************************************************************************************* ********************************************************************************************************************************************************************* The Central Agency for Public Mobilization and Statistics collects annual establishment data on employment size, average wages, and average monthly working hours in public business sector and private sector establishments. These data provide indicators by economic activity (excluding agricultural activities not conducted within establishments), geographical distribution, and occupational classification. Egypt has extensive experience in conducting establishment surveys. The first establishment survey on employment, wages, and hours of work was carried out in 1942, twice a year-in January and July. The current survey programme is implemented annually, using June as the reference period. In 2020, the survey design was revised to enable the collection of occupational wage data for individual sampled employees at the 6-digit level of the occupational classification. A further major revision was introduced in 2022, adding new sections to gather information on the skills required for occupations represented in the sample of establishment workers, as well as the skills required for current vacancies, and those anticipated for future recruitment. Geographic coverage --------------------------- Covering a sample of urban and rural areas in all the governorates. Analysis unit --------------------------- Establishment Universe --------------------------- The survey covered all active establishments within the scope of the economic census of 2017-2018 with a few exceptions. (see attched documents) Kind of data --------------------------- Sample survey data [ssd] Sampling procedure --------------------------- ********************************************************************************************************************************************************************* ********************************************************************************************************************************************************************* THE CLEANED AND HARMONIZED VERSION OF THE SURVEY DATA PRODUCED AND PUBLISHED BY THE ECONOMIC RESEARCH FORUM REPRESENTS 100% OF THE ORIGINAL SURVEY DATA COLLECTED BY THE CENTRAL AGENCY FOR PUBLIC MOBILIZATION AND STATISTICS (CAPMAS) ********************************************************************************************************************************************************************* ********************************************************************************************************************************************************************* The sampling frame is constructed using explicit stratification by governorate and establishment size class. Stratification by economic activity is applied implicitly by sorting the list of establishments within each explicit stratum according to their 4-digit activity code, in order to avoid excessively large number of strata. All public sector enterprises are included in the sample (100 percent). For enterprises operating multiple establishments ("branches"), up to five branches in addition to the headquarters (HQ) are selected. This approach ensures that the sampling unit reflects public sector establishments rather than enterprises, which may consist of several establishments carrying out different economic activities. For the private sector, the sampling design is based on stratification by governorate and five establishment size classes defined by number of employees. Sampling rates vary by size class, with smaller establishments selected at lower rates and larger establishments at higher rates. Employee characteristics are collected at the individual employee level on a sample basis, using the same approach for both public (HQ and branches) and private sector establishments. The design specifies the use of systematic sampling from an establishment's employee list sorted by occupation. In practice, however, the selection of sample employees was performed directly by the establishments. Mode of data collection --------------------------- Face-to-face [f2f] Research instrument --------------------------- The full survey questionnaire is structured into three parts. The first part gathers general data on the establishment, including its branch of economic activity and lots of information like whether it has a commercial or industrial register, and accounting books or not. The second part covers characteristics of employees-first at the establishment level, and then at the level of sampled employees-capturing information on occupation, wages, hours of work, skills, social security coverage provided by the employer, and access to paid annual or sick leave. The third part collects data on job vacancies, hirings, and separations. Cleaning operations --------------------------- Data Processing 1- Coding Specialized staff is responsible for coding data of activity, occupation and geographical identification according to activity, occupation and geographical manual, thus the questionnaires will be valid for data entry. 2- Data entry and tabulations It included machine data entry, data validation and tabulation as well as preparing a final survey bulletin and output tables. ---> Raw Data Office editing is one of the main stages of the survey. It started once the questionnaires were received from the field and accomplished by the selected work groups. It includes: a-Editing of coverage and completeness b-Editing of consistency ---> Harmonized Data - The STATA package is used to clean and harmonize the datasets. - The harmonization process starts with a cleaning process for all raw data files received from the Statistical Agency. - All cleaned data files are then 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 in SPSS and then converted to STATA, to be disseminated.