* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Title: BMI Derivations for CCHS 2003 (Cycle 2.1) * Authors: Harleen Sahota and Shanna Hoetmer * Creation Date: January 2009 * Revision Date: June 2009 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *1) Calculate BMI so that it includes ages 12-17 COMPUTE bmi_calc = hwtcdwtk/(hwtcdhtm * hwtcdhtm) . EXECUTE . COMPUTE bmi_calc = bmi_calc*100. COMPUTE bmi_calc = RND(bmi_calc) . COMPUTE bmi_calc = bmi_calc/100. FORMAT bmi_calc (f4.2). EXECUTE . IF (hwtcdhtm = 9.999 | hwtcdwtk = 999.99) bmi_calc = 999 . IF (hwtcdhtm=2.134) bmi_calc = 999 . IF (mamc_037 = 1) bmi_calc = 996 . EXECUTE . VARIABLE LABEL bmi_calc 'Body Mass Index (calculated)'. VALUE LABEL bmi_calc 996 "Not Applicable" 999 "Not Stated". *2) ADOLESCENT BMI *a) Create new variables for age in months (age_mo) and age in years rounded to nearest 0.5 years (rnd_Age_yrs) COMPUTE int_date = DATE.DMY(admc_doi, admc_moi, admc_yoi) . VARIABLE LABELS int_date 'Interview Date (computed)' . EXECUTE . RECODE dhhc_dob dhhc_mob dhhc_yob (97=SYSMIS) (98=SYSMIS) (99=SYSMIS) (9997=SYSMIS) (9998=SYSMIS) (9999=SYSMIS). EXECUTE. COMPUTE DOB = DATE.DMY(dhhc_dob, dhhc_mob, dhhc_yob) . VARIABLE LABELS DOB 'Date of Birth (computed)' . EXECUTE . COMPUTE age_mo = DATEDIFF(int_date, DOB, "months") . VARIABLE LABELS age_mo 'Age in Months (computed)' . EXECUTE . IF (age_mo < 9996) age_yrs = age_mo / 12 . VARIABLE LABELS age_yrs 'Age in Years (computed)' . EXECUTE . COMPUTE rnd_Age_yrs= RND(age_yrs /.5) * .5. VARIABLE LABELS rnd_Age_yrs 'Rounded Age in Years (computed)' . EXECUTE . RECODE rnd_Age_yrs (SYSMIS=999) (ELSE=Copy) . EXECUTE. *b) Create new variable called bmi_adol IF (dhhc_age < 18) bmi_adol = 1. IF (dhhc_age < 18 & rnd_Age_yrs = 999) bmi_adol = 9. EXECUTE. *i) Pull out the people in the Obese category If ((rnd_Age_yrs = 12 and DHHc_SEX = 1 and bmi_calc >= 26.02) or (rnd_Age_yrs = 12 and DHHc_SEX = 2 and bmi_calc >= 26.67) or (rnd_Age_yrs = 12.5 and DHHc_SEX = 1 and bmi_calc >= 26.43) or (rnd_Age_yrs = 12.5 and DHHc_SEX = 2 and bmi_calc >= 27.24) or (rnd_Age_yrs = 13 and DHHc_SEX = 1 and bmi_calc >= 26.84) or (rnd_Age_yrs = 13 and DHHc_SEX = 2 and bmi_calc >= 27.76) or (rnd_Age_yrs = 13.5 and DHHc_SEX = 1 and bmi_calc >= 27.25) or (rnd_Age_yrs = 13.5 and DHHc_SEX = 2 and bmi_calc >= 28.20) or (rnd_Age_yrs = 14 and DHHc_SEX = 1 and bmi_calc >= 27.63) or (rnd_Age_yrs = 14 and DHHc_SEX = 2 and bmi_calc >= 28.57) or (rnd_Age_yrs = 14.5 and DHHc_SEX = 1 and bmi_calc >= 27.98) or (rnd_Age_yrs = 14.5 and DHHc_SEX = 2 and bmi_calc >= 28.87) or (rnd_Age_yrs = 15 and DHHc_SEX = 1 and bmi_calc >= 28.30) or (rnd_Age_yrs = 15 and DHHc_SEX = 2 and bmi_calc >= 29.11) or (rnd_Age_yrs = 15.5 and DHHc_SEX = 1 and bmi_calc >= 28.60) or (rnd_Age_yrs = 15.5 and DHHc_SEX = 2 and bmi_calc >= 29.29) or (rnd_Age_yrs = 16 and DHHc_SEX = 1 and bmi_calc >= 28.88) or (rnd_Age_yrs = 16 and DHHc_SEX = 2 and bmi_calc >= 29.43) or (rnd_Age_yrs = 16.5 and DHHc_SEX = 1 and bmi_calc >= 29.14) or (rnd_Age_yrs = 16.5 and DHHc_SEX = 2 and bmi_calc >= 29.56) or (rnd_Age_yrs = 17 and DHHc_SEX = 1 and bmi_calc >= 29.41) or (rnd_Age_yrs = 17 and DHHc_SEX = 2 and bmi_calc >= 29.69) or (rnd_Age_yrs = 17.5 and DHHc_SEX = 1 and bmi_calc >= 29.70) or (rnd_Age_yrs = 17.5 and DHHc_SEX = 2 and bmi_calc >= 29.84) or (rnd_Age_yrs = 18 and DHHc_SEX = 1 and bmi_calc >= 30.00) or (rnd_Age_yrs = 18 and DHHc_SEX = 2 and bmi_calc >= 30.00)) bmi_adol =3. EXECUTE . *ii) Pull out the people in the Overweight category If ((rnd_Age_yrs = 12 and DHHc_SEX = 1 and (bmi_calc>=21.22 and bmi_calc < 26.02)) or (rnd_Age_yrs = 12 and DHHc_SEX = 2 and (bmi_calc>=21.68 and bmi_calc < 26.67)) or (rnd_Age_yrs = 12.5 and DHHc_SEX = 1 and (bmi_calc>=21.56 and bmi_calc < 26.43)) or (rnd_Age_yrs = 12.5 and DHHc_SEX = 2 and (bmi_calc>=22.14 and bmi_calc < 27.24)) or (rnd_Age_yrs = 13 and DHHc_SEX = 1 and (bmi_calc>=21.91 and bmi_calc < 26.84)) or (rnd_Age_yrs = 13 and DHHc_SEX = 2 and (bmi_calc>=22.58 and bmi_calc < 27.76)) or (rnd_Age_yrs = 13.5 and DHHc_SEX = 1 and (bmi_calc>=22.27 and bmi_calc < 27.25)) or (rnd_Age_yrs = 13.5 and DHHc_SEX = 2 and (bmi_calc>=22.98 and bmi_calc < 28.20)) or (rnd_Age_yrs = 14 and DHHc_SEX = 1 and (bmi_calc>=22.62 and bmi_calc < 27.63)) or (rnd_Age_yrs = 14 and DHHc_SEX = 2 and (bmi_calc>=23.34 and bmi_calc < 28.57)) or (rnd_Age_yrs = 14.5 and DHHc_SEX = 1 and (bmi_calc>=22.96 and bmi_calc < 27.98)) or (rnd_Age_yrs = 14.5 and DHHc_SEX = 2 and (bmi_calc>=23.66 and bmi_calc < 28.87)) or (rnd_Age_yrs = 15 and DHHc_SEX = 1 and (bmi_calc>=23.29 and bmi_calc < 28.30)) or (rnd_Age_yrs = 15 and DHHc_SEX = 2 and (bmi_calc>=23.94 and bmi_calc < 29.11)) or (rnd_Age_yrs = 15.5 and DHHc_SEX = 1 and (bmi_calc>=23.60 and bmi_calc < 28.60)) or (rnd_Age_yrs = 15.5 and DHHc_SEX = 2 and (bmi_calc>=24.17 and bmi_calc < 29.29)) or (rnd_Age_yrs = 16 and DHHc_SEX = 1 and (bmi_calc>=23.90 and bmi_calc < 28.88)) or (rnd_Age_yrs = 16 and DHHc_SEX = 2 and (bmi_calc>=24.37 and bmi_calc < 29.43)) or (rnd_Age_yrs = 16.5 and DHHc_SEX = 1 and (bmi_calc>=24.19 and bmi_calc < 29.14)) or (rnd_Age_yrs = 16.5 and DHHc_SEX = 2 and (bmi_calc>=24.54 and bmi_calc < 29.56)) or (rnd_Age_yrs = 17 and DHHc_SEX = 1 and (bmi_calc>=24.46 and bmi_calc < 29.41)) or (rnd_Age_yrs = 17 and DHHc_SEX = 2 and (bmi_calc>=24.70 and bmi_calc < 29.69)) or (rnd_Age_yrs = 17.5 and DHHc_SEX = 1 and (bmi_calc>=24.73 and bmi_calc < 29.70)) or (rnd_Age_yrs = 17.5 and DHHc_SEX = 2 and (bmi_calc>=24.85 and bmi_calc < 29.84)) or (rnd_Age_yrs = 18 and DHHc_SEX = 1 and (bmi_calc>=25.00 and bmi_calc < 30.00)) or (rnd_Age_yrs = 18 and DHHc_SEX = 2 and (bmi_calc>=25.00 and bmi_calc < 30.00))) bmi_adol =2. EXECUTE . *iii) Add to NA and NS Categories IF (dhhc_age < 18 & mamc_037 = 1) bmi_adol = 6 . IF (dhhc_age < 18 & (mamc_037 = 7 | mamc_037 = 8 | mamc_037 = 9)) bmi_adol = 9 . EXECUTE . IF (dhhc_age < 18 & (hwtcdhtm = 9.997 | hwtcdhtm = 9.998 | hwtcdhtm = 9.999)) bmi_adol = 9 . IF (dhhc_age < 18 & (hwtcdwtk = 999.97 | hwtcdwtk = 999.98 | hwtcdwtk = 999.99)) bmi_adol = 9 . IF (dhhc_age < 18 & hwtcdhtm=2.134) bmi_adol = 9 . EXECUTE . IF (dhhc_age >= 18) bmi_adol = 6. EXECUTE . VARIABLE LABEL bmi_adol 'Adolescent Body Mass Index Categories'. VALUE LABEL bmi_adol 1 "Neither overweight nor obese" 2 "Overweight" 3 "Obese" 6 "Not Applicable" 9 "Not Stated" . FORMAT bmi_adol (f1.0) . ***NOTE THAT FOR THE CORE INDICATOR, BREASTFEEDING WOMEN SHOULD BE EXCLUDED (mexc_05 = 1)*** *3) ADULT BMI IF (dhhc_age >= 18 & bmi_calc < 18.5) bmi_adult = 1 . IF (dhhc_age >= 18 & bmi_calc >= 18.5 & bmi_calc < 25.0) bmi_adult = 2 . IF (dhhc_age >= 18 & bmi_calc >= 25.0 & bmi_calc < 30.0) bmi_adult = 3 . IF (dhhc_age >= 18 & bmi_calc >= 30.0 & bmi_calc < 35.0) bmi_adult = 4 . IF (dhhc_age >= 18 & bmi_calc >= 35.0 & bmi_calc < 40.0) bmi_adult = 5 . IF (dhhc_age >= 18 & bmi_calc >= 40) bmi_adult = 6 . IF (bmi_calc = 999) bmi_adult = 999 . IF (bmi_calc = 996) bmi_adult = 996 . IF (dhhc_age < 18) bmi_adult = 996 . EXECUTE . IF (dhhc_age >= 18 & (mamc_037 = 7 | mamc_037 = 8 | mamc_037 = 9)) bmi_adult = 999 . EXECUTE . VARIABLE LABEL bmi_adult 'Adult Body Mass Index Categories'. VALUE LABEL bmi_adult 1 "Underweight (<18.5)" 2 "Normal weight (18.5-24.9)" 3 "Overweight (25-29.9)" 4 "Obese - Class I (30-34.9)" 5 "Obese - Class II (35-39.9)" 6 "Obese - Class III (>=40.0)" 996 "Not Applicable" 999 "Not Stated". FORMAT bmi_adult (f2.0). ***NOTE THAT FOR THE CORE INDICATOR, BREASTFEEDING WOMEN SHOULD BE EXCLUDED (mexc_05 = 1)***