Cross-sectional survey of impaired renal function among adults nested within a large cross-sectional survey of non-communicable diseases. Each row refers to one participant, containing variables on their answers to a questionnaire, anthropometric measures, and laboratory results.
The following table lists data collected by the Malawi Epidemiology and Intervention Research Unit during the research process. Access to the full dataset is limited to the study team, in accordance with the study ethical and legal commitments. However, a de-identified dataset may be requested, on condition that the intended use is compatible with the study research objectives and complies with it ethical and legal conditions.
Variable Name | Variable Label | Answer Label | Answer Code | Variable Type |
comdate | Date Completed | Open ended | long | |
householdid | Household identifier | Open ended | String | |
individualid | Individual identifier | Open ended | String | |
year | Survey year | Open ended | Integer | |
dob | Date of birth | Open ended | long | |
age | Age in years | Open ended | Numeric | |
agegroup | 10 year group with 65+ as the oldest age group | Numeric | ||
15-24 | 15 | |||
25-34 | 25 | |||
35-44 | 35 | |||
45-54 | 45 | |||
55-64 | 55 | |||
65+ | 65 | |||
agegroup1 | 10 year group with 75+ as the oldest age group | Numeric | ||
15-24 | 15 | |||
25-34 | 25 | |||
35-44 | 35 | |||
45-54 | 45 | |||
55-64 | 55 | |||
65-74 | 65 | |||
75+ | 75 | |||
educat | What is the highest level of education that you completed? | Numeric | ||
Illiterate | 1 | |||
Literate but no formal education | 2 | |||
Illiterate Standard 1-5 | 3 | |||
Literate Standard 1-5 | 4 | |||
Standard 6-8 | 5 | |||
Secondary | 6 | |||
Tertiary | 7 | |||
school | Education level (broad categories) | Numeric | ||
No formal | 0 | |||
Standard 1-5 | 1 | |||
Standard 6-8 | 2 | |||
Secondary | 3 | |||
Tertiary | 4 | |||
work | Work status past 12 mnts | Numeric | ||
Government employee | 1 | |||
Employee non government | 2 | |||
Subsistence farmer/fisherman | 3 | |||
Self-employed | 4 | |||
Student | 5 | |||
At home doing housework | 6 | |||
Unemployed (able to work) | 7 | |||
Unemployed (unable to work) | 8 | |||
Retired | 9 | |||
Other | 10 | |||
workoth | Work other | Open ended | String | |
occupation | Type of work (broad categories) | Numeric | ||
Not working | 0 | |||
Housework | 1 | |||
Farming/fishing | 2 | |||
Self-employed | 3 | |||
Employed | 4 | |||
resmoke | Ever smoked | Numeric | ||
Never | 1 | |||
Stopped more 6 months | 2 | |||
Current in last 6 months | 3 | |||
smoker | Summary variable of number of cigarettes smoked | Numeric | ||
Never | 0 | |||
Former | 1 | |||
<6 cig/week | 2 | |||
6+ cig/week | 3 | |||
alcohol | Consumed alcohol last 12 months | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Refused/NA | 8 | |||
Unknown | 9 | |||
alcoft | Summary variable of alcohol usage | Numeric | ||
Never | 0 | |||
Rarely | 1 | |||
Often | 2 | |||
drinker | Summary variable of number of units drank | Numeric | ||
Never | 0 | |||
<8 drinks/week | 1 | |||
8-22 drinks/week | 2 | |||
22+ drinks/week | 3 | |||
pacat | Physical activity rating | Numeric | ||
Low | 0 | |||
Moderate | 1 | |||
High | 2 | |||
pawho | Whether met the WHO recommendation for physical activity | Numeric | ||
Not met WHO recom | 0 | |||
Met WHO recom | 1 | |||
mopho_mode | Whether household owns a mobile phone (household mode) | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Refused/NA | 8 | |||
Unknown | 9 | |||
hhpossscore_mode | 10 quantiles of possvalue | Open ended | Numeric | |
diabp | Diagnosed high bloood persure | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Refused/NA | 8 | |||
Unknown | 9 | |||
remdbp | Medication for high bloood persure | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Unknown | 8 | |||
bphct | Hydrochlorthiazide | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Unknown | 8 | |||
diadiab | Diagnosed diabetes | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Refused/NA | 8 | |||
Unknown | 9 | |||
remddiab | Do you take medication for diabetes? | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Refused/NA | 8 | |||
Unknown | 9 | |||
systolic | Systolic blood pressure (average) | Open ended | double | |
diastolic | Diastolic blood pressure (average) | Open ended | double | |
ht | Hypertensive level (4 categories) | Numeric | ||
No | 0 | |||
mild: dia90+sys140+ | 1 | |||
moderate: dia100+sys160+ | 2 | |||
Severe: dia110+sys180+ | 3 | |||
hypertension | Hypertensive level (2 categories) | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Refused/NA | 8 | |||
Unknown | 9 | |||
weight | Weight (average) | Open ended | double | |
height | Height (average) | Open ended | double | |
BMI | Body mass index (excluding pregnant women) | Open ended | double | |
BMIgroup | Categorised BMI | Open ended | Numeric | |
glucunits_fast | Result of fasted glucose test | Open ended | double | |
glucunits_NONfast | Result of non-fasted glucose test | Open ended | double | |
glucunits_2hr | 3 gluc_units | Open ended | double | |
diabetes | Binary diabetes variable using glucose level and self-report | Numeric | ||
No | 0 | |||
Yes | 1 | |||
Unknown | 8 | |||
fastgluc | Categorised variable of impaired glucose | Numeric | ||
not impaired | 0 | |||
Slightly impaired 5.6-7 | 1 | |||
Impaired 7+ | 2 | |||
creat_testdate | Creatine Test date | Open ended | long | |
creat_units | Creatine Units | Open ended | double | |
hivstatus | HIV result | Numeric | ||
Unknown | -1 | |||
Negative | 0 | |||
Positive | 1 | |||
sex | Sex | Numeric | ||
Male | 1 | |||
Female | 2 | |||
Unknown | 8 | |||
site | Study Site ID | Numeric | ||
Karonga | 1 | |||
Lilongwe | 2 |