Labor Market Panel Survey, ELMPS 2018

Egypt, Arab Rep., 2018
Labor Market Panel Surveys

Economic Research Forum

Data file: elmps 2018 rep xs 88_18 v2.0

The elmps 2018 rep xs 88-18 v2.0.dta contains (only the created, compatible variables across time.)
• The data are long structure, observation is an individual & year combination

Important Variables:
==============
1- round: Identifies wave of survey (1988, 1998, 2006, 2012, 2018)
2- indid: unique individual identifier
3- hhid: unique household identifier

Note: Data is not self-weighted. For details on the creation of sample weights, see: Krafft, C., Assaad, R., and Rahman, K. (2019) . Introducing the Egypt Labor Market Panel Survey 2018. Economic Research Forum Working Paper No. 1360

Cases:	199182
Variables:	650

Variables

round

Wave of the survey (year)

indid

Unique individual ID

hhid

Unique household ID

pn

Individual no. in HH

Findid

Unique Indiv. ID when first obs.

Fhhid

Unique Household ID when first obs.

Fpsu

PSU household first sampled under

hhtype

Type of household

indtype

Type of individual

attr_98_06_12_18

Attrition from 1998 to 2018

in_2018

Individual observed in 2018 round

in_2012

Individual observed in 2012 round

in_2006

Individual observed in 2006 round

in_1998

Individual observed in 1998 round

indid_18

Individual ID 2018

indid_12

Individual ID 2012

indid_06

Individual ID in 2006

indid_98

Individual ID in 1998

hhid_18

Household ID 2018

hhid_12

Household ID 2012

hhid_06

hhid_98

pn_18

Individual no. in HH in 2018

pn_12

Individual no. in HH in 2012

pn_06

Person No. in 2006

pn_98

Person No. in 1998

visit_d

First visit day

visit_m

First visit month

visit_y

First visit year

visit_date

First visit date

expan_ref_hh

Expansion weight-refresher only-households

expan_ref_indiv

Expansion weight-refresher only-individuals

expan_hh

Expansion weight-households

expan_indiv

Expansion weights-individuals

valid_indiv

indicator that the individual consents

gov

region

urban

qism

shyakha

psu

ref_poor

Refresher sample poor stratum

sex

brthyr

brthmth

age

agegrp1

Age (Ten groups)

agegrp2

Age (Sixteen groups)

reltohd

Relation to the head of hh

hhsize

marital

agemar1

Age at first marriage

sppres

spcode

wealth

Household wealth score

dwealth

Deciles of household wealth

qwealth

Quintiles of household wealth

wlthurb

Household wealth score--urban only

wlthrur

Household wealth score--rural only

dwlthurb

Deciles of household wealth--urban only

dwlthrur

Deciles of household wealth--rural only

qwlthurb

Quintiles of household wealth--urban only

qwlthrur

Quintiles of household wealth--rural only

mnthbirth1

Month of birth -- child 1

mnthbirth2

Month of birth -- child 2

mnthbirth3

Month of birth -- child 3

mnthbirth4

Month of birth -- child 4

mnthbirth5

Month of birth -- child 5

mnthbirth6

Month of birth -- child 6

mnthbirth7

Month of birth -- child 7

mnthbirth8

Month of birth -- child 8

mnthbirth9

Month of birth -- child 9

mnthbirth10

Month of birth -- child 10

mnthbirth11

Month of birth -- child 11

mnthbirth12

Month of birth -- child 12

mnthbirth13

Month of birth -- child 13

yrbirth1

Year of birth -- child 1

yrbirth2

Year of birth -- child 2

yrbirth3

Year of birth -- child 3

yrbirth4

Year of birth -- child 4

yrbirth5

Year of birth -- child 5

yrbirth6

Year of birth -- child 6

yrbirth7

Year of birth -- child 7

yrbirth8

Year of birth -- child 8

yrbirth9

Year of birth -- child 9

yrbirth10

Year of birth -- child 10

yrbirth11

Year of birth -- child 11

yrbirth12

Year of birth -- child 12

yrbirth13

Year of birth -- child 13

student

Is individual currently studying?

educ

Educational Attainment (7 Categories, age 10+)

educ1

Educational Attainment (6 Categories, age 10+)

educ2

Educational Attainment (8 Categories, age 10+)

educlvl

Educational Attainment (6 Categories, age 6+)

educlvl1

Educational Attainment (7 Categories, age 6+)

educlvl2

Educational Attainment (9 Categories, age 6+)

certif_nh

Certificate specialization, valid for Higher Education

certif2_nh

Aggregated education certificate code (4-digit for all rounds)

yrschl

Years of School

imp_yrschl

Imputed Years of School (1988)

fthcode

fteducst

