Dataset for: Prevalence of impaired renal function in Malawi - Codebook

Permanent Identifier:

https://doi.org/10.17037/DATA.00001150

Data Description

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.

MEIRU GRF dataset codebook

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