Page 213 - Contributed Paper Session (CPS) - Volume 3

CPS1997 Rawia Wagih Abd ElMagid ElSayed R. et al.
database through the creation of a comprehensive economic frame for the
extraction of various economic indicators.
Therefore, this paper will discuss how to overcome the duplication of data
and having only one data source by creating a unique code (ID) for each
establishment with generating the Master Establishment Frame (MEF) because
CAPMAS conducts many different regular establishments surveys and each
survey has its own frame and the total number of related overlapped frames
is 68 frames for 180 bulletin. We found out the problem of data duplication
and this will be solved using MEF then integrating the frames of the Egyptian
economic census (8 frames), which was made by sampling technique, is the
first part and the second part is composed of two parts. Firstly, creating the
inner frame from each of CAPMAS regular statistics frames and then merging
and comparing with these frames. Secondly, creating the external frame from
the Ministry of Investment’s statistics, the Federation of Industries and
Chambers of Commerce then configuration of the Main Economic Aggregated
Frame (MEAF) and doing merge and compare with these frames. Finally,
generating the Master Establishment Frame (MEF) with performing a merge
between two parts and then eliminating the overlapping between these
frames is the best way to solve the problem of data duplication because we
have the same establishment with more than one name or label although it
has a problem because after generating MFE it will have nearly 100000
establishments that have a lot of cost to validate the frame with fieldwork and
must update the MEF permanently because it is the main source of data so
that any operating establishment will be registered in the Ministry of
Investments. With regard to closed establishments, we do not have any
information about that except only from field work that they have a lot of
money.
In the future, the most effective sampling frame for the Economic Census
and annual economic surveys will be a complete business register, with
information on 4 or 6-digit international standard industrial classification (ISIC)
codes, number of employees, capital investment and other available size
measures, as well as identification details such as name of the establishment,
type of ownership or corporation, address, telephone numbers, e-mail address
and website (if available). In addition, there should be unique identification
codes and information to link enterprises with component establishments.
CAPMAS has already considered developing this type of business register,
and has explored different sources of information for compiling this type of
sampling frame in the future and to achieve that CAPMAS has generated the
MEF. This indeed will have a great effect on the quality of the statistical data
and work especially that CAPMAS is the main source of data which affects the
economic and financial policies and their future trends.

202 | I S I W S C 2 0 1 9