Value |
Category |
* Employed (age 12+) |
|
* Sector and Activity |
|
* Unemployed (age 12+ |
|
* employer characteristics |
|
* incomes and Expenditures |
|
* lfstatus |
|
* to complete level 1 and level 2 values |
|
**** Labor Force characteristics and ownership |
|
***** variables definition for adept |
|
************************* |
|
*/ 16 Standard VI (completed but not passed/now in std VI) 17 Standard VI passed / CPE / PSLC 21 Form I 22 Form II 23 Form II Prevoc/* |
|
*/ 24 Form III 25 Form III Pevoc 26 Form IV 27 Form V not passed 28 Form V pSSED 29 Form VI not passed 30 Form VI passed 31HSC or equivalent |
|
*/1 Studying/training/* |
|
*/1 Wage and salary worker/* |
|
*/10 New job or own business to start soon/* |
|
*/11 Suitable jobs not available/* |
|
*/12 Do not know how and where to look for work/* |
|
*/13 Got tired/frustrated of seeking work/* |
|
*/14 Other, specif |
|
*/2 Employer/* |
|
*/2 Local Government - Municipal Councils/* |
|
*/2 Will resume studies soon/* |
|
*/3 Local Government - District Councils/* |
|
*/3 Own Account Worker/* |
|
*/3 Retired/too old to work/* |
|
*/4 Contributive family worker/* |
|
*/4 Permanent disability/* |
|
*/4 Publicly owned and controlled enterprises/* |
|
*/5 Members of cooperatives/* |
|
*/5 Privately owned business - Export Oriented Enterprise (EOE)/* |
|
*/5 Temporary illness/injury/* |
|
*/6 Other |
|
*/6 Privately owned business - Other/* |
|
*/6 Savings/property income 7 Government pension/assistance 8 Other pension/work compensation 9 Other, specify |
|
*/6 Too young to work/* |
|
*/7 Parents or spouse not agreeable/* |
|
*/7 Private household services |
|
*/8 Household/family responsibilities/* |
|
*/9 Not interested to work/* |
|
*egen totcons =rsum(consumexp imputerent) |
|
*kkk |
|
cd C:\Users\wb217026\work\Mauritius\CMPHS\2012\DATA_ORIGINAL\ |
|
drop t |
|
egen hhsize=sum(t) |
|
egen totcons =rsum(consumexp) |
|
egen totinc=sum(totincind) |
|
egen totincind =rsum(totalincomefromwork totaltransferincome) |
|
gen firmtype=1 if establishmentname>0&establishmentname<=3 |
|
gen lfstatILO=1 if (employed==1 & employmentstatus==4|employmentstatus==3) /*wage and salary worker*/ |
|
gen familyworker=(employed==1 & employmentstatus==6) /*Contributive family worker*/ |
|
gen ownaccountwork=(employed==1 & employmentstatus==2) /*own account worker*/ |
|
gen wageworker=(employed==1 & employmentstatus==4|employmentstatus==3) /*wage and salary worker*/ |
|
gen activity1=floor(activity/10) |
|
gen cpi=151.826484018265/100 |
|
gen earning=income |
|
gen educ= 1 if educationlevel ==. |
|
gen empcontrpens=empnps==1 |
|
gen employed =(workforihr==1|activitiesforsalepay==1|absentfromwork==1) |
|
gen enrolled=whenstudied <4 |
|
gen hhid=questno |
|
gen hours=hrsmainjob |
|
gen icp=17.7250166442 |
|
gen inactive=unempl~=1&employed~=1 |
|
gen lfstatus=. |
|
gen mainsource = 1 if sourceofincome < 6 |
|
gen morehours=addwork==1 |
|
gen occup1=floor(occupation/10) |
|
gen pline125=1.25*365/12*icp |
|
gen pline200=2*365/12*icp |
|
gen pline250=2.5*365/12*icp |
|
gen pline400=4*365/12*icp |
|
gen poor125=totconspcR
|
|
gen poor200=totconspcR
|
|
gen poor250=totconspcR
|
|
gen poor400=totconspcR
|
|
gen pubempl=(firmtype==1&employed==1) |
|
gen reasoninactive =1 if whynotavailable==1 /*educ*/ |
|
gen reltohead=relationtohead |
|
gen secondjob=otherjob==1 |
|
gen t=1 |
|
gen totconspc=totcons/hhsize |
|
gen totconspcR=totconspc/cpi |
|
gen totincpc=totinc/hhsize |
|
gen totincpcR=totincpc/cpi |
|
gen unempl=(lookwk==1&employed~=1)&age>12 |
|
gen unemplduraion=timelookwork |
|
gen urb=district==11 |
|
keep weight enrolled inactive reasoninactive unemplduraion lfstatILO occup1 activity1 pubempl wageworker familyworker ownaccountwork wageworker district secondjob earning hours morehours urb hhid totincpc totinc totincind reltohead totconspc hhsize totcons mainsource lfstatus unempl firmtype employed educ imputerent memberno empcontrpens age sex maritalstat size activity occupation whynotavailable |
|
lab def district 11 Port Louis 12 Pamplemousses 13 Riviere du Rempart 14 Flacq 15 Grand Port 16 Savanne 17 Plaine Wilhems 18 Moka 19 Black River 1 Rodrigues |
|
lab def employed 1 Employed 0 Not Employed |
|
lab def establishmentname 1 Central Government (Ministries and Departments of Ministries)/* |
|
lab def firmtype 1 Public Sector 2 Publicly owned and controlled enterprises 3 Privately owned business |
|
lab def inactive 1 inactive 0 Other |
|
lab def lfstatILO /* |
|
lab def lfstatus 1 Employer 2 Self Employed 3 Employee 4 Unemployed 5 Student 6 Retired 7 Hose/wife 8 Disabled 9 Out LF other |
|
lab def mainsource 1 Relatives 2 Savings/property income 3 Government pension/assistance 4 Other pension/work compensation 5 Other, specify |
|
lab def pubempl 1 Public Sector 0 other |
|
lab def reasoninactive 1 Education 2 Family responsibility 3 Discouragement 4 Other |
|
lab def size 1 Under 5 2 5 to 9 3 10 or more |
|
lab def sourceofincome 1 Parents 2 Spouse/partner 3 Children 4 Other relatives/non relatives 5 Maintenance alimony (ex-spouse) /* |
|
lab def unempl 1 Unemployed 0 Other |
|
lab def whynotavailable /* |
|
lab define educ 1 non 2 preprimary 3 Primary 4 Secondary 5 Above secondary |
|
lab define educationlevel 1 Preprimary 11 Standard I 12 Standard II 13 Standard III 14 Standard IV 15 Standard V /* |
|
lab define enrolled 1 Study now 0 not study |
|
lab define maritalstat 1 Married/ in a union 2 Widowed 3 Divorced 4 separated 5 Single |
|
lab define sex 1 Male 2 Female |
|
lab val district district |
|
lab val educ educ |
|
lab val educationlevel educationlevel |
|
lab val employed employed |
|
lab val enrolled enrolled |
|
lab val establishmentname establishmentname |
|
lab val firmtype firmtype |
|
lab val inactive |
|
lab val lfstatILO lfstatILO |
|
lab val lfstatus lfstatus |
|
lab val mainsource mainsource |
|
lab val maritalstat maritalstat |
|
lab val pubempl pubempl |
|
lab val reasoninactive reasoninactive |
|
lab val sex sex |
|
lab val size size |
|
lab val sourceofincome sourceofincome |
|
lab val unempl unempl |
|
lab val whynotavailable whynotavailable |
|
lab var activity Sector 2 digit (NSIC Rev. 2) |
|
lab var activity1 Sector 1 digit |
|
lab var age Age individual |
|
lab var district District |
|
lab var earning Earning last month |
|
lab var educ level of Education |
|
lab var educationlevel Broad level of Education |
|
lab var empcontrpens Employer contribute pesnion scheme |
|
lab var employed Employed (ILO definition) |
|
lab var enrolled study now |
|
lab var establishmentname Employer Type |
|
lab var familyworker Contributive family worker |
|
lab var firmtype Firm Ownership |
|
lab var hhsize Households size, computed |
|
lab var hours hours last week main job |
|
lab var inactive inactive dummy |
|
lab var lfstatILO Out LF reason |
|
lab var lfstatus LF Status |
|
lab var mainsource Main Sources of income |
|
lab var maritalstat Marital Status |
|
lab var morehours willing work more hours |
|
lab var occup1 Occupation 1 digit |
|
lab var occupation Occupaction 2 digit (NASCO-08) |
|
lab var ownaccountwork Own account worker |
|
lab var reasoninactive Sources of income |
|
lab var secondjob Second job yes/no |
|
lab var sex gender 1=male |
|
lab var size Employed (ILO definition) |
|
lab var sourceofincome Sources of income |
|
lab var totcons Total Expenditures including imputed rents |
|
lab var totconspc Total Expenditures per capita, including imputed rents |
|
lab var unempl Unemployed dummy |
|
lab var unemplduraion time look for work |
|
lab var wageworker wage and salary worker |
|
lab var whynotavailable Out LF reason |
|
order hhid memberno reltohead hhsize weight weight enrolled inactive reasoninactive unemplduraion lfstatILO occup1 activity1 pubempl wageworker familyworker ownaccountwork wageworker district secondjob earning hours morehours empcontrpens age sex educ maritalstat totincpc totinc totincind totconspc totcons mainsource lfstatus unempl firmtype employed imputerent size activity occupation whynotavailable urb |
|
replace educ=2 if educ==1 |
|
replace educ=2 if educationlevel ==1 |
|
replace educ=3 if educationlevel >1 & educationlevel <20 |
|
replace educ=4 if (educationlevel >19 & educationlevel <=30)|educationlevel==99 |
|
replace educ=5 if educationlevel >=31 & educationlevel <40 |
|
replace employed=. if age <12 |
|
replace familyworker=. if employed==0 |
|
replace firmtype=2 if establishmentname==4 |
|
replace firmtype=3 if establishmentname>4&establishmentname~=. |
|
replace lfstatILO=2 if (employed==1 & employmentstatus==1) /*Employer*/ |
|
replace lfstatILO=3 if (employed==1 & employmentstatus==2) /*Own Account Worker*/ |
|
replace lfstatILO=4 if (employed==1 & employmentstatus==6) /*Contributive family worker*/ |
|
replace lfstatILO=5 if (employed==1 & employmentstatus==88) /*members of cooperatives*/ |
|
replace lfstatILO=6 if (employed==1 & lfstatILO==.) /*other*/ |
|
replace lfstatus=. if age <12 |
|
replace lfstatus=1 if (employed==1 & employmentstatus==1) /*employer*/ |
|
replace lfstatus=2 if (employed==1 & employmentstatus==2) /*self employed*/ |
|
replace lfstatus=3 if (employed==1 & (employmentstatus>=3&employmentstatus<10|employmentstatus==.)) /*employee*/ |
|
replace lfstatus=4 if unempl==1 /*unemployed*/ |
|
replace lfstatus=5 if (lfstatus==. & whynotavailable==1|whynotavailable==2) /*Studying/training*/ |
|
replace lfstatus=6 if (lfstatus==. & whynotavailable==3) /*retired*/ |
|
replace lfstatus=7 if (lfstatus==. & whynotavailable==8) /*Household/family*/ |
|
replace lfstatus=8 if (lfstatus==. & whynotavailable==4) /*disables*/ |
|
replace lfstatus=9 if (lfstatus==. ) /*other*/ |
|
replace mainsource = 1 if sourceofincome==9 /*added 12 obs to 1*/ |
|
replace mainsource = 2 if sourceofincome==6 |
|
replace mainsource = 3 if sourceofincome==7 |
|
replace mainsource = 4 if sourceofincome==8 |
|
replace ownaccountwork=. if employed==0 |
|
replace pubempl=. if employed==0 |
|
replace reasoninactive=2 if whynotavailable==8 |
|
replace reasoninactive=3 if whynotavailable==13|whynotavailable==12|whynotavailable==11 |
|
replace reasoninactive=4 if reasoninactive==.&whynotavailable~=. |
|
replace secondjob=. if employed==0 |
|
replace wageworker=. if employed==0 |
|
save adept2012 |
|
set mem 300m |
|
stop |
|
sum poor* [fw=int(weight)] |
|
sum totincpc totconspc |
|
ta establishmentname |
|
ta firmtype |
|
ta mainsource |
|
ta secondjob |
|
ta size |
|
ta sourceofincome |
|
ta whynotavailable |
|
use cps2012 |
|
Warning: these figures indicate the number of cases found in the data file. They cannot be interpreted as summary statistics of the population of interest.