Father's Level of education attained

ftempst

Father's Employment Status (When Resp. 15)

ftirreg

Father Irregular (When Resp. 15)

ftoccup_nh

Father's Occupation (When Resp. 15)

ftocp1d

Father's Occup. of prim. job (1-digit, When Resp. 15)

ftocp2d_nh

Occup. of father's prim. job (2-digit, When Resp. 15)

ftocp3d_nh

Occup. of father's prim. jb (3-digit, When Resp. 15)

ftsectr

Father's Sector (When Resp. 15)

mthcode

mteducst

Mother's Level of education attained

mtempst

Mother's Employment Status (When Resp. 15)

mtirreg

Mother Irregular (When Resp. 15)

mtoccup_nh

Mother's Occupation (When Resp. 15)

mtocp1d

Mother's Occup. of prim. job (1-digit, When Resp. 15)

mtocp2d_nh

Occup. of mother's prim. job (2-digit, When Resp. 15)

mtocp3d_nh

Occup. of mother's prim. jb (3-digit, When Resp. 15)

mtsectr

Mother's Sector (When Resp. 15)

nlivingb

No. living brothers

ndeadb

No. dead brothers

nlivings

No. living sisters

ndeads

No. dead sisters

nbrothers

No. brothers (living and dead)

nsisters

No. sisters (living and dead)

nsibs

No. siblings (living and dead)

crunempdur_m

Current unemployment duration (in months)

unemp1

Broad unemployed with mrkt definition (search is not required)

unemp2

Broad unemployed with extend. def. (search is not required)

unempsr1

Std. unemployed with mrkt def. (search is required)

unempsr2

Std. unemployed with extend. def. (search is required)

unemp1m

Unemployed broad mrk def., with missing if out of labor force

unemp2m

Unemployed broad ext. def., with missing if out of labor force

unempsr1m

Std. unemployed with mrkt. def. (search req.), with missing out of the labor for

unempsr2m

Std. unemployed with ext. def. (search req.), with missing out of the labor forc

unwrkevr1

Unempl. worked before, missing if OLF or employed (mkt defn)

unwrkevr2

Unempl. worked before, missing if OLF or employed (ext. defn)

search

If individual is searching for a job

unjbsr1

Search for job register in govern.office

unjbsr2

Search for job register in private office

unjbsr3

Search for job enter gov. job lottery compet.

unjbsr4

Search for job send job application

unjbsr5

Search for job inquired at work loc.

unjbsr6

Search for job advertised in newsp.

unjbsr7

Search for job applied to an advertised job in newsp.

unjbsr8

Search for job asked friends or relatives for help

unjbsr9

Search for job contacted contractor

unjbsr10

Search for job waited at gatherings loc.

unjbsr11

Search for job searched for prvt project (land, equip.)

unjbsr13

Search for job arranged to get finance for a prvt project

unjbsr14

Search for job contacted employer

unjbsr15

Search for job in other

unjbsr16

Search for job look at job advertisements in a newspaper or online

unjbsr17

Search for job register at an employment website

rsnnosrch

Reason for not searching for a job

rsunemp

Why NOT working during the ref. week?

evrwrk

Has individual ever worked?

crlf1

In lf during ref. week, mrket def. (search is not required)

crlf2

In lf during ref. week, extend. def. (search is not required)

crlfsr1

In lf during ref. week, mrkt. def. (search is required)

crlfsr2

In lf during ref. week, extend. def. (search is required)

uslf1

In lf during ref. 3-mnths, mrkt. def. (search is not required)

uslf2

In lf during ref 3-mnths, ext. def. (search is not required)

uslfsr1

In lf during ref. 3-mnths, mrkt. def. (search is required)

uslfsr2

In lf during ref. 3-mnths, ext. def. (search is required)

rsnolf

Reason out of the labor force

jobless1

Jobless, Market Definition (Among non-students)

jobless2

Jobless, Extended Definition (Among non-students)

fnunempRC

Right Censored First NEW Unemployment

fnunempdur_m

First NEW Unemployment Duration (Months)

cremp1

Employed with mrket definition (ref 1-week)

cremp2

Employed with extend. def. (ref. 1-week)

usemp1

Employed with mrkt. def. (ref. 3-mnths)

usemp2

Employed with ext. definition (ref. 3-mnths)

perm_disab

Permanently Disabled, not incl. in LF or Emp.

crmanpwr1

Manpower Basis Mkt. Def. (ref 1-week)

crmanpwr2

Manpower Basis Ext. Def. (ref 1-week)

usmanpwr1

Manpower Basis Mkt. Def. (ref 3-month)

usmanpwr2

Manpower Basis Ext. Def. (ref 3-month)

crwrkst1

Work status during ref. week, market def. (search is not required)

