Skip to contents

Worksheets

variable and variable_details worksheets

variables
variables.csv
variable_details
variable-details.csv

Derived variable functions

Functions for deriving custom CHMS variables

adjust_DBP()
Adjusted diastolic blood pressure
adjust_SBP()
Adjusted systolic blood pressure
calculate_GFR()
Estimated glomerular filtration rate (GFR)
calculate_hhld_income()
Adjusted total household income
calculate_WHR()
Waist-to-height ratio (WHR)
calculate_nonHDL()
Non-HDL cholesterol level
categorize_GFR_to_CKD()
Chronic kidney disease (CKD) derived variable
categorize_income()
Categorical adjusted household income
categorize_minperweek()
Categorical weekly physical activity indicator
categorize_nonHDL()
Categorical non-HDL cholesterol level
cycles1to2_ace_inhibitors()
ACE inhibitors - cycles 1-2
cycles1to2_any_antiHTN_meds()
Any anti-hypertensive medications - cycles 1-2
cycles1to2_beta_blockers()
Beta blockers - cycles 1-2
cycles1to2_calcium_channel_blockers()
Calcium channel blockers - cycles 1-2
cycles1to2_diabetes_drugs()
Diabetes medications - cycles 1-2
cycles1to2_diuretics()
Diuretics - cycles 1-2
cycles1to2_nsaid()
Non-steroidal anti-inflammatory drugs (NSAIDs) - cycles 1-2
cycles1to2_other_antiHTN_meds()
Other anti-hypertensive medications - cycles 1-2
determine_CVD_family_history()
Cardiovascular Disease (CVD) family history
determine_CVD_personal_history()
Cardiovascular disease (CVD) personal history
determine_adjusted_hypertension()
Hypertension derived variable with adjusted blood pressures
determine_controlled_adjusted_hypertension()
Controlled hypertension derived variable with adjusted blood pressures
determine_controlled_hypertension()
Controlled hypertension derived variable
determine_gooddiet()
Categorical diet indicator
determine_hypertension()
Hypertension derived variable
determine_inclusive_diabetes()
Diabetes derived variable
find_totalFV_cycles1and2()
Daily fruit and vegetable consumption in a year - cycles 1-2
find_totalFV_cycles3to6()
Daily fruit and vegetable consumption in a year - cycles 3-6
find_week_accelerometer_average()
Average minutes of exercise per day for week-long accelerometer data
in_lowest_income_quintile()
Lowest income quintile indicator
is_NSAID()
Non-steroidal anti-inflammatory drugs (NSAIDs)
is_ace_inhibitor()
ACE inhibitors
is_any_antiHTN_med()
Any anti-hypertensive medications
is_beta_blocker()
Beta blockers
is_calcium_channel_blocker()
Calcium channel blockers
is_diabetes_drug()
Diabetes medications
is_diuretic()
Diuretics
is_other_antiHTN_med()
Other anti-hypertensive medications
is_taking_drug_class()
Number of occurrences of a specific drug class based on given conditions
low_drink_score_fun()
Low risk drinking score
low_drink_score_fun1()
Low risk drinking score - former/never categories
minperday_to_minperweek()
Minutes per week from minutes per day
pack_years_fun()
Smoking pack-years

CHMS dummy data

Cycle and medication dummy data for select CHMS cycles

cycle2
CHMS Cycle 2
cycle2_meds
CHMS Cycle 2 Medications
cycle3
CHMS Cycle 3
cycle3_meds
CHMS Cycle 3 Medications
cycle4
CHMS Cycle 4
cycle5
CHMS Cycle 5