combined_ses_data DDI-MWI-MEIRU-SES-2007-v01b Malawi Epidemiology and Intervention Research Unit Estelle McLean Chifundo Kanjala Jacky Saul Kieth Branson Joseph Kamanga Dominic Nzundah 2020-07-17 Nesstar Publisher version 1 (July, 2020) SES Combined socio-economic data DDI-MWI-MEIRU-SES-2007-v01b Nesstar Publisher Sample Survey Malawi CRS Area in chilumba, Karonga district. Individual Malawi Epidemiology and Intervention Research Unit Face-to-face [f2f] Chilumba Malawi Epidemiology and Intervention Research Unit combined_ses_hh.NSDstat 59259 133 Nesstar 200801 Malawi Epidemiology and Interventions Research Unit combined_ses_ind.NSDstat 499495 36 Nesstar 200801 Malawi Epidemiology and Interventions Research Unit Date of interview (S) 59259 Date of interview Source of data (D) 59259 0 Source of data Variable is created when processing data tables before appending together Reason for filling gh hhold form (S) 16456 42803 1 CRS head change 343 2 CRS location change to different cluster 778 3 TB control 1854 4 Census CRS 8153 5 CRS new household 2512 6 Pre ghhids old data 1418 7 CRS location change within same cluster 154 8 IIS 94 9 Suspect for leprosy/patient 31 10 Rel/hhold of leprosy case 0 11 Smear negative followup 37 12 TB case household 1082 13 Other 0 98 Unknown 0 99 Missing 0 Sysmiss 42803 variable: rsnform (table[s]: css_seh, gp_gphhold) household identifier (D) 59259 0 indicates what household identifier is (D) 59259 0 indicates what household identifier is Number of plots owned and cultivated by this HH (S) 39460 19799 998 Unknown 999 Missing variable: plotsow (table[s]: css_seh, gp_gphhold) Number of plots not owned but cultivated by this HH (S) 38634 20625 Number of plots not owned but cultivated by this HH 998 Unknown 999 Missing variable: plotsrentd (table[s]: css_seh, gp_gphhold) Number of plots owned by this HH but cultivated by other people (S) 36063 23196 998 Unknown 999 Missing variable: plotslet (table[s]: css_seh, gp_gphhold) Number of plots owned by this HH but currently not cultivated (S) 36048 23211 998 Unknown 999 Missing variable: plotsfall (table[s]: css_seh, gp_gphhold) Number of plots (S) 2418 56841 998 Unknown 999 Missing variable: plotsother (table[s]: css_seh, gp_gphhold) Score of number of agriculture plots available to household (D) 39525 19734 egen plottot=rowtotal(plotsow plotsrentd plotslet plotsfall plotsother) replace plottot=. if plotsow==. & plotsrentd==. & plotslet==. & plotsfall==. & plotsother==. foreach var in plot harvest harvsell { foreach y in `yearlist' { /*make relative score by year*/ cap xtile `var'scorey`y'=`var'tot if year==`y', nq(10) /*score is created by splitting the population into deciles*/ if _rc~=0 gen `var'scorey`y'=. } egen `var'score=rowmax(`var'scorey*) drop `var'scorey* }]]> From the last completed cropping season How much maize did you harvest (S) 24884 34375 From the last completed cropping season How much maize did you harvest 9998 Unknown 9999 Missing variable: maizeharv (table[s]: css_seh) From the last completed cropping season How much rice did you harvest (S) 24905 34354 9998 Unknown 9999 Missing variable: riceharv (table[s]: css_seh) From the last completed cropping season How much groundnuts did you harvest (S) 23944 35315 9998 Unknown 9999 Missing variable: gnutharv (table[s]: css_seh) Score of amount of food harvested by household (D) 24912 34347 egen harvesttot=rowtotal(maizeharv riceharv gnutharv) replace harvesttot=. if maizeharv==. & riceharv==. & gnutharv==. foreach var in plot harvest harvsell { foreach y in `yearlist' { /*make relative score by year*/ cap xtile `var'scorey`y'=`var'tot if year==`y', nq(10) /*score is created by splitting the population into deciles*/ if _rc~=0 gen `var'scorey`y'=. } egen `var'score=rowmax(`var'scorey*) drop `var'scorey* }]]> From the last completed cropping season: How much maize did you sell (S) 24883 34376 9998 Unknown 9999 Missing variable: maizesell (table[s]: css_seh) From the last completed cropping season: How much rice did you sell (S) 24872 34387 9998 Unknown 9999 Missing variable: ricesell (table[s]: css_seh) From the last completed cropping season: How much groundnuts did you sell (S) 23860 35399 From the last completed cropping season: How much groundnuts did you sell 9998 Unknown 9999 Missing variable: gnutsell (table[s]: css_seh) Score of percentage of harvest sold by household (D) 22274 36985 egen selltot=rowtotal(maizesell ricesell gnutsell) replace selltot=. if maizesell==. & ricesell==. & gnutsell==. replace selltot=harvesttot if selltot>harvesttot & selltot~=. & harvesttot~=. /*in a few case amount sold is greater than amount harvested*/ gen harvselltot=int(10*(selltot/harvesttot)) if harvesttot>0 & harvesttot~=. & selltot~=. & selltot<=harvesttotforeach var in plot harvest harvsell { foreach y in `yearlist' { /*make relative score by year*/ cap xtile `var'scorey`y'=`var'tot if year==`y', nq(10) /*score is created by splitting the population into deciles*/ if _rc~=0 gen `var'scorey`y'=. } egen `var'score=rowmax(`var'scorey*) drop `var'scorey* }]]> Average of plotscore, harvestscore, harvsellscore (D) 22159 37100 Average of plotscore, harvestscore, harvsellscore Livestock owned now: cattle (D) 40348 18911 0 0 30670 1 1-2 5139 2 3-5 2612 3 6-9 1120 4 >=10 807 8 Unknown 0 9 Missing 0 Sysmiss 18911 Livestock owned now: pigs (S) 16357 42902 Livestock owned now: pigs 0 0 10607 1 1-2 3842 2 3-5 1269 3 6-9 487 4 >=10 152 8 Unknown 0 9 Missing 0 Sysmiss 42902 variable: pigown (table[s]: css_seh) Livestock owned now: sheep (S) 16357 42902 0 0 16271 1 1-2 58 2 3-5 18 3 6-9 5 4 >=10 5 8 Unknown 0 9 Missing 0 Sysmiss 42902 variable: sheepown (table[s]: css_seh) Livestock owned now: chickens (S) 16349 42910 Livestock owned now: chickens 0 0 4433 1 1-2 2807 2 3-5 3662 3 6-9 2338 4 >=10 3109 8 Unknown 0 9 Missing 0 Sysmiss 42910 variable: chickown (table[s]: css_seh) Livestock owned now: ducks (S) 16357 42902 0 0 14435 1 1-2 770 2 3-5 670 3 6-9 315 4 >=10 167 8 Unknown 0 9 Missing 0 Sysmiss 42902 variable: duckown (table[s]: css_seh) Livestock owned now: doves (S) 16357 42902 Livestock owned now: doves 0 0 13746 1 1-2 227 2 3-5 448 3 6-9 769 4 >=10 1167 8 Unknown 0 9 Missing 0 Sysmiss 42902 variable: dovesown (table[s]: css_seh) Score of amount of livestock (NOT cattle) owned by HH (D) 16357 42902 Score of amount of livestock (NOT cattle) owned by HH *(the values for each animal are the middle of the range of typical prices given by the crs fieldworkers on 22 August 2014, the range is given in the comments afterwards.) local cattleval=150000 /*100,000-200,000*/ local pigval=30000 /*5000-50,000*/ local chickval=2500 /*2000-3000*/ local goatval=16000 /*9000-25000*/ local duckval=2500 /*2000-3000*/ local sheepval=25000 /*20,000-30,000*/ local dovesval=450 /*400-500*/ egen livesvars=rownonmiss(pigown chickown duckown sheepown dovesown) gen livestotposs=0 if livesvars>0 foreach lives in pig chick duck sheep doves { /*loop through all the livestock excluding cattle*/ recode `lives'own 2=3 3=6 4=10 //recode so value reflects the number owned replace livestotposs=livestotposs+(10*``lives'val') if `lives'own~=. gen `lives'val=`lives'own*``lives'val' recode `lives'own 3=2 6=3 10=4 //recode back to match the label } egen livesval=rowtotal(*val) if livestotposs~=. gen livesscore1=(10*(livesval/livestotposs)) xtile livesscore=livesscore1, nq(10) /*score is created by splitting the population into deciles*/]]> In house owned or rented (S) 39972 19287 1 Owned 33279 2 Rented 3846 3 Other 2847 8 Unknown 0 9 Missing 0 Sysmiss 19287 No. of rooms (S) 44203 15056 98 Unknown 99 Missing Type of construction of best dwelling in household: walls (S) 41713 17546 Type of construction of best dwelling in household: walls 0 Other 82 1 Burnt brick 28034 2 Unburnt brick 2875 3 Pounded thick mud 2525 4 Plastered thin mud 7296 5 Bamboo 623 6 Grass or no walls 129 7 Iron sheets 45 8 Concrete blocks 102 9 other 2 98 Unknown 0 99 Missing 0 Sysmiss 17546 variable: walls (table[s]: css_seh, gp_gphhold) Type of construction of best dwelling in household: roof (S) 41674 17585 Type of construction of best dwelling in household: roof 0 25 1 Grass or leaves 14610 2 Corrugated iron 0 3 Grass and iron sheets 146 4 No roof 0 5 Others 0 6 Grass+plastic sheet 12777 7 Iron sheets or tiles 14116 8 Unknown 0 9 Missing 0 Sysmiss 17585 variable: roof (table[s]: css_seh, gp_gphhold) Type of construction of best dwelling in household: floor (S) 41500 17759 1 Mud 31471 2 Concrete 9979 3 Other 40 4 Tiles 10 8 Unknown 0 9 Missing 0 Sysmiss 17759 variable: floor (table[s]: css_seh, gp_gphhold) Type of construction of best dwelling in household: glass windows (S) 30792 28467 0 No 27425 1 Yes 3367 8 Unknown 0 9 Missing 0 Sysmiss 28467 variable: glasswind (table[s]: css_seh, gp_gphhold) Score of quality of house - based on roof, walls, floor & windows (D) 41398 17861 *roof (2 ranks: 1=plastic sheets & grass+leaves 2=iron sheets) gen roofrank=1 if roof==1 | roof==6 /*1=grass/leaves, 6=grass+plastic sheet*/ replace roofrank=2 if roof==7 | roof==3 /*7=iron sheet/tiles, 3=grass+iron sheets*/ *Walls (4 ranks : 1=other 2=pounded thick mud 3=unburnt bricks 4=concrete & burnt bricks) *(1="burnt brick" 2="unburnt brick" 3="pounded thick mud" 4="plastered thin mud" 5="bamboo" 6="grass or no wall" 7="iron sheets" 8="concrete blocks" 0="other" gen wallrank=walls recode wallrank 1=4 2=3 3=2 4=2 5=1 6=1 7=1 8=4 0=1 9=1 *floor (2 ranks: 1=mud & other 2=concrete) gen floorrank=1 if floor==1 | floor==3 /*1=mud, 3=other*/ replace floorrank=2 if floor==2 /*2=concrete*/ *generate dwelling rank gen dwellscore1=real(string(roofrank)+string(floorrank)+string(wallrank)) if roofrank!=. & wallrank!=. & floorrank!=. recode dwellscore1 111/112=1 113/114=2 121/122=3 123/124=4 211/212=5 213/214=6 221/222=7 223/224=8 replace dwellscore1=dwellscore1+1 if glasswin==1 foreach y in `yearlist' { /*make relative dwellscore by year - so houses only compared with houses from same era*/ cap xtile dwellscorey`y'=dwellscore1 if year==`y', nq(10) /*score is created by splitting the population into deciles*/ if _rc~=0 gen dwellscorey`y'=. } egen dwellscore=rowmax(dwellscorey*)]]> Type of latrine used by the household (S) 34043 25216 0 None 4399 1 Simple pit latrine 28832 2 VIP 228 3 Water toilet 584 8 Unknown 0 9 Missing 0 Sysmiss 25216 Whether house has electricity (S) 42121 17138 Whether house has electricity rename (electric water) (electric2 water1) gen electric=1 if electric2==1 /*Escom*/| electric2==2 /*solar*/ gen electric=0 replace electric=1 if felect==1 | elec==1]]> Type of electricity (D) 16325 42934 Type of electricity 0 None 14859 1 Escom 817 2 Solar 649 8 Unknown 0 9 Missing 0 Sysmiss 42934 variable: electric (table[s]: css_seh) Main source of water used by the household. (S) 37774 21485 Main source of water used by the household. 1 Tap to house 6434 2 Shared communal tap 4499 3 Bore hole 19253 4 Covered well 4139 5 Open well 2100 6 Lake/river 1338 7 Other 11 8 Unknown 0 9 Missing 0 Sysmiss 21485 water1=1 if wtap==1 replace water1=2 if wctap==1 & water1==. replace water1=3 if wbore==1 & water1==. replace water1=4 if wcwell==1 & water1==. replace water1=5 if wowell==1 & water1==. replace water1=6 if wlake==1 & water1==.]]> Main source of water used by the household (D) 49164 10095 1 Tap to house 7490 2 Shared communal tap 5889 3 Bore hole 25745 4 Lake/river/well 10040 8 Unknown 0 9 Missing 0 Sysmiss 10095 recode water1 4/max=4, gen(water2) gen water2=1 if wtap==1 replace water2=2 if wctap==1 & water2==. replace water2=3 if wbore==1 & water2==. replace water2=4 if (wlake==1 | wcwell==1 | wowell==1) & water2==.]]> How does this HH bring in income? through regular employment (S) 36098 23161 0 No 30676 1 Yes 5422 8 Unknown 0 9 Missing 0 Sysmiss 23161 variable: employ (table[s]: css_seh, gp_gphhold) rank of income through regular employment (salary/wage) (S) 5408 53851 98 Unknown 99 Missing variable: employo (table[s]: css_seh, gp_gphhold) How does this HH bring in income? through casual employment/piecework (S) 36193 23066 How does this HH bring in income? through casual employment/piecework 0 No 25491 1 Yes 10702 8 Unknown 0 9 Missing 0 Sysmiss 23066 variable: piecew (table[s]: css_seh, gp_gphhold) rank of income through casual employment / piecework (S) 10678 48581 98 Unknown 99 Missing variable: piecewo (table[s]: css_seh, gp_gphhold) 36536 22723 0 No 11193 1 Yes 25343 8 Unknown 0 9 Missing 0 Sysmiss 22723 variable: farm (table[s]: css_seh, gp_gphhold) rank of income selling own agricultural produce (crops and livestock) (S) 25270 33989 rank of income selling own agricultural produce (crops and livestock) 98 Unknown 99 Missing variable: farmo (table[s]: css_seh, gp_gphhold) How does this HH bring in income? selling own fish (S) 36190 23069 How does this HH bring in income? selling own fish 0 No 31177 1 Yes 5013 8 Unknown 0 9 Missing 0 Sysmiss 23069 variable: fish (table[s]: css_seh, gp_gphhold) rank of income selling own fish (locally or with transport?) (S) 4999 54260 rank of income selling own fish (locally or with transport?) 98 Unknown 99 Missing variable: fisho (table[s]: css_seh, gp_gphhold) How does this HH bring in income? Preparing & selling food or beverages (S) 36221 23038 0 No 32730 1 Yes 3491 8 Unknown 0 9 Missing 0 Sysmiss 23038 variable: snacks (table[s]: css_seh, gp_gphhold) rank of income Preparing & selling food or beverages (S) 3471 55788 98 Unknown 99 Missing variable: snackso (table[s]: css_seh, gp_gphhold) How does this household bring in income? selling own manufactured goods (S) 36268 22991 0 No 33612 1 Yes 2656 8 Unknown 0 9 Missing 0 Sysmiss 22991 variable: manuf (table[s]: css_seh, gp_gphhold) rank of income selling own manufactured goods (S) 2647 56612 98 Unknown 99 Missing variable: manufo (table[s]: css_seh, gp_gphhold) 36260 22999 How does this HH bring in income? buying & selling other peoples product 0 No 25968 1 Yes 10292 8 Unknown 0 9 Missing 0 Sysmiss 22999 variable: trade (table[s]: css_seh, gp_gphhold) rank of income buying & selling other peoples product (S) 10253 49006 98 Unknown 99 Missing variable: tradeo (table[s]: css_seh, gp_gphhold) How does this HH bring in income? Gathering natural products (S) 34544 24715 0 No 32334 1 Yes 2210 8 Unknown 0 9 Missing 0 Sysmiss 24715 variable: gather (table[s]: css_seh, gp_gphhold) rank of income Gathering natural products (grass, wood,…) (S) 2204 57055 98 Unknown 99 Missing variable: gathero (table[s]: css_seh, gp_gphhold) How does this HH bring in income? letting of property/ land/ houses/ oxcarts (S) 36192 23067 How does this HH bring in income? letting of property/ land/ houses/ oxcarts 0 No 34153 1 Yes 2039 8 Unknown 0 9 Missing 0 Sysmiss 23067 variable: letting (table[s]: css_seh, gp_gphhold) rank of income letting of property/ land/ houses/ oxcarts (S) 2033 57226 rank of income letting of property/ land/ houses/ oxcarts 98 Unknown 99 Missing variable: lettingo (table[s]: css_seh, gp_gphhold) 36199 23060 0 No 32842 1 Yes 3357 8 Unknown 0 9 Missing 0 Sysmiss 23060 variable: service (table[s]: css_seh, gp_gphhold) rank of income providing a service (S) 3354 55905 98 Unknown 99 Missing variable: serviceo (table[s]: css_seh, gp_gphhold) 25218 34041 How does this household bring in income? from outside relatives) 0 No 19250 1 Yes 5968 8 Unknown 0 9 Missing 0 Sysmiss 34041 variable: supportf (table[s]: css_seh, gp_gphhold) rank of income from outside relatives (S) 5964 53295 98 Unknown 99 Missing variable: supportfo (table[s]: css_seh, gp_gphhold) 36215 23044 0 No 33629 1 Yes 2586 8 Unknown 0 9 Missing 0 Sysmiss 23044 variable: support (table[s]: css_seh, gp_gphhold) rank of income from outside organisation or non-relative (S) 2554 56705 98 Unknown 99 Missing variable: supporto (table[s]: css_seh, gp_gphhold) 36116 23143 0 No 35586 1 Yes 530 8 Unknown 0 9 Missing 0 Sysmiss 23143 variable: othinc (table[s]: css_seh, gp_gphhold) rank of income Unclassifiable (S) 528 58731 variable: othinco (table[s]: css_seh, gp_gphhold) Employment status of head of household (S) 1990 57269 0 Not applicable 0 11 Full-time educaton 1 12 Unable to work 15 13 Retired 10 14 Looking for work 0 19 Other 0 20 Housework 0 30 Employer no sub-category 0 31 Runs own business 6 33 ???? 0 41 In cash economy 194 42 Subsistence economy 1603 49 Own account don't know payment 0 51 Salary (monthly) 136 52 Wage (weekly) 7 53 Casual or piecework 15 54 Unpaid worker 2 59 Employee don't know payment 0 99 No information 1 998 Unknown 0 999 Missing 0 Sysmiss 57269 variable: emphead (table[s]: css_seh, gp_gphhold) First source of income (D) 36554 22705 1 regular employment 4730 2 piecework 3601 3 farming 16383 4 fishing 2636 5 selling prepared food 943 6 manufactoring goods 827 7 trading 3423 8 gathering natural products 219 9 letting property 389 10 providing a service 1125 11 support from relatives 1570 12 support from non-relative 513 13 other 195 Sysmiss 22705 forvalues y=1/4 { /*loop to create the variables*/ gen inc`y'hh=. } local x=1 /*start a local of x which will be 1 to start the loop at employ, then increased to 2 for piecew etc*/ foreach var in employ piecew farm fish snacks manuf trade gather letting service supportf support othinc { /*these vars are yes/no of whether they are a source of income and the var with o after (e.g. employo) is the rank of order of importance, with no duplication so only one has rank 1 for each record*/ recode `var'o 0=. /*apparently 00 in rank var is code for missing*/ forvalues y=1/4 { /*loop through 1-4 to capture the top 4 most important into the variables created above*/ replace inc`y'hh=`x' if `var'o==`y' /*x is 1 for employ, 2 for piecework etc. so inc1 is 1 if employ==1, inc3 is 4 if fish==3 etc.*/ } local x=`x'+1 /*add 1 to the local x before going through the foreach var loop again*/ } la def activity 1 "regular employment" 2 "piecework" 3 "farming" 4 "fishing" 5 "selling prepared food" 6 "manufactoring goods" 7 "trading" 8 "gathering natural products" 9 "letting property" 10 "providing a service" 11 "support from relatives" 12 "support from non-relative" 13 "other" la val inc1hh inc2hh inc3hh inc4hh activity gen tag=1 if inc1==. forvalues a=1/3 { /*if no income source 1 reported move all the sources up one*/ local b=`a'+1 replace inc`a'hh=inc`b'hh if tag==1 }]]> Second source of income (D) 27287 31972 1 regular employment 519 2 piecework 4685 3 farming 6909 4 fishing 1629 5 selling prepared food 1384 6 manufactoring goods 1050 7 trading 4673 8 gathering natural products 735 9 letting property 867 10 providing a service 1361 11 support from relatives 2339 12 support from non-relative 940 13 other 196 Sysmiss 31972 forvalues y=1/4 { /*loop to create the variables*/ gen inc`y'hh=. } local x=1 /*start a local of x which will be 1 to start the loop at employ, then increased to 2 for piecew etc*/ foreach var in employ piecew farm fish snacks manuf trade gather letting service supportf support othinc { /*these vars are yes/no of whether they are a source of income and the var with o after (e.g. employo) is the rank of order of importance, with no duplication so only one has rank 1 for each record*/ recode `var'o 0=. /*apparently 00 in rank var is code for missing*/ forvalues y=1/4 { /*loop through 1-4 to capture the top 4 most important into the variables created above*/ replace inc`y'hh=`x' if `var'o==`y' /*x is 1 for employ, 2 for piecework etc. so inc1 is 1 if employ==1, inc3 is 4 if fish==3 etc.*/ } local x=`x'+1 /*add 1 to the local x before going through the foreach var loop again*/ } la def activity 1 "regular employment" 2 "piecework" 3 "farming" 4 "fishing" 5 "selling prepared food" 6 "manufactoring goods" 7 "trading" 8 "gathering natural products" 9 "letting property" 10 "providing a service" 11 "support from relatives" 12 "support from non-relative" 13 "other" la val inc1hh inc2hh inc3hh inc4hh activity gen tag=1 if inc1==. forvalues a=1/3 { /*if no income source 1 reported move all the sources up one*/ local b=`a'+1 replace inc`a'hh=inc`b'hh if tag==1 }]]> Third source of income (D) 11453 47806 1 regular employment 117 2 piecework 1858 3 farming 1656 4 fishing 566 5 selling prepared food 798 6 manufactoring goods 522 7 trading 1755 8 gathering natural products 761 9 letting property 527 10 providing a service 628 11 support from relatives 1472 12 support from non-relative 706 13 other 87 Sysmiss 47806 forvalues y=1/4 { /*loop to create the variables*/ gen inc`y'hh=. } local x=1 /*start a local of x which will be 1 to start the loop at employ, then increased to 2 for piecew etc*/ foreach var in employ piecew farm fish snacks manuf trade gather letting service supportf support othinc { /*these vars are yes/no of whether they are a source of income and the var with o after (e.g. employo) is the rank of order of importance, with no duplication so only one has rank 1 for each record*/ recode `var'o 0=. /*apparently 00 in rank var is code for missing*/ forvalues y=1/4 { /*loop through 1-4 to capture the top 4 most important into the variables created above*/ replace inc`y'hh=`x' if `var'o==`y' /*x is 1 for employ, 2 for piecework etc. so inc1 is 1 if employ==1, inc3 is 4 if fish==3 etc.*/ } local x=`x'+1 /*add 1 to the local x before going through the foreach var loop again*/ } la def activity 1 "regular employment" 2 "piecework" 3 "farming" 4 "fishing" 5 "selling prepared food" 6 "manufactoring goods" 7 "trading" 8 "gathering natural products" 9 "letting property" 10 "providing a service" 11 "support from relatives" 12 "support from non-relative" 13 "other" la val inc1hh inc2hh inc3hh inc4hh activity gen tag=1 if inc1==. forvalues a=1/3 { /*if no income source 1 reported move all the sources up one*/ local b=`a'+1 replace inc`a'hh=inc`b'hh if tag==1 }]]> Fourth source of income (D) 3139 56120 1 regular employment 28 2 piecework 438 3 farming 262 4 fishing 135 5 selling prepared food 253 6 manufactoring goods 179 7 trading 332 8 gathering natural products 353 9 letting property 200 10 providing a service 176 11 support from relatives 457 12 support from non-relative 291 13 other 35 Sysmiss 56120 forvalues y=1/4 { /*loop to create the variables*/ gen inc`y'hh=. } local x=1 /*start a local of x which will be 1 to start the loop at employ, then increased to 2 for piecew etc*/ foreach var in employ piecew farm fish snacks manuf trade gather letting service supportf support othinc { /*these vars are yes/no of whether they are a source of income and the var with o after (e.g. employo) is the rank of order of importance, with no duplication so only one has rank 1 for each record*/ recode `var'o 0=. /*apparently 00 in rank var is code for missing*/ forvalues y=1/4 { /*loop through 1-4 to capture the top 4 most important into the variables created above*/ replace inc`y'hh=`x' if `var'o==`y' /*x is 1 for employ, 2 for piecework etc. so inc1 is 1 if employ==1, inc3 is 4 if fish==3 etc.*/ } local x=`x'+1 /*add 1 to the local x before going through the foreach var loop again*/ } la def activity 1 "regular employment" 2 "piecework" 3 "farming" 4 "fishing" 5 "selling prepared food" 6 "manufactoring goods" 7 "trading" 8 "gathering natural products" 9 "letting property" 10 "providing a service" 11 "support from relatives" 12 "support from non-relative" 13 "other" la val inc1hh inc2hh inc3hh inc4hh activity gen tag=1 if inc1==. forvalues a=1/3 { /*if no income source 1 reported move all the sources up one*/ local b=`a'+1 replace inc`a'hh=inc`b'hh if tag==1 }]]> Score of first source of income in the household (D) 38515 20744 Score of top 4 sources of income in the household (D) 38515 20744 3 & incscorehh~=.]]> Actual total monthly income reported by household (D) 7658 51601 Actual total monthly income reported by household Score of total monthly income reported by household (D) 7658 51601 variable: tothhincome (table[s]: NCD_combined_data_all_final [derived table]) No. of potential male earners missed in the calculation of total hh income (D) 7658 51601 variable: avhhincscorek (table[s]: NCD_combined_data_all_final [derived table]) No. of potential female earners missed in the calculation of total hh income (D) 7658 51601 variable: mmissed (table[s]: NCD_combined_data_all_final [derived table]) Number of meals served in household in previous 2 days (S) 23016 36243 98 Unknown 99 Missing variable: meals2days (table[s]: css_seh) Number of meals normally served in household per day (S) 23007 36252 Number of meals normally served in household per day 98 Unknown 99 Missing variable: mealsnorm (table[s]: css_seh) In the last 7 days: number of days tomatoes eaten in household (S) 20900 38359 98 Unknown 99 Missing variable: tomnum (table[s]: css_seh) In the last 7 days: number of days vegetables eaten in household (S) 22413 36846 98 Unknown 99 Missing variable: vegnum (table[s]: css_seh) In the last 7 days was fish eaten in the household (S) 22991 36268 In the last 7 days was fish eaten in the household 0 No 772 1 Yes 22219 8 Unknown 0 9 Missing 0 Sysmiss 36268 variable: fishyn (table[s]: css_seh) In the last 14 days, was chicken served in a main meal eaten by the HH? (S) 23006 36253 In the last 14 days, was chicken served in a main meal eaten by the HH? 0 No 14238 1 Yes 8768 8 Unknown 0 9 Missing 0 Sysmiss 36253 variable: chicken (table[s]: css_seh) In the last 14 days, was beef/goat/pork served in a main meal eaten by the HH? ( 23014 36245 In the last 14 days, was beef/goat/pork served in a main meal eaten by the HH? 0 No 6973 1 Yes 16041 8 Unknown 0 9 Missing 0 Sysmiss 36245 variable: meat (table[s]: css_seh) In the last 14 days, was beans/peas/etc served in a main meal eaten by the HH? ( 23008 36251 In the last 14 days, was beans/peas/etc served in a main meal eaten by the HH? 0 No 4994 1 Yes 18014 8 Unknown 0 9 Missing 0 Sysmiss 36251 variable: beans (table[s]: css_seh) In the last 14 days, was eggs served in a main meal eaten by the HH? (S) 23000 36259 In the last 14 days, was eggs served in a main meal eaten by the HH? 0 No 11966 1 Yes 11034 8 Unknown 0 9 Missing 0 Sysmiss 36259 variable: eggs (table[s]: css_seh) In the last 14 days, was milk served in a main meal eaten by the HH? (S) 22987 36272 In the last 14 days, was milk served in a main meal eaten by the HH? 0 No 12512 1 Yes 10475 8 Unknown 0 9 Missing 0 Sysmiss 36272 variable: milk (table[s]: css_seh) Time in last year where there has not been enough food in the household. (S) 29980 29279 Time in last year where there has not been enough food in the household. 0 No 21411 1 Yes 8569 8 Unknown 0 9 Missing 0 Sysmiss 29279 Score of amount and type of food available in the household. (D) 23037 36222 Score of amount and type of food available in the household. egen meals2days_cat=cut(meals2days), at(0,1,4,6,99) /*number of meals served in last 2 days categorised into 0, 1-3, 4-5 and 6+*/ recode meals2days_cat 4=2 6=3 egen mealsnorm_cat=cut(mealsnorm), at(0,1,2,3,99) /*number of meals normally served daily categorised into 0, 1, 2 and 3+*/ egen vegetable=rowtotal(tomnum vegnum) replace vegetable=. if tomnum==. & vegnum==. egen veg_cat=cut(vegetable), at(0,2,6,10,15) /*number of days tomatoes and veg served in last 7 days categorised into 0-1, 2-5, 6-9 and 10+*/ recode veg_cat 2=1 6=2 10=3 egen protein=rowtotal(fishyn chicken meat beans eggs milk) replace protein=. if fishyn==. & chicken==. & meat==. & beans==. & eggs==. & milk==. recode protein 2=1 3/4=2 5/6=3, gen(prot_cat) egen diettot=rowtotal(meals2days_cat mealsnorm_cat veg_cat prot_cat) replace diettot=. if meals2days_cat==. & mealsnorm_cat==. & veg_cat==. & prot_cat==. replace diettot=diettot-1 if foodenough==1 /*minus 1 from dietscore if reported time with not enough food in last year*/ egen dietposs=rownonmiss(meals2days_cat mealsnorm_cat veg_cat prot_cat) gen dietscore1=diettot/(dietposs*3) /*average of all possible diet scores*/ foreach y in `yearlist' { /*make relative dietscore by year - so diets only compared with diets from same era*/ cap xtile dietscorey`y'=dietscore1 if year==`y', nq(10) /*score is created by splitting the population into deciles*/ if _rc~=0 gen dietscorey`y'=. } egen dietscore=rowmax(dietscorey*)]]> Time in last 4 weeks when there was not enough money to buy soap for HH (S) 25192 34067 Time in last 4 weeks when there was not enough money to buy soap for HH 0 No 17231 1 Yes 7961 8 Unknown 0 9 Missing 0 Sysmiss 34067 variable: soap4wk (table[s]: css_seh) Time in last year when there was not enough money to buy soap for HH (S) 28942 30317 Time in last year when there was not enough money to buy soap for HH 0 No 16043 1 Yes 12899 8 Unknown 0 9 Missing 0 Sysmiss 30317 36280 22979 Whether household receives external monetary support 0 No 27796 1 Yes 8484 8 Unknown 0 9 Missing 0 Sysmiss 22979 gen anysupport=. replace anysupport=0 if supportf==0 | support==0 replace anysupport=1 if supportf==1 | support==1]]> In last year, did anyone in this HH receive any gifts from outside the HH? (S) 7206 52053 In last year, did anyone in this HH receive any gifts from outside the HH? 0 No 3887 1 Yes 3319 8 Unknown 0 9 Missing 0 Sysmiss 52053 variable: giftreceive (table[s]: css_seh) In last year, did anyone in this HH receive any loans from outside the HH? (S) 7159 52100 In last year, did anyone in this HH receive any loans from outside the HH? 0 No 5847 1 Yes 1312 8 Unknown 0 9 Missing 0 Sysmiss 52100 variable: loanreceive (table[s]: css_seh) In last year, did anyone in this HH give any gifts from outside the HH? (S) 7180 52079 In last year, did anyone in this HH give any gifts from outside the HH? 0 No 4414 1 Yes 2766 8 Unknown 0 9 Missing 0 Sysmiss 52079 variable: giftgive (table[s]: css_seh) In last year, did anyone in this HH give any loans from outside the HH? (S) 7082 52177 In last year, did anyone in this HH give any loans from outside the HH? 0 No 5731 1 Yes 1351 8 Unknown 0 9 Missing 0 Sysmiss 52177 variable: loangive (table[s]: css_seh) In last year, has anyone in this HH RECEIVED any loans from a bank etc? (S) 7211 52048 In last year, has anyone in this HH RECEIVED any loans from a bank etc? 0 No 6607 1 Yes 604 8 Unknown 0 9 Missing 0 Sysmiss 52048 variable: newloan (table[s]: css_seh) Does anyone in this household belong to a savings group or club? (S) 7217 52042 Does anyone in this household belong to a savings group or club? 0 No 6320 1 Yes 897 8 Unknown 0 9 Missing 0 Sysmiss 52042 variable: savinggp (table[s]: css_seh) Does anyone in this HH currently have any cash savings for the future? (S) 7199 52060 Does anyone in this HH currently have any cash savings for the future? 0 No 4576 1 Yes 2623 8 Unknown 0 9 Missing 0 Sysmiss 52060 variable: savings (table[s]: css_seh) Score of savings/safety nets available to household (D) 7244 52015 Score of savings/safety nets available to household Anyone in household own bank book (S) 37494 21765 Anyone in household own bank book 0 No 30373 1 Yes 7121 8 Unknown 0 9 Missing 0 Sysmiss 21765 15962 43297 0 No 4042 1 Yes 11920 8 Unknown 0 9 Missing 0 Sysmiss 43297 variable: panga (table[s]: css_seh) Anyone in household own a hoe (S) 15039 44220 Anyone in household own a hoe 0 No 595 1 Yes 14444 8 Unknown 0 9 Missing 0 Sysmiss 44220 variable: hoe (table[s]: css_seh) Anyone in household own an axe (S) 15953 43306 Anyone in household own an axe 0 No 2301 1 Yes 13652 8 Unknown 0 9 Missing 0 Sysmiss 43306 variable: axe (table[s]: css_seh) 15934 43325 0 No 14434 1 Yes 1500 8 Unknown 0 9 Missing 0 Sysmiss 43325 variable: plough (table[s]: css_seh) Anyone in household own a plough (S) 29269 29990 Anyone in household own a plough 0 No 26059 1 Yes 3210 8 Unknown 0 9 Missing 0 Sysmiss 29990 variable: fishnet (table[s]: css_seh, gp_gphhold) Anyone in household own a wheelbarrow (S) 15843 43416 Anyone in household own a wheelbarrow 0 No 14697 1 Yes 1146 8 Unknown 0 9 Missing 0 Sysmiss 43416 variable: wheelb (table[s]: css_seh) Anyone in household own an oxcart (S) 45188 14071 Anyone in household own an oxcart 0 No 42993 1 Yes 2195 8 Unknown 0 9 Missing 0 Sysmiss 14071 Anyone in household own a working watch or clock (S) 37533 21726 Anyone in household own a working watch or clock 0 No 22762 1 Yes 14771 8 Unknown 0 9 Missing 0 Sysmiss 21726 Anyone in household own a mattress (S) 28809 30450 0 No 9248 1 Yes 19561 8 Unknown 0 9 Missing 0 Sysmiss 30450 Anyone in household own a bed (S) 28810 30449 Anyone in household own a bed 0 No 5863 1 Yes 22947 8 Unknown 0 9 Missing 0 Sysmiss 30449 Anyone in household own Plastic, metal, wooden chairs (S) 23585 35674 0 No 9053 1 Yes 14532 8 Unknown 0 9 Missing 0 Sysmiss 35674 Anyone in household own a table (S) 23590 35669 Anyone in household own a table 0 No 9535 1 Yes 14055 8 Unknown 0 9 Missing 0 Sysmiss 35669 Anyone in household own a sofa (S) 9490 49769 0 No 7805 1 Yes 1685 8 Unknown 0 9 Missing 0 Sysmiss 49769 variable: sofa_mode (table[s]: NCD_combined_data_all_final [derived table]) Anyone in household own a mosquito net (S) 47703 11556 0 No 4004 1 Yes 43699 8 Unknown 0 9 Missing 0 Sysmiss 11556 Number of mosquito nets owned by household (S) 38675 20584 98 Unknown 99 Missing Anyone in household own a Clay pot for storing drinking water (S) 15929 43330 0 No 3080 1 Yes 12849 8 Unknown 0 9 Missing 0 Sysmiss 43330 variable: pot (table[s]: css_seh) Anyone in household own a charcoal iron (S) 21153 38106 0 No 14657 1 Yes 6496 8 Unknown 0 9 Missing 0 Sysmiss 38106 Anyone in household own a bicycle (S) 45188 14071 0 No 23101 1 Yes 22087 8 Unknown 0 9 Missing 0 Sysmiss 14071 Anyone in household own a canoe (S) 37526 21733 0 No 34820 1 Yes 2706 8 Unknown 0 9 Missing 0 Sysmiss 21733 variable: canoe (table[s]: css_seh, caps_blhse, gp_gphhold) Anyone in household own a working sewing machine (S) 21150 38109 0 No 20417 1 Yes 733 8 Unknown 0 9 Missing 0 Sysmiss 38109 variable: sewing (table[s]: css_seh, caps_blhse) Anyone in household own a paraffin lamp (S) 9491 49768 0 No 6201 1 Yes 3290 8 Unknown 0 9 Missing 0 Sysmiss 49768 variable: parlamp_mode (table[s]: NCD_combined_data_all_final [derived table]) 2503 56756 0 No 1014 1 Yes 1489 8 Unknown 0 9 Missing 0 Sysmiss 56756 variable: tape (table[s]: css_seh) Anyone in household own an electric fan (S) 2491 56768 0 No 2116 1 Yes 375 8 Unknown 0 9 Missing 0 Sysmiss 56768 variable: fan (table[s]: css_seh) Anyone in household own a fridge (S) 10151 49108 0 No 9353 1 Yes 798 8 Unknown 0 9 Missing 0 Sysmiss 49108 Anyone in household own an electric iron (S) 2491 56768 0 No 1988 1 Yes 503 8 Unknown 0 9 Missing 0 Sysmiss 56768 variable: eiron (table[s]: css_seh) Anyone in household own a tv (S) 10151 49108 0 No 8575 1 Yes 1576 8 Unknown 0 9 Missing 0 Sysmiss 49108 Anyone in household own a mobile phone (S) 7658 51601 0 No 2906 1 Yes 4752 8 Unknown 0 9 Missing 0 Sysmiss 51601 variable: mopho_mode (table[s]: NCD_combined_data_all_final [derived table]) Anyone in household own a land phone (S) 7658 51601 0 No 7543 1 Yes 115 8 Unknown 0 9 Missing 0 Sysmiss 51601 variable: landpho_mode (table[s]: NCD_combined_data_all_final [derived table]) Anyone in household own a radio (S) 45188 14071 Anyone in household own a radio 0 No 19251 1 Yes 25937 8 Unknown 0 9 Missing 0 Sysmiss 14071 Anyone in household own an electric or gas cooker (S) 12470 46789 Anyone in household own an electric or gas cooker Anyone in household own a car (S) 28803 30456 Anyone in household own a car 0 No 28554 1 Yes 249 8 Unknown 0 9 Missing 0 Sysmiss 30456 Anyone in household own a motorbike (S) 45182 14077 Anyone in household own a motorbike 0 No 44820 1 Yes 362 8 Unknown 0 9 Missing 0 Sysmiss 14077 Score of possesions owned (D) 45200 14059 Score of possesions owned *(the values for each item are (usually) the middle of the range of typical prices given by the crs fieldworkers on 22 August 2014, the range is given in the comments afterwards.) *(the second comment, if present, is the price in the original do-file from may 2005) local pangaval=1500 /*1000-3000*/ local axeval=1500 /*1000-2000*/ local cironval=1500 /*1000-2000*/ local parlampval=2000 /*1500-2500*/ local hoeval=2500 /*1500-3500*/ local clockval=3500 /*1500-5000*/ /*2005: 150*/ local mosnetynval=4500 /*3500-5000*/ /*2005: 100*/ local potval=6000 /*2000-10,000*/ local chairval=6500 /*2500-10,000*/ local eironval=7500 /*5000-10,000*/ local radioval=8000 /*1000-15,000*/ /*2005: 600*/ local mobileval=10000 /*3000-60,000*/ local landphoval=15000 /*10,000-20,000*/ local fanval=22500 /*15,000-30,000*/ local tbleval=25000 /*15,000-25,000*/ local wheelbval=30000 /*20,000-40,000*/ local mattressval=31000 /*12,000-50,000*/ local bedval=32500 /*15,000-50,000*/ local tapeval=32500 /*15,000-50,000*/ local bicycleval=35000 /*20,000-50,000*/ /*2005: 4000*/ local sewingval=35000 /*20,000-50,000*/ local canoeval=50000 /*40,000-60,000*/ /*2005: 4000*/ local fishnetval=60000 /*20,000-100,000*/ /*2005: 4000*/ local ploughval=75000 /*50,000-100,000*/ local tvval=85000 /*70,000-100,000*/ local egcookval=100000 /*80,000-120,000*/ local sofaval=125000 /*50,000-200,000*/ local oxcartval=200000 /*180,000-220,000*/ /*2005: 25000*/ local fridgeval=200000 /*150,000-250,000*/ local motorbikeval=350000 /*200,000-500,000*/ /*2005: 60000*/ local carval=2000000 /*1,000,000-3,000,000*/ *divide the possessions into cheap (under 10,000K), middle (10,000-under 100,000K) and expensive (over 100,000K) local posscheap "panga axe ciron parlamp hoe clock pot chair eiron radio" local possmid "mobile landpho fan tble wheelb mattress bed tape bicycle sewing canoe fishnet plough tv" local possexp "egcook sofa oxcart fridge motorbike car" foreach poss in cheap mid exp { local possessions="`poss`poss''" egen nask`poss'=rownonmiss(`poss`poss'') egen nyes`poss'=rowtotal(`poss`poss'') if "`poss'"=="mid" replace nask`poss'=nask`poss'-1 gen poss`poss'poss=0 if nask`poss'>=2 /*only use data if at least 2 of the items were asked about*/ foreach item of local possessions { /*loop through the items listed above in local possessions*/ replace poss`poss'poss=poss`poss'poss+``item'val' if `item'~=. & nask`poss'>=2 /*if the possession variable is not missing they have been asked about it so its value can be added to the total possible they could have*/ gen `item'val=`item'*``item'val' /*if they have the item its var will equal 1 (0 if no and . if unknown) so this create a var with the value of the item if they have it*/ } replace poss`poss'poss=. if poss`poss'poss==0 /*replace total possible score with missing if none of the questions asked*/ egen poss`poss'=rowtotal(*val) if poss`poss'poss>0 & poss`poss'poss~=. /*adds up all the value vars which had the value of the item if they say that own one*/ gen possscore`poss'=100*(poss`poss'/poss`poss'poss) /*creates a % var with the value of total items owned as numerator and the value of the items asked about as the denominator*/ drop *val } egen possscore1=rowmean(possscorecheap possscoremid) /*make average of cheap and middle items*/ replace possscore1=int(possscore1/10)+nyesexp /*add 1 point for each expensive item they have*/ foreach y in `yearlist' { cap xtile possscorey`y'=possscore1 if year==`y', nq(10) /*score is created by splitting the population into deciles*/ if _rc~=0 gen possscorey`y'=. } egen possscore=rowmax(possscorey*)]]> individual identifier (S) 499495 0 individual identifier variable: ident (table[s]: cen_individ, crs_cenm, css_sei_all, NCD_combined_data_all_final [derived table], combined_tb_cases_controls_final [derived table]) CRS individual identifier (D) 472084 0 CRS individual identifier CRS household identifier (D) 472084 0 CRS household identifier Round (D) 333340 166155 Round variable: rd (table[s]: css_sei_all) data source (D) 499495 0 Variable is created when processing data tables before appending together Relationship of informant to participant (S) 8847 490648 Relationship of informant to participant 1 Self 7737 2 Parent 613 3 Child/niece/nephew/grandchild 54 4 Sibling/cousin 163 5 Spouse 124 6 In-law 35 7 Grandparent/Aunt/Uncle 116 8 Non-relative 5 Sysmiss 490648 variable: informant (table[s]: combined_tb_cases_controls_final) Relationship of informant to participant (S) 360416 139079 Relationship of informant to participant 1 Partner/sibling/child 56178 2 Grandparent/grandchild/other relative 49644 3 Key informant 12 4 Neighbour/non-relative 491 5 Parent 149600 6 Self 104491 8 Unknown 0 9 Missing 0 Sysmiss 139079 variable: infmtype (table[s]: css_sei_all, crs_cenm) Relationship of informant to participant (D) 369263 130232 Relationship of informant to participant 1 Self 112228 2 Parent 150213 3 Other relative (inc spouse/inlaw) 106314 4 Non-relative 508 8 Unknown 0 9 Missing 0 Sysmiss 130232 If informant is self (D) 435109 64386 If informant is self 0 No 291769 1 Yes 143340 7 Not applicable 0 8 Unknown 0 9 Missing 0 Sysmiss 64386 =2 & informtype<8 & informtype~=. & self==.]]> If participant seen (S) 470314 29181 If participant seen 0 No 160690 1 Seen - first visit 124020 2 Seen - second visit 2081 3 Yes 183523 8 Unknown 0 9 Missing 0 Sysmiss 29181 variable: seen (table[s]: cen_individ, css_sei_all, crs_cenm) interview date (D) 499495 interview date Highest school type father attended (D) 233958 265537 Highest school type father attended 0 None 3228 1 Primary 136640 2 Secondary 85625 3 Tertiary 8465 4 Higher 0 8 Unknown 0 9 Missing 0 Sysmiss 265537 Father's education level (S) 13903 485592 Father's education level 0 Illiterate 1135 1 Literate and no formal education 163 2 Up to primary school 6612 3 Secondary school 3321 4 Graduate or higher 610 8 Don't know 2062 Sysmiss 485592 variable: foeduc (table[s]: NCD_combined_data_all_final [derived table]) Highest school type mother attended (D) 242936 256559 Highest school type mother attended 0 None 7208 1 Primary 190798 2 Secondary 43331 3 Tertiary 1599 4 Higher 0 8 Unknown 0 9 Missing 0 Sysmiss 256559 Mother's education level (S) 13903 485592 Mother's education level 0 Illiterate 2228 1 Literate and no formal education 172 2 Up to primary school 7956 3 Secondary school 1298 4 Graduate or higher 103 8 Don't know 2146 Sysmiss 485592 variable: moeduc (table[s]: NCD_combined_data_all_final [derived table]) Have you ever been to school? (S) 334158 165337 Have you ever been to school? 0 Never 26307 1 Current 139316 2 Ever 168535 8 Unknown 0 9 Missing 0 Sysmiss 165337 variable: schlever (table[s]: cen_individ, crs_cenm, css_sei_all, combined_tb_cases_controls_final [derived table]) What is the highest level of education attended? (D) 347908 151587 What is the highest level of education attended? 0 None 26902 1 Primary 245628 2 Secondary 70928 3 Tertiary 4450 4 Higher 0 8 Unknown 0 9 Missing 0 Sysmiss 151587 recode educat 0/1=0 2/4=1 5=2 6=3, gen(schltype) replace schltype=0 if schlever==0 replace schltype=1 if schlstd>4 & schlstd~=. /*assume those with school standard higher than 4 but school type is secondary are actually primary*/]]> What is the highest level of education that you completed? (S) 13903 485592 What is the highest level of education that you completed? 0 Illiterate, no formal education 538 1 Literate, no formal education 57 2 Standard 1-5, illiterate 1011 3 Standard 1-5, literate 993 4 Standard 6-8 6520 5 Secondary 4531 6 Tertiary 253 9 Missing 0 Sysmiss 485592 variable: educat (table[s]: NCD_combined_data_all_final [derived table]) What is the highest educational qualification acquired? (S) 170813 328682 What is the highest educational qualification acquired? 0 None 139569 1 PSLC 12992 2 JCE 12274 3 MSCE/GSCE 5234 4 A levels 93 5 University Diploma 154 6 University Degree 55 7 Post-Graduate Degree 1 8 Other 441 98 Unknown 0 99 Missing 0 Sysmiss 328682 variable: edqual (table[s]: css_sei_all) Grouped school level completed (D) 347931 151564 Grouped school level completed 0 None 26925 1 1-3y primary 82180 2 4-7y primary 104041 3 Primary completed 59407 4 JCE completed 38327 5 MSCE completed 32553 6 Tertiary 4498 Sysmiss 151564 recode schlstd (0=0 "None") (1/3=1 "1-3y primary") (4/7=2 "4-7y primary") (8=3 "Primary completed") (9/10=4 "JCE completed") (11/12=5 "MSCE completed") (13=6 "Tertiary"), gen(school) Highest school standard completed (D) 347931 151564 Highest school standard completed 98 Unknown 99 Missing =4 & edqual~=. & edqual~=8 /*other*/) | schltype==3 /*update schlstd to 13 (tertiary) if reported to have qualification higher than msce*/]]> Employment status (S) 248319 251176 Employment status 0 Not applicable 0 11 Full-time educaton 73716 12 Unable to work 3200 13 Retired 2069 14 Looking for work 679 19 Other 135 20 Housework 4485 30 Employer no sub-category 45 31 Runs own business 567 33 ???? 0 41 In cash economy 20026 42 Subsistence economy 127989 49 Own account don't know payment 373 51 Salary (monthly) 11149 52 Wage (weekly) 371 53 Casual or piecework 2888 54 Unpaid worker 279 59 Employee don't know payment 140 99 No information 208 998 Unknown 0 999 Missing 0 Sysmiss 251176 variable: emp (table[s]: cen_individ, crs_cenm, css_sei_all, combined_tb_cases_controls_final [derived table]) Occupation (S) 332537 166958 Occupation 0 Not working 167397 11 Teachers, nurses, clergy, writers 73 12 Teachers 2675 13 Health professionals 490 14 Clergy 341 19 Other professionals 180 22 Managing small family business 1 23 Management in large organisations 516 24 Small family business 8716 25 Commercial farmer 32 26 Traditional authority 139 30 Small trader/store keeper 0 31 Desk, shop or official outdoor jobs 130 32 Small trader/store 2572 33 Office worker 619 34 Barman/girl, waiter 224 35 Sales assistant 394 36 Army/police 345 37 Clinical assistants 914 39 Other non-manual 352 41 Modern skills 67 42 Traditional craft 28 43 Crafts and related skills 5107 44 Driver/assistant driver 857 45 African Doctor/herbalist 320 49 Other skilled manual 712 51 Agriculture 3001 52 Other manual work 336 53 Subsistence farmer 125737 54 Herdsman 144 55 Fisherman 5252 56 Labourer 2636 57 Security guard/watchman 1462 58 House boy/girl 318 59 Other unskilled manual 450 98 Unknown 0 99 Missing 0 Sysmiss 166958 variable: occ (table[s]: cen_individ, crs_cenm, css_sei_all, combined_tb_cases_controls_final [derived table]) Grouped occupation (D) 332537 166958 Grouped occupation 0 Not working 167397 1 student 0 2 unskilled manual (irr wage) 2585 3 farmer 125881 4 fisherman 5252 5 skilled manual (irr wage) 8194 6 non-manual (irr wage) 243 7 small trader/business 2572 8 unskilled manual (reg wage) 2617 9 skilled manual (reg wage) 1831 10 non-manual (reg wage) 924 11 professional 15041 Sysmiss 166958 Score of individual's employment (D) 346440 153055 Score of individual's employment main work status in the past 12 months? (S) 13903 485592 main work status in the past 12 months? 1 Government employee 352 2 Employee non govt 371 3 Subsistence farmer/fisherman 8658 4 Self employed 1896 5 Student 1062 6 At home housework 838 7 Unemployed able to work 96 8 Unemployed unable to work 280 9 Retired 125 10 Other 225 Sysmiss 485592 variable: work (table[s]: NCD_combined_data_all_final [derived table]) last year what was your average monthly take home earning per month? (S) 13891 485604 last year what was your average monthly take home earning per month? 9999998 Unknown 9999999 Missing variable: moincom (table[s]: NCD_combined_data_all_final [derived table]) 13891 485604 123594 375901 Do you have access to a working mobile phone in your household? 0 No 48508 1 Yes 75086 8 Unknown 0 9 Missing 0 Sysmiss 375901 If yes, whose phone is it? (S) 65602 433893 If yes, whose phone is it? 1 Own 45635 2 Spouse 10427 3 Parent 4514 4 Sibling 1020 5 Relative 3446 6 Visitor 85 7 Child 302 8 Other 173 9 Missing 0 Sysmiss 433893 variable: mobileowner (table[s]: css_sei_all) Do you have a working mobile phone for your personal use? (S) 101862 397633 Do you have a working mobile phone for your personal use [not used by anyone else]? 0 No 82890 1 Yes 18972 8 Unknown 0 9 Missing 0 Sysmiss 397633 variable: mobileind (table[s]: css_sei_all) If no, who do you share with? (S) 81495 418000 If no, who do you share with? 1 No, personal phone 51898 2 Share phone with others in household 28231 3 Share with others outside household 1366 9 Missing 0 Sysmiss 418000 variable: mobileshare (table[s]: css_sei_all) Do you have a working watch? (S) 3575 495920 Do you have a working watch? 0 No 3021 1 Yes 554 8 Unknown 0 9 Missing 0 Sysmiss 495920 variable: watch (table[s]: css_sei_all) Over the last 12 months, how much money has been spent on clothing for you? (S) 62150 437345 Over the last 12 months, how much money has been spent on clothing for you? 0 K 0 6012 1 K 1-500 4532 2 K 501-1000 12273 3 K 1001-2000 17339 4 K 2001-5000 15204 5 K 5001-10000 4969 6 K >10000 1821 8 Unknown 0 9 Missing 0 Sysmiss 437345 variable: clothexp (table[s]: css_sei_all) Over the last 12 months, how much money has been spent on footwear for you? (S) 62460 437035 Over the last 12 months, how much money has been spent on footwear for you? (incl. slippers) 0 K 0 8735 1 K 1-500 9939 2 K 501-1000 14247 3 K 1001-2000 14840 4 K 2001-5000 9284 5 K 5001-10000 4342 6 K >10000 1073 8 Unknown 0 9 Missing 0 Sysmiss 437035 variable: shoesexp (table[s]: css_sei_all) Household id (D) 472679 0 Household id variable: ghhid (table[s]: cen_individ, crs_cenm, css_sei_all)