NCD_combined_all DDI-MWI-MEIRU-NCD-Combined-2013-v1.0 Estelle McLean Jacky Saul Keith Branson Chifundo Kanjala Dominic Nzundah Elizabeth Munthali Louis Banda Malawi Epidemiology and Intervention Research Unit 2018-09-26 Nesstar Publisher Version 1.0 ( February,2018) NCD_combined_all NCD Combined analytical dataset MWI-MEIRU-NCD-2013-v1.0 Prof Moffat Nyirenda Prof Shabbar Jaffar

Dr Yusuf Hamied

Dr Charles Mwansambo Dr Ben Chilima Dr Storn Kabuluzi Dr George Chitope-Mwale Dr Beatrice Mwagomba Dr Mwawi Mwale Dr Mia Crampin Dr Michael Kayange Dr Alemayehu Ambebir Dr Amos Phiri Dr Alison Price Dr Terence Tafatatha Prof Shah Ebrahim Prof Peter Piot Prof Tony Harries 2016-09-02 Nesstar Publisher Wellcome Trust Sample Survey Non-communicable diseases Hypertension Diabetes Epidemiology Malawi overweight obesity Cardiovascular disease Physical inactivity Systolic Blood Pressure Diastolic Blood Pressure Malawi Karonga HDSS and Lilongwe Area 25 residential area Individual All adults aged 18 years and above who were usually resident in the Karonga HDSS and in Lilongwe Area 25 at the time of the survey Sample survey data Malawi Epidemiology And intervention Research Unit Face-to-face [f2f] Lilongwe Malawi Epidemiology and Intervention Research Unit ncd_combined_data_all.NSDstat 30575 109 Nesstar 200801 Malawi Epidemiology and Intervention Research Unit Form version number Version 30575 0 variable: version (table[s]: ncdk_personal, ncdl_personal) site of data collection (D) 30575 0 1 Karonga 13903 2 Lilongwe 16672 Site of data collection derived from whether data came from ncdk (Karonga) or ncdl (Lilongwe) tables. Completion date Date form completed 30575 variable: comdate (table[s]: ncdk_personal, ncdl_personal) Study ID study identifier 30575 0 variable: stid (table[s]: ncdk_fieldlog, ncdl_fieldlog, and all other linked NCD tables) house identifier (D) 30575 0 Age in years (D) 30574 1 34.946 sex sex 30574 1 1 Male 11668 2 Female 18906 9 Missing 0 Sysmiss 1 variable: sex (table[s]: gen_identity, ncdl_identity) Number of adults living in the houseshold (D) 30575 0 Number of children aged under 1 year in household (D) 30158 417 Number of children aged 1-4 years in household (D) 30158 417 Number of children aged 5-17 years in household (D) 29118 1457 Current marital status (D) What is your current marital status? 30553 22 0 Never married 7001 1 Married 19439 2 Divorced/Separated 2194 3 Widowed 1919 8 Unknown 0 9 Missing 0 Sysmiss 22 No of spouse (s) (D) If 2, how many spouses do you have now? 19439 11136 Education level (broad categories) (D) 30575 0 0 No formal 1179 1 Standard 1-5 3335 2 Standard 6-8 9822 3 Secondary 13232 4 Tertiary 3007 Type of work (broad categories) (D) 30575 0 0 Not working 6410 1 Housework 5822 2 Farming/fishing 8745 3 Self-employed 5016 4 Employed 4582 Highest level of education mother What was the highest education attained by your mother? 30575 0 0 Illiterate 4567 1 Literate and no formal education 392 2 Up to primary school 15642 3 Secondary school 4675 4 Graduate or higher 1172 8 Don't know 4127 variable: moeduc (table[s]: ncdk_personal, ncdl_personal) Highest level of education father What was the highest education attained by your father? 30575 0 0 Illiterate 2481 1 Literate and no formal education 293 2 Up to primary school 12183 3 Secondary school 8480 4 Graduate or higher 2867 8 Don't know 4271 variable: foeduc (table[s]: ncdk_personal, ncdl_personal) summary variable of number of cigarettes smoked (D) 30575 0 0 Never 28480 1 Former 757 2 <6 cig/week 177 3 6+ cig/week 1161 =6 & cigweek~=. & resmoke==3 replace smoker=1 if resmoke==2]]> Indoor Fire Has an indoor fire with wood or crop residue or dun been used in your home as a primary means of cooking for more than 6 months in your life? 30575 0 0 No 1246 1 Yes, inside the house 1794 2 Yes, but in a separate kitchen area 27535 variable: indsmoke (table[s]: ncdk_personal, ncdl_personal) Years used wood etc to cook If yes, how many years has wood or crop residue or dung been used for cooking in your home? 29329 1246 999 Missing variable: yrinsmok (table[s]: ncdk_personal, ncdl_personal) Hours per day took wood last 6 months On average for how many hours a day have you personally spent cooking using wood or crop residues in the last 6 months? 29329 1246 99 Missing variable: hrinsmok (table[s]: ncdk_personal, ncdl_personal) Wood etc still used for cooking Is wood or crop residue or dung still used for cooking in your home? 30575 0 0 No 1701 1 Yes 28874 variable: curinsk (table[s]: ncdk_personal, ncdl_personal) Stove vented to outside Is your stove or fire vented to the outside (e.g. by a chimney)? 30575 0 0 No 2777 1 Yes 27798 variable: vented (table[s]: ncdk_personal, ncdl_personal) Smoker in household Is there someone in your household who smokes cigarettes or other tobacco inside the house? 30575 0 0 No 27111 1 Yes 3464 variable: hosmoke (table[s]: ncdk_personal, ncdl_personal) Summary variable of alcohol usage (D) 30575 0 0 Never 24991 1 Rarely 3364 2 Often 2220 3 replace alcoft=2 if alcohol==1 & nalcohol<=3]]> total days drank (D) 30575 0 NB. suffixes u & d were accidentally switched and have been left this way so variables with suffix u used to create the total days. summary variable of number of units drank (D) 30575 0 0 Never 24991 1 <8 drinks/week 4188 2 8-22 drinks/week 1024 3 22+ drinks/week 372 0 & numbdrink<8 replace drinker=1 if numbdrink==0 & alcohol==1 replace drinker=2 if numbdrink>=8 & numbdrink<22 replace drinker=3 if numbdrink>21]]> How often home cooked food On average, how often in a week do you eat food that was cooked at home? 30575 0 1 Daily/most days 29628 2 3-4 days per week 757 3 1-2 days per week 133 4 Very rarely or never 57 8 Don't know 0 variable: prmeal (table[s]: ncdk_personal, ncdl_personal) Estimate of amount of oil taken per day (grouped) (D) 29118 1457 1 <5ml 1342 2 5-15ml 9651 3 15-30ml 13097 4 30-45ml 3725 5 45-60ml 773 6 60-75ml 316 7 75-100ml 155 8 100-125ml 25 9 125-250ml 30 10 250ml+ 4 Sysmiss 1457 How often use butter-marg How often do you use consume butter or margarine? 30168 407 1 Daily/most days 1782 2 3-4 days per week 1283 3 1-2 days per week 2197 4 Very rarely or never 24906 8 Don't know 0 9 Missing 407 variable: nbutmag (table[s]: ncdk_personal, ncdl_personal) Estimate of amount of salt taken per day (grouped) (D) 29118 1457 1 <1g 851 2 1-3g 2548 3 3-6g 11052 4 6-9g 7032 5 9-12g 3588 6 12-15g 1839 7 15-20g 1138 8 20-25g 526 9 25-50g 489 10 50g+ 55 Sysmiss 1457 Use extra salt Do you add extra salt to your plate? 30575 0 0 No 9222 1 Yes 21353 variable: extsalt (table[s]: ncdk_personal, ncdl_personal) No.teaspoons of sugar per cup On average, how many teaspoons of sugar do you use in each cup of tea or coffee? 30575 0 99 Missing variable: tepsugar (table[s]: ncdk_personal, ncdl_personal) No.cups tea coffee per day How many cups of tea or coffee do you drink each day? 30575 0 99 Missing variable: teacoffe (table[s]: ncdk_personal, ncdl_personal) No. sweet drinks In a week, how many sweet drinks do you consume? (e.g, Fanta/Coke, Mahewu, Sobo etc) 30575 0 99 Missing variable: sweetdk (table[s]: ncdk_personal, ncdl_personal) How often food prepared away On average, how often do you eat food prepared away from home each week? 30575 0 1 Daily/most days 796 2 3-4 days per week 553 3 1-2 days per week 1847 4 Very rarely or never 27379 variable: outfood (table[s]: ncdk_personal, ncdl_personal) physical activity rating (D) 30575 0 0 Low 711 1 Moderate 1964 2 High 27900 =3 & totvigm>=20) | (totmodd+totwalkd>=5 & totmodm+totwalkm>=30) | (totvigd+totmodd+totwalkd>=5 & totmet>=600) replace pacat=2 if (totvigd>=3 & totmet>=1500) | (totvigd+totmodd+totwalkd>=7 & totmet>=3000) replace pacat=pacat+1 if farmfix==1 & pacat~=2 & phjob==0 replace pacat=. if totmet==0 & pacat==0]]> whether met the WHO recommendation for physical activity (D) 30575 0 0 Not met WHO recom 711 1 Met WHO recom 29864 Ever pregnant Have you ever been pregnant? If No go to Q10.1 18885 11690 0 No 2608 1 Yes 16277 Sysmiss 11690 variable: evpreg (table[s]: ncdk_personal, ncdl_personal) Age pregnant 999 if unknown If yes, what age were you when you first became pregnant? 16277 14298 999 Missing variable: agepreg (table[s]: ncdk_personal, ncdl_personal) Number times pregnant How many pregnancies have you had? 16277 14298 variable: nopreg (table[s]: ncdk_personal, ncdl_personal) Number live births How many live births have you had? 16277 14298 variable: nochild (table[s]: ncdk_personal, ncdl_personal) Currently pregnant Are you pregnant at the moment? 16277 14298 0 No 15208 1 Yes 1069 Sysmiss 14298 variable: curpreg (table[s]: ncdk_personal, ncdl_personal) Which trimester If yes, which trimester are you in? 1069 29506 1 1-3 months 262 2 4-6 months 448 3 7-9 months 359 Sysmiss 29506 variable: tripreg (table[s]: ncdk_personal, ncdl_personal) Whether household has electricity (household mode) (D) 30575 0 0 No 20019 1 Yes 10556 8 Unknown 0 Whether household owns a paraffin lamp (household mode) (D) 30575 0 0 No 23617 1 Yes 6958 8 Unknown 0 Whether household owns a tv (household mode) (D) 30575 0 0 No 19073 1 Yes 11502 8 Unknown 0 Whether household owns a mobile phone (household mode) (D) 30575 0 0 No 6916 1 Yes 23659 8 Unknown 0 Whether household owns a land phone (household mode) (D) 30575 0 0 No 29008 1 Yes 1567 8 Unknown 0 Whether household owns a bed with mattress (household mode) (D) 30575 0 0 No 3947 1 Yes 26628 8 Unknown 0 Whether household owns a sofa (household mode) (D) 30575 0 0 No 15695 1 Yes 14880 8 Unknown 0 Whether household owns a fridge (household mode) (D) 30575 0 0 No 22654 1 Yes 7921 8 Unknown 0 Whether household owns a tabchar (household mode) (D) 30575 0 0 No 7954 1 Yes 22621 8 Unknown 0 Whether household owns an electric or gas cooker (household mode) (D) 30575 0 0 No 22741 1 Yes 7834 8 Unknown 0 Whether household has water piped to house (female only mode) (D) 30575 0 0 No 23269 1 Yes 7306 8 Unknown 0 Whether household owns a motorcycle (household mode) (D) 30575 0 0 No 30195 1 Yes 380 8 Unknown 0 Whether household owns a car (household mode) (D) 30575 0 0 No 27211 1 Yes 3364 8 Unknown 0 Whether household owns a bicycle (household mode) (D) 30575 0 0 No 17728 1 Yes 12847 8 Unknown 0 Whether household owns a radio (household mode) (D) 30575 0 0 No 8628 1 Yes 21947 8 Unknown 0 Whether household owns a cow (household mode) (D) 30575 0 0 No 26635 1 Yes 3940 8 Unknown 0 Whether household owns an oxcart (household mode) (D) 30575 0 0 No 29457 1 Yes 1118 8 Unknown 0 Household water source (female only mode) (D) 30575 0 1 Tap to house 13083 2 Shared communal tap 6652 3 Bore hole 6210 4 Covered well 3844 5 Open well 346 6 Lake/river 414 7 Other 26 Karonga & Lilongwe: summary possession score using the mode values (D) 30575 0 Karonga only: summary possession score using the mode values (D) 13903 16672 Lilongwe only: summary possession score using the mode values (D) 16672 13903 Advice doctor Have you received advice from your doctor or other health professional to lose weight? 30575 0 0 No 26041 1 Yes 4534 variable: advlwt (table[s]: ncdk_persexam & ncdl_persexam) Advice doctor stop smoking Have you received advice from your doctor or other health professional to stop smoking? 30575 0 0 No 25900 1 Yes 4675 variable: advsom (table[s]: ncdk_persexam & ncdl_persexam) Advice doctor more exercise Have you received advice from your doctor or other health professional to do more exercise? 30524 51 0 No 24177 1 Yes 6347 Sysmiss 51 variable: advexr (table[s]: ncdk_persexam & ncdl_persexam) Blood pressure taken no months (999 for never measured)], 0 if less than a month How long ago did you last have your blood pressure measured? 30575 0 999 Not taken variable: advbp (table[s]: ncdk_persexam & ncdl_persexam) Diagnosed high bloood persure Have you ever been diagnosed with high blood pressure by a doctor or other health professional? If No go to Q10.9 30575 0 0 No 27821 1 Yes 2754 8 Unknown 0 variable: diabp (table[s]: ncdk_persexam & ncdl_persexam) Age diagnosed high blood presure 999 if unknown If yes, what age were you when you first diagnosed? 2754 27821 variable: agedibp (table[s]: ncdk_persexam & ncdl_persexam) Medication for high bloood persure Are you on regular medication for high blood pressure? If No go to Q10.9 2755 27820 0 No 1499 1 Yes 1251 8 Unknown 5 Sysmiss 27820 variable: remdbp (table[s]: ncdk_persexam & ncdl_persexam) Blood sugar taken no months 999 for never measured When was the last time you had your blood sugar checked? 30575 0 999 Not taken variable: blsug (table[s]: ncdk_persexam & ncdl_persexam) Diagnosed diabetes Have you been diagnosed with diabetes by a doctor or other health professional? If No go to Q10.14 30575 0 0 No 30217 1 Yes 358 8 Unknown 0 variable: diadiab (table[s]: ncdk_persexam & ncdl_persexam) Age diagnosed diabetes 999 if unknown If yes, what age were you when you first diagnosed? 363 30212 999 Missing variable: agediab (table[s]: ncdk_persexam & ncdl_persexam) Medication for diabetes Are you on regular medication for diabetes? If No go to Q10.14 363 30212 0 No 121 1 Yes 242 8 Unknown 0 Sysmiss 30212 variable: remddiab (table[s]: ncdk_persexam & ncdl_persexam) Cholesterol taken no months 999 for never measured When was the last time you had your cholesterol checked? 30575 0 999 Not taken variable: chole (table[s]: ncdk_persexam & ncdl_persexam) Diagnosed cholesterol Have you ever been diagnosed with raised cholesterol by a doctor or other health professional? If No go to Q10.19 30575 0 0 No 30504 1 Yes 71 8 Unknown 0 variable: diachole (table[s]: ncdk_persexam & ncdl_persexam) Age diagnosed cholesterol 999 if unknown If yes, what age were you when you first diagnosed? 71 30504 variable: agechole (table[s]: ncdk_persexam & ncdl_persexam) Medication for cholesterol Are you on regular medication for raised cholesterol? 71 30504 0 No 61 1 Yes 10 8 Unknown 0 Sysmiss 30504 variable: remdcho (table[s]: ncdk_persexam & ncdl_persexam) Diagnosed stroke Have you ever been diagnosed with stroke by a doctor or other health professional? If No go to Q10.21 30575 0 0 No 30349 1 Yes 226 8 Unknown 0 variable: diastro (table[s]: ncdk_persexam & ncdl_persexam) Age diagnosed stroke 999 if unknown If yes, what age were you when you first diagnosed? 226 30349 variable: agestro (table[s]: ncdk_persexam & ncdl_persexam) Diagnosed heart disease Have you ever been diagnosed with heart disease by a doctor or other health professional? If No go to Q10.25 30575 0 0 No 30016 1 Yes 559 8 Unknown 0 variable: diaheart (table[s]: ncdk_persexam & ncdl_persexam) Age diagnosed heart disease 999 if unknown If yes, what age were you when you first diagnosed? 559 30016 variable: ageht (table[s]: ncdk_persexam & ncdl_persexam) Type heart disease Type of heart disease you diagnosed? 559 30016 1 Angina 97 2 Heart attack 111 3 Heart failure 39 4 Other 68 8 Don't know 244 9 Missing 0 Sysmiss 30016 variable: typehtd (table[s]: ncdk_persexam & ncdl_persexam) Wheezing in last year Have you had wheezing or whistling in your chest at any time in the past year? 30575 0 0 No 29585 1 Yes 990 variable: wheze (table[s]: ncdk_persexam & ncdl_persexam) Wheezing in last year make short of breath In the last year have you ever had an attack of wheezing or whistling that has made you feel short of breath? 30575 0 0 No 29395 1 Yes 1180 variable: spwheze (table[s]: ncdk_persexam & ncdl_persexam) Diagnosed asthma Have you ever been diagnosed with asthma, asthmatic bronchitis or allergic bronchitis by a doctor or other health professional? If No go to Q10.31 30575 0 0 No 29088 1 Yes 1487 variable: asthma (table[s]: ncdk_persexam & ncdl_persexam) Age diagnosed asthma 999 if unknown If yes, what age were you when you first diagnosed? If yes, what age were you when you first diagnosed? 1487 29088 variable: ageathma (table[s]: ncdk_persexam & ncdl_persexam) Medication for asthma Are you on regular medication for asthma? 1487 29088 0 No 831 1 Yes 650 8 Unknown 6 Sysmiss 29088 variable: asthmed (table[s]: ncdk_persexam & ncdl_persexam) Diagnosed TB Have you ever been diagnosed with tuberculosis by a doctor or other health professional? If No go to Q11.1 30575 0 0 No 29821 1 Yes 754 variable: diatb (table[s]: ncdk_persexam & ncdl_persexam) Age diagnosed TB 999 if unknown If yes, what age were you when you first diagnosed? 754 29821 77.785 999 Missing variable: agetb (table[s]: ncdk_persexam & ncdl_persexam) Systolic blood pressure (average) (D) 30555 20 74 257.5 122.4 17.473 Diastolic blood pressure (average) (D) 30554 21 42 146.5 73.336 10.884 Hypertensive level (4 categories) (D) 30554 21 0 No 26726 1 mild: dia90+sys140+ 2405 2 moderate: dia100+sys160+ 942 3 Severe: dia110+sys180+ 481 Sysmiss 21 =90 & diastolic~=.) | (systolic>=140 & systolic~=.) replace ht=2 if (diastolic>=100 & diastolic~=.) | (systolic>=160 & systolic~=.) replace ht=3 if (diastolic>=110 & diastolic~=.) | (systolic>=180 & systolic~=.)]]> Hypertensive level (2 categories) (D) 30554 21 0 No 26726 1 Yes 3828 8 Unknown 0 Sysmiss 21 Weight (average) (D) Weight (Kgs) 30539 36 25 168.3 60.367 12.126 Height (average) (D) 30521 54 100 219 160.027 7.979 body mass index (excluding pregnant women) (D) 29450 1125 12.602 65.023 23.534 4.551 body mass index (weight in kg / height in metres squared) (excluding pregnant women) categorised BMI (D) 29450 1125 Waist circumference (average) (D) 29470 1105 23 184.1 79.451 10.488 Hip circumference (average) (D) 30519 56 58 198 94.896 10.028 Mid-upper arm circumference (average) (D) 30575 0 result of fasted glucose test (D) 25033 5542 result of non-fasted glucose test (D) 44 30531 binary diabetes variable using glucose level and self-report (D) 30575 0 0 No 24498 1 Yes 609 8 Unknown 5468 11 & glucunits_NONfast~=.) | (glucunits_fast>=7 & glucunits_fast~=.)) & diabetes==.)]]> categorised variable of impaired glucose (D) 24706 5869 0 not impaired 23230 1 Slightly impaired 5.6-7 1226 2 Impaired 7+ 250 Sysmiss 5869 =5.6 & glucunits_fast<7.0 replace fastgluc=2 if glucunits_fast>=7.0 & glucunits_fast!=. replace fastgluc=. if diadiab==1]]> Haemoglobin 25073 5502 3.4 22.2 13.745 1.812 variable: hgb (table[s]: ser_fbc, lab_fbc) Percentage 3647 26928 variable: hba1_units (table[s]: ser_hba1c, lab_hba1c)