MEIRU Microdata Portal
  • Home
  • Overview
  • Microdata Catalog
  • Citations
  • Login
    Login
    Home / Central Data Catalog / MWI-MEIRU-COMBINED-PHD-DATA-V01
central

PHD Progress Of Disease In Prediabetic And Prehypertensive Patients In Malawi: Assessment Of Risk Factors And Complications 2017-18 (Karonga and Lilongwe combined analytical dataset)

Malawi
Get Microdata
Reference ID
MWI-MEIRU-combined-PHD-data-v01
Collections
Combined / Harmonized Datasets Karonga HDSS Lilongwe HDSS
Metadata
DDI/XML JSON
Created on
Nov 14, 2025
Last modified
Nov 15, 2025
Page views
33704
Downloads
93
  • Study Description
  • Data Dictionary
  • Downloads
  • Get Microdata
  • Data files
  • phd_combined_final

Data file: phd_combined_final

The dataset contains data from everyone who was selected to take part regardless of whether they did (to enable calculation of response rates): to only keep records with survey data use the m_phdq variable (drop everyone with m_phdq~=3)
In the variable labels (S) indicates that the variable is unchanged from the original source and (D) indicates that it is a 'derived' variable, often using more than one source variable. For both types information on where the data come from and how they are processed is found in the 'Recoding and Derivation' section

Cases: 865
Variables: 743

Variables

