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_exercise_daily_avg()
Average daily minutes of moderate-to-vigorous physical activity (MVPA) from accelerometer data
calculate_exercise_weekly()
Weekly minutes of moderate-to-vigorous physical activity (MVPA) from daily average
calculate_fv_daily_cycles1to2()
Daily fruit and vegetable consumption in a year - cycles 1-2
calculate_fv_daily_cycles3to6()
Daily fruit and vegetable consumption in a year - cycles 3-6
calculate_gfr()
Estimated glomerular filtration rate (GFR)
calculate_household_income()
Adjusted total household income
calculate_nonhdl()
Non-HDL cholesterol level
calculate_pack_years()
Smoking pack-years
calculate_waist_height_ratio()
Waist-to-height ratio (WHtR)
categorize_ckd()
Chronic kidney disease (CKD) derived variable
categorize_diet_quality()
Categorical diet indicator
categorize_exercise()
Categorical weekly moderate-to-vigorous physical activity (MVPA) indicator
categorize_income_quintile()
Categorical adjusted household income
categorize_nonhdl()
Categorical non-HDL cholesterol level
derive_alcohol_risk()
Low risk drinking score
derive_alcohol_risk_detailed()
Low risk drinking score - former/never categories
derive_cvd_family_history()
Cardiovascular Disease (CVD) family history
derive_cvd_personal_history()
Cardiovascular disease (CVD) personal history
derive_diabetes_status()
Diabetes derived variable
derive_hypertension()
Hypertension derived variable
derive_hypertension_adj()
Hypertension derived variable with adjusted blood pressures
derive_hypertension_control()
Controlled hypertension derived variable
derive_hypertension_control_adj()
Controlled hypertension derived variable with adjusted blood pressures
is_ace_inhibitor()
ACE inhibitors
is_ace_med_cycles1to2()
ACE inhibitors - cycles 1-2
is_any_antihtn_med()
Any anti-hypertensive medications
is_any_htn_med_cycles1to2()
Any anti-hypertensive medications - cycles 1-2
is_bb_med_cycles1to2()
Beta blockers - cycles 1-2
is_beta_blocker()
Beta blockers
is_calcium_channel_blocker()
Calcium channel blockers
is_ccb_med_cycles1to2()
Calcium channel blockers - cycles 1-2
is_diabetes_med()
Diabetes medications
is_diab_med_cycles1to2()
Diabetes medications - cycles 1-2
is_diuretic()
Diuretics
is_diur_med_cycles1to2()
Diuretics - cycles 1-2
is_lowest_income_quintile()
Lowest income quintile indicator
is_misc_htn_med_cycles1to2()
Other anti-hypertensive medications - cycles 1-2
is_nsaid()
Non-steroidal anti-inflammatory drugs (NSAIDs)
is_nsaid_med_cycles1to2()
Non-steroidal anti-inflammatory drugs (NSAIDs) - cycles 1-2
is_other_antihtn_med()
Other anti-hypertensive medications

Medication recoding functions

Functions for recoding and aggregating CHMS medication variables

recode_meds_cycles1to2()
Recode medication variables for cycles 1-2 (wide format)
recode_meds_cycles3to6()
Recode medication variables for cycles 3-6 (long format)
aggregate_meds_by_person()
Aggregate medication variables to one row per person
recode_after_meds()
Recode variables that depend on derived medication variable inputs

CHMS dummy data

Cycle and medication dummy data for select CHMS cycles

cycle1
Canadian Health Measures Survey (CHMS) Cycle 1
cycle1_meds
Canadian Health Measures Survey (CHMS) Cycle 1 Medications
cycle2
Canadian Health Measures Survey (CHMS) Cycle 2
cycle2_meds
Canadian Health Measures Survey (CHMS) Cycle 2 Medications
cycle3
Canadian Health Measures Survey (CHMS) Cycle 3
cycle3_meds
Canadian Health Measures Survey (CHMS) Cycle 3 Medications
cycle4
Canadian Health Measures Survey (CHMS) Cycle 4
cycle4_meds
Canadian Health Measures Survey (CHMS) Cycle 4 Medications
cycle5
Canadian Health Measures Survey (CHMS) Cycle 5
cycle5_meds
Canadian Health Measures Survey (CHMS) Cycle 5 Medications
cycle6
Canadian Health Measures Survey (CHMS) Cycle 6
cycle6_meds
Canadian Health Measures Survey (CHMS) Cycle 6 Medications