crwrkst2

Work status during ref. week, extend. def. (search is not required)

uswrkst1

Work status during ref. 3-month, market def. (search is not required)

uswrkst2

Work status during ref. 3-month, extend def. (search is not required)

crwrkstsr1

Work status during ref. week, market def. (search required)

crwrkstsr2

Work status during ref. week, extend. def. (search required)

uswrkstsr1

Work status during ref. 3-month, market def. (search required)

uswrkstsr2

Work status during ref. 3-month, extend def. (search required)

crempstp

employment status in prim job (ref. 1-week)

crsectrp

Economic sector of prim. job (ref. 1-week)

crstablp

Job stability in prim. job (ref. 1-week)

crirreg

crr. main job(ref. week) is irregular

crestblp

Wrk in establish. in primary job (ref. 1-week)

croccupp_nh

Occup. of crr. jb (6-digit based on ISCO88, ref. 1-week)

crocp1d

Occup. of crr. job (1-digit based on ISCO88, ref. 1-week)

crocp2d_nh

Occup. of crr. job (2-digit based on ISCO88, ref. 1-week)

crocp3d_nh

Occup. of crr. jb (3-digit based on ISCO88, ref. 1-week)

crocpcl_85cd

Current Job Occupation(1-digit, 1985-CODE INDEX)

crocp1d_85cd

Current Job Occupation(1-digit, 1985-CODE INDEX, used in 88/98)

crocp2d_85cd

Current Job Occupation(2-digit, 1985-CODE INDEX, used in 88/98)

crocp3d_85cd

Current Job Occupation(3-digit, 1985-CODE INDEX, used in 88/98)

crecactp_nh

Economic activity of prim. job (6-digit, based on ISIC4, ref. 1-week)

crecac1d_cl

Economic activity of crr. job (Sections(1digit), based on ISIC4, ref. 1-week)

crecac2d_nh

Economic activity of crr. job (2-digit, based on ISIC4, ref. 1-week)

crecac3d_nh

Economic activity of crr. job (3-digit, based on ISIC4, ref. 1-week)

crecac1d_86cd

Current Job Economic Activity (1-digit, 1986-CODE INDEX, used in 88/98)

crecac2d_86cd

Current Job Economic Activity (2-digit, 1986-CODE INDEX, used in 88/98)

crecac3d_86cd

Current Job Economic Activity (3-digit, 1986-CODE INDEX, used in 88/98)

crsocinsp

Incidence of wrk social insurance in prim. job (ref. 1-Week)

crcontrp

Incidence of wrk contract in prim. job (ref. 1-Week)

crformal

Formality of prim. job (ref. 1-Week)

crinstsec

Institutional Sector Crr. Job (ref 1-week)

crfirm_size

Size of Firm, Crr. Job (ref. 1-week)

dstcrj

Crr. Job Start Date

ussamep

Is job in ref. week the longst prim. job during ref. 3-months?

usempstp

Employment status in prim job (ref. 3 months)

ussectrp

Economic sector of prim. job (ref. 3-mnths)

usstablp

Job stability in prim. job (ref. 3-mnths)

usirreg

Usual main job(ref. 3-month) is irregular

usestblp

Wrk in establish. in primary job (ref. 3-mnths)

usoccupp_nh

Occup. of prim. jb (6-digit based on ISCO88,ref. 3-mnths)

usocp1d

Occup. of prim. job (1-digit based on ISCO88, ref. 3-mnths)

usocp2d_nh

Occup. of prim. job (2-digit based on ISCO88, ref. 3-mnths)

usocp3d_nh

Occup. of prim. jb (3-digit based on ISCO88,ref. 3-mnths)

usocpcl_85cd

Usual Job Occupation(1-digit, 1985-CODE INDEX)

usocp1d_85cd

Usual Job Occupation(1-digit, 1985-CODE INDEX, used in 88/98)

usocp2d_85cd

Usual Job Occupation(2-digit, 1985-CODE INDEX, used in 88/98)

usocp3d_85cd

Usual Job Occupation(3-digit, 1985-CODE INDEX, used in 88/98)

usecactp_nh

Economic activity of prim. job (6-digit, based on ISIC4, ref. 3-mnths)

usecac1d_cl

Economic activity of prim. job (1digit), based on ISIC4, ref. 3-mnths)

usecac2d_nh

Economic activity of prim. job (2-digit, based on ISIC4, ref. 3-mnths)

usecac3d_nh

Economic activity of prim. job (3-digit, based on ISIC4, ref. 3-mnths)

usecac1d_86cd

Usual Job Economic Activity (1-digit, 1986-CODE INDEX, used in 88/98)

usecac2d_86cd