stid
Study identifier (S)
repgp
Reporting group (S)
cluster
Cluster (S)
hhlistno
Houshold list number (S)
membno
Member number (S)
sel
I is moved in M = moved out of reporting group (S)
ident
Ident (S)
visit
Visit (S)
lhhno
Lilongwe house nuber (S)
stidncd
NCD Study number (S)
surv_reas
Survey Reason (S)
extdate
Extraction date from database (S)
passport
Health passport seen (S)
cons
Consented (S)
consdate
Consent date (S)
accrt
Accepted rapid testing (S)
phdq
PHDQ filled (S)
accbleed
Accepted bleeding (S)
gsp
GSP filled (S)
reqbleeddate
Request Bleed date (S)
reqbleedtime
Request Bleed time (S)
bled
Bled (S)
bleeddate
Bleed date (S)
urine
Urine taken (S)
consret
Consent to retinopathy ecg (S)
comment
comment (S)
intdate_cons
Interview date, consent form (S)
consenta
Read info sheet (S)
consentb
Consent to participate (S)
consentc
Consent to give blood (S)
consentd
Consent to be tested for HIV (S)
consente
Consent to blood storage (S)
consentf
Consent to retinopathy and ECG (S)
consentg
Consent to share data (S)
disclosure
Would like results (S)
m_cons
result of merge between fieldlog and consent (D)
version
Version (S)
cno
Contact Number (S)
stdypl
Study place (S)
rcdr
Recorder (S)
intdate_phdq
Interview date, questionnaire (S)
intlang
Interview Language (S)
sex
Sex (D)
birth_date
birth date (D)
age
Age in years (D)
totschl
How many years have you spent at school/in full-time study (exc pre-school)? (S)
ethnic
Ethnicity (S)
educat
Highest level of education (S)
workm12
Main work status over the past 12 months (S)
mainocc
Main occupation (S)
migr
Experience of migrant work (S)
moincomcat
Estimate of the monthly household income (S)
everalcohol
Ever drank alcohol (S)
alcoholm12
In last 12 months, how frequently have you had at least one alcoholic drink (S)
eversmoked
Ever smoked (S)
cursmoke
Currently smoke any tobacco products (S)
agesmoke
Age started smoking 10-99, 1000 (S)
ncsmoke
Number smoke per day (S)
everpreg
Ever pregant (S)
nopreg
Number of pregnacies (S)
curpreg
Currently pregnant (S)
meatwk
In a typical week, on how many days do you eat meat (S)
vigwork
Vigorous work that causes large increases in breathing/heart rate (S)
fambp
Family member with hypertension (S)
famdiab
Family member with diabetes (S)
famheart
Family member with heart disease (S)
diabp
Ever told have high blood presure (S)
agediabp
Age diagnosed with high BP (S)
remdbp
Ever taken treatment for high blood presure (S)
medhydr
Taking HTC (S)
medamlo
Taking Amlodipine (S)
mednifed
Taking Nifedipine (S)
medenal
Taking Enalapril (S)
medcapt
Taking Captopril/ Lisinopril (S)
medaten
Taking Atenolol (S)
medprop
Taking Propranolol (S)
medmeth
Taking Methyldopa/ Aldomet (S)
medoth
Taking othert remdbp=2 (S)
medothhtn
Other medicine text medorth = 2 (S)
bsug
Last time tested for blood suge (S)
diadiab
Diagnosed with raised blood sugar or diabetes (S)
agediab
Age diagnosed with high disabetees (S)
remddiab
Ever taken treatment for diabetees e (S)
medmetf
Taking Metformin (S)
medgliben
Taking Glibenclamide (S)
medlente
Taking Lente (S)
medactra
Taking Actrapid (S)
medacraph
Taking Acraphane (S)
medproto
Taking Protophane (S)
mednovo
Taking Novomix (S)
medothdia
Taking othert remddiab =2 (S)
medothdet
Other medicine text medorthdia = 2 (S)
diastro
Diagnosed with stroke (S)
agestro
Age diagnosed with stroke (S)
diaheart
Diagnosed with heart disease (S)
ageht
What age first diagnosed with heart disease (S)
typehtd
Type of heart disease (S)
htdoth
Other heart disease (S)
diakid
Diagnosed with kidney disease (S)
agediakid
Age diagnosed with high BP (S)
kiddis
Have which kidney diseaset (S)
kiddisoth
Other kidney disease (S)
ihda1
Ever had chest pain (S)
ihda2
Pain when walk up hill or hurry (S)
ihda3
Walk at ordinary pace (S)
ihda4
When get pain what do you do (S)
ihda5
Go away when stand still (S)
ihda6
How soon go away (S)
ihda7
IMAGE ??????? (S)
ihdb1
Ever had chest pain for more than houe (S)
ihdc1
Pain either legs when walking (S)
ihdc2
Pain sitting or stainding stil (S)
ihdc3
Pain in calves (S)
ihdc4
Pain when walk up hill or hurry (S)
ihdc5
Pain when walk at ordianry pace (S)
ihdc6
Pain disapear when walking (S)
ihdc7
When get pain what do you do (S)
ihdc8
What happens when stand still (S)
rcdr2
Staff code bleeder (S)
bpdeid
BP device id (S)
muacf
Mid upper arm 1st Measure (S)
muacs
Mid upper arm 2nd Measure (S)
cuffsize
Cuff size used (S)
sysbpf
BP systolic first (S)
sysbps
BP systolic second (S)
sysbpt
BP systolic third (S)
diabpf
BP diasystolic first (S)
diabps
BP diasystolic second (S)
diabpt
BP diasystolic third (S)
pulsef
pulse first (S)
pulses
Pulse second (S)
pulset
Pulse third (S)
refbp
Refered to clinic high blood presure (S)
refbpno
Why not refered for high blood presure (S)
remdbpw2
During the past two weeks, treated for raised BP with drugs (S)
rcdr3
Recorder 3 - anthropometry (S)
waiscf
Waist 1st reading (S)
waiscs
Waist 2nd reading (S)
hipcuf
Hip circumfrence 1st reading (S)
hipcus
Hip circumfrence 2nd reading (S)
heightf
Height 1st reading (S)
heights
Height 2nd reading (S)
weightf
Weight 1st reading (S)
weights
Weight 2nd reading (S)
m_phdq
result of merge between fieldlog/consent and PHDQ (D)
intdate_hsbc
interview date from HSBC tables (S)
hgs
Hand grip strength (S)
weight
weight (S)
bmi
Body mass index (S)
bodyw
Body water % (S)
bonem
Bone mass (S)
bodyf
Body fat (S)
mqs
Muscle quality (S)
musclem
Muscle mass (S)
m_hsbc
result of merge between fieldlog/consent/PHDQ and HSBC (D)
datecoll_gluc1
date of sample collection for glucose testing 2 (D)
gluc_units1
glucose result 2 (D)
datecoll_gluc2
date of sample collection for glucose testing 3 (D)
gluc_units2
glucose result 3 (D)
datecoll_lip
date of sample collection for lipid testing (D)
ldl_units
LDL result (D)
hdl_units
HDL result (D)
chol_units
cholesterol result (D)
tg_units
triglicerides result (D)
datecoll_hba
date of sample collection for HBA1c testing (D)
hba1c_units
HBA1c result (D)
datecoll_urelec
date of sample collection for urine electrolytes testing (D)
ucreat_units
urine creatine results (D)
ualb_units
urine albumin results (D)
datecoll_serelec
date of sample collection for serum creatinine testing (D)
screat_units
serum creatinine results (D)
eGFR
eGFR (D)
eGFRgroup
grouped eGFR1 (D)
eGFRgroup2
grouped eGFR2 (D)
b_version
Form version number
b_site
site of data collection (D)
b_comdate
Completion date
b_quarter
quarter (of year) of interview (D)
b_year
year of interview (D)
b_wkday
day of week interview took place (D)
b_weekend
if interview took place at the weekend (D)
b_crsno
CRS number (D)
b_firststid
Previous NCD stid if interviewed twice. (D)
b_dup
Whether person is known to have been interviewed in the NCD before (D)
b_house
house identifier (D)
b_lvillage
Village number
b_dob
Date of birth (D)
b_age
Age in years (D)
b_agegroup
Categorised age group (large categories) (D)
b_agegroup1
Categorised age group (10-year categories) (D)
b_agegroup5
b_sex
Sex
b_nhvf
Number of household visits (referred to the clinic but did not attend) (D)
b_ncf
Number of clinic visits recorded (D)
b_ncac
Whether part of clinic costs sub-study (D)
b_nopf
Number of out-patient visits recorded (D)
b_nbpf
Number of follow-up blood pressure measurements (D)
b_ndsf
Whether part of diabetic foot sub-study (D)
b_npsf
Whether part of pedometer sub-study (D)
b_nrsf
Whether part of retinopathy sub-study (D)
b_finhh
Number of females in household at time of interview (D)
b_minhh
Number of males in household at time of interview (D)
b_fint
Number of females in household interviewed (D)
b_mint
Number of males in household interviewed (D)
b_fmissed
Number of females in household missed for interview (D)
b_mmissed
Number of males in household missed for interview (D)
b_numad
Number of adults living in the houseshold (D)
b_numad_cap
RECODE of numad
b_chone
Number of children aged under 1 year in household (D)
b_chone_cap
RECODE of chone (Children < 1)
b_chofr
Number of children aged 1-4 years in household (D)
b_chofr_cap
RECODE of chofr (Children 1-4)
b_chfsv
Number of children aged 5-17 years in household (D)
b_chfsv_cap
RECODE of chfsv (Children 5-17)
b_cmarital
Current marital status (D)
b_marrepdt_kar
Karonga only: date of report for marital status (D)
b_nospouse
No of spouse (s) (D)
b_ethnic
Ethnic background
b_ethnicoth
Ethnic other
b_educat
Highest level of education
b_school
Education level (broad categories) (D)
b_work
Work status past 12 mnts
b_workoth
Work other
b_occupation
Type of work (broad categories) (D)
b_incrank
categorised work variable (D)
b_fpwork
Work full or part time
b_moincom
Average monthly income over past 12 months
b_tothhincome
Total monthly income in household. (D)
b_avhhincome
Household income averaged per person reporting in study. (D)
b_avhhincscore
Karonga and Lilongwe: average household income score (deciles). (D)
b_avhhincscorek
Karonga only: average household income score (deciles). (D)
b_avhhincscorel
Lilongwe only: average household income score (deciles) (D)
b_indincscore
Karonga and Lilongwe: individual income score (deciles) (D)
b_indincscorek
Karonga only: inidividual income score (deciles) (D)
b_indincscorel
Lilongwe only: individual income score (deciles) (D)
b_moeduc
Highest level of education mother
b_foeduc
Highest level of education father
b_resmoke
Ever smoked
b_agesmoke
Age started smoking
b_yrsmoke
How many years smoked
b_tmsmoke
Days per week smoke
b_ncsmoke
No. smoke per day
b_othtobac
Ever smoked
b_tytobac
Type other tobacco
b_agetobac
Age started other tobacco
b_yrtobac
How many years take other tobacco
b_nosmoke
Days per week took other tobacco
b_ntobac
No. other tobacco per day
b_cigweek
Average number of cigarettes smoked in a week (currently or previously) (D)
b_smoker
summary variable of number of cigarettes smoked (D)
b_indsmoke
Indoor Fire
b_yrinsmok
Years used wood etc to cook
b_hrinsmok
Hours per day took wood last 6 months
b_curinsk
Wood etc still used for cooking
b_vented
Stove vented to outside
b_hosmoke
Smoker in household
b_alcohol
Consumed alcohol last 12 months
b_nalcohol
How ofter alcohol last 12 months
b_alcoft
Summary variable of alcohol usage (D)
b_sachety
Drink sachets in last 7 days
b_sachetu
Days drank sachets in last 7 days
b_sachetd
Number drank sachets in last 7 days
b_chibukuy
Drink chibuku in last 7 days
b_chibukuu
Days drank chibuku in last 7 days
b_chibukud
Number drank chibuku in last 7 days
b_homebry
Drink homebrew in last 7 days
b_homebru
Days drank homebrew in last 7 days
b_homebrd
Number drank homebrew in last 7 days
b_winey
Drink wine in last 7 days
b_wineu
Days drank wine in last 7 days
b_wined
Number drank wine in last 7 days
b_carlsby
Drink carlsberg in last 7 days
b_carlsbu
Days drank carlsberg in last 7 days
b_carlsbd
Number drank carlsberg in last 7 days
b_kucheky
Drink kuche kuche in last 7 days
b_kucheku
Days drank kuche kuche in last 7 days
b_kuchekd
Number drank kuche kuche in last 7 days
b_powery
Drink powers in last 7 days
b_poweru
Days drank powers in last 7 days
b_powerd
Number drank powers in last 7 days
b_brandyy
Drink brandy in last 7 days
b_brandyu
Days drank brandy in last 7 days
b_brandyd
Number drank brandy in last 7 days
b_malawigy
Drink malawi gin in last 7 days
b_malawigu
Days drank malawi gin in last 7 days
b_malawigd
Number drank malawi gin in last 7 days
b_numbdrink
total units drank (D)
b_numbdrinkday
total days drank (D)
b_drinker
summary variable of number of units drank (D)
b_prmeal
How often home cooked food
b_dayboil
Days 250ml oil last
b_boilperday
Estimate of amount of oil taken per day (D)
b_boilgrp
Estimate of amount of oil taken per day (grouped) (D)
b_nbutmag
How often use butter-marg
b_daysalt
Days 50g of salt last
b_saltperday
Estimate of amount of salt taken per day (D)
b_saltgrp
Estimate of amount of salt taken per day (grouped) (D)
b_extsalt
Use extra salt
b_tepsugar
No.teaspoons of sugar per cup
b_teacoffe
No.cups tea coffee per day
Total: 743
123>
Back to Catalog
MEIRU Microdata Portal

© MEIRU Microdata Portal | admin@meirudata.mw | All Rights Reserved | Register