Usual Job Economic Activity (2-digit, 1986-CODE INDEX, used in 88/98)

usecac3d_86cd

Usual Job Economic Activity (3-digit, 1986-CODE INDEX, used in 88/98)

ussocinsp

Incidence of wrk social insurance in prim. job (ref. 3-month)

uscontrp

Incidence of wrk contract in prim. job (ref. 3-month)

usformal

Formality of prim. job (ref. 3-month)

usinstsec

Institutional Sector Prim. Job (ref 3-month)

usfirm_size

Size of Firm, Prim. Job (ref. 3-month)

usmedins

Incidence of medical insurance in prim. Job (ref. 3-month)

uspdleave

Incidence of paid leave in prim. Job (ref. 3-month)

uspdsick

Incidence of sick leave in prim. Job (ref. 3-month)

usnumjbs

Usu. num. of prim. jobs

usfmwrkprcnt

Percent. of female employees in your primary job

unionont

Member in a trade union

skilreq

Does primary job require any skill

skillev

The level of his skill

lglstsco

Leg. stat. of comp.

ustrvtmp

Travel time to wrk. (in minutes) in prim. job (ref. 3-month)

crnumdys

No. of Days/Week (Ref. 1 Week) Market Work

crhrsday

No. of Hours/Day (Ref. 1 Week) Market Work

crnumdys_ms

No. of Days/Week (Ref. 1 Week) Market & Substistence Work (1988)

crhrsday_ms

No. of Hours/Day (Ref. 1 Week) Market & Subsistence Work (1988)

crnumhrs1

Crr. No. of Hours/Week, Market Work, (Ref. 1 Week).

crnumhrs2

Crr. No. of Hours/Week, Market & Subsistence Work, (Ref. 1 Week)

ushrsday

No. of Hours/Day (Ref. 3 mnths) Market Work

ushrsday_ms

No. of Hours/Day (Ref. 3 mnths) Market & Subsistence Work (1988)

ushrswk1

Usual No. of Hours/Week, Market Work, (Ref. 3-month).

ushrswk2

Usual No. of Hours/Week, Market & Subsistence Work, (Ref. 3-month)

usnumdys

Avg. num. of wrk. days per week during 3 mnth.

ushrs3mnth

Usual No. of Hours in 3 months Market Work (Ref. 3-month)

avhrspmir

Average worked hour per month for irregular job

rsnlt35

Reason working fewer than 35 hours

rsnlt40

Reason working fewer than 40 hours

prttmav

Involuntary Part-Time, available

jbsrmta

How obtained main job

jbsrmtb

How obtained main job--Secondary method

mtwgdet

How wage in the longest main job calc.

basicwg3

Basic Wage (3-month)

boninct3

Bonuses and incentives (3-month)

ovrtime3

Overtime Wage (3-month)

prftshr3

Profit Sharing (3-month)

otherwg3

Other Wage (3-month)

ttmonwg3

Total Wages (3-month)

avdwirmn

Average Daily Wage (Irregular Workers)

avdwirkd

Average Daily Wage (In Kind, Irregular Workers)

avwgdtot

Total Average Daily Wage (Monetary & In Kind, Irregular Workers)

hrwg

Hourly Wage (Primary Job)

mnthwg

Monthly Wage (Primary Job)

hrwgAllJob

Hourly Wage (Prim. & Second. Jobs)

mnthwgAllJob

Monthly Wage (Prim. & Second. Jobs)

CPI88in18

Consumer Price Index for 88 relative to 2018

CPI98in18

Consumer Price Index for 98 relative to 2018

CPI06in18

Consumer Price Index for 06 relative to 2018

CPI12in18

Consumer Price Index for 12 relative to 2018

RhrwgCPI18

Real Hourly Wage (in 2018 L.E. using CPI)

RmnthwgCPI18

Real Monthly Wage (in 2018 L.E. using CPI)

RhrwgAllJobCPI18

Real Hourly Wage All Jobs (in 2018 L.E. using CPI)

RmnthwgAllJobCPI18

Real Monthly Wage All Jobs (in 2018 L.E. using CPI)

scjob

Incidence of secondary job

scnumjbs

Num. sec. job in ref. year

scempst

Employment status in secondary job (ref 3-month)

scoccup_nh

Occup. in sec. job

scecact_nh

The econ. activ. of sec. job

scsectr

Sector. Sec. Job.

scstabl

Stabil. Sec. Job.

scestbl

Sec. Job in Establ.

schrsday

Avg. hrs per day in sec. job during 3 mnths.

schrswk

No. of Hours/Week in all Second. Jobs

schrs3mnth

No. of Hours in 3 months in all Second. Jobs

scavhrsday

Avrg. Hours/Day in all Second. Jobs

Total: 650

1 2 3 >