Summary Matrix of Calculated Variables (CV) in the 2011 Data File
| Description or Result of Calculation |
Input Variables (From Questionnaire) |
Description of Field and SAS Variable Name |
Output Variables (In Final Data Set) |
|---|---|---|---|
| Section 1: Health Status | |||
| CV for fair or poor general health | GENHLTH | _RFHLTH | |
| Section 4: Hypertension Awareness | |||
| CV for High Blood Pressure | BPHIGH4 | _RFHYPE5 | |
| Section 5: Cholesterol Awareness | |||
| Three level categorization for cholesterol checked within past five years | BLOODCHO, CHOLCHK | _CHOLCHK | |
| CV for ever having had cholesterol checked and told it was high | BLOODCHO, TOLDHI2 | _RFCHOL | |
| Section 6: Chronic Health Conditions | |||
| CV for lifetime asthma prevalence | ASTHMA3 | _LTASTH1 | |
| CV for current asthma prevalence | ASTHMA3, ASTHNOW | _CASTHM1 | |
| Computed asthma status | ASTHMA3, ASTHNOW | _ASTHMS1 | |
| Section 7: Tobacco Use | |||
| Smoking Status: Everyday smoker, someday smoker, former smoker and non smoker | SMOKE100, SMOKDAY2 | _SMOKER3 | |
| CV for current smoking status | SMOKE100, SMOKDAY2 | _SMOKER3 | _RFSMOK3 |
| Section 8: Demographics | |||
| Reported MRACE with trailing 7,8,9’s removed | MRACE | MRACEORG | |
| Reported MRACE with trailing 7,8,9’s removed in ascending order | MRACE | MRACEORG | MRACEASC |
| Preferred Race | MRACE, ORACE2 | MRACEORG, MRACEASC | _PRACE |
| Multiracial Race categorization | MRACE | MRACEORG, MRACEASC | _MRACE |
| Race/Hispanic ethnicity combination code | MRACE, HISPANC2 | MRACEORG, MRACEASC, _MRACE | RACE2 |
| White, non-Hispanic and non-White or Hispanic race/ethnicity groupings. | MRACE, HISPANC2 | MRACEORG, MRACEASC, _MRACE, RACE2 | _RACEG2 |
| Hispanic and non-Hispanic White, Black, and Other race/ethnicity groupings. | MRACE, HISPANC2 | MRACEORG, MRACEASC, _MRACE, RACE2 | _RACEGR2 |
| Hispanic and non-Hispanic White, Black, and Other race/ethnicity groupings. | MRACE, HISPANC2 | MRACEORG, MRACEASC, _MRACE, RACE2, _RACEGR2 | _RACE_G |
| Number of Census Race Categories Chosen | MRACE | MRACEORG, MRACEASC | _CNRACE |
| Number of Census Race Categories Chosen, Collapsed | MRACE | MRACEORG, MRACEASC, _CNRACE | _CNRACEC |
| 18-24 and then 5-year age groupings to 80+. | AGE | _AGEG5YR | |
| 18-64 and 65+ age groupings. | AGE | _AGE65YR | |
| 18-64 and 65+ 10 year age groupings. | AGE | _IMPAGE | _AGE_G |
| Calculated Body Mass Index | SEX, WEIGHT2, HEIGHT3 | HTIN4, HTM4, WTKG3 | _BMI5 |
| Four level weight variable (normal, overweight, obese) based on Body Mass Index | SEX, WEIGHT2, HEIGHT3 | HTIN4, HTM4, WTKG3, _BMI5 | _BMI5CAT |
| Calculated number of children in household | CHILDREN | _CHLDCNT | |
| Calculated education level completed | EDUCA | _EDUCAG | |
| Calculated income categories | INCOME2 | _INCOMG | |
| Section 9: Fruits & Vegetables | |||
| Fruit juice servings per day | FRUITJU1 | FTJUDA1_ | |
| Fruit servings per day | FRUIT1 | FRUTDA1_ | |
| Bean servgins per day | FVBEANS | BEANDAY_ | |
| Dark green vegetable servings per day | FVGREEN | GRENDAY_ | |
| Orange-colored vegetable servings per day | FVORANG | ORNGDAY_ | |
| Vegetable servings per day | VEGETAB1 | VEGEDA1_ | |
| The number of missing fruit responses | FRUITJU1, FRUIT1 | FTJUDA1_, FRUTDA1_ | _MISFRTN |
| The number of missing vegetable responses | VEGETAB1, FVGREEN, FVORANG, FVBEANS | GRENDAY_, ORNGDAY_ , BEANDAY_ , VEGEDA1_ | _MISVEGN |
| Missing any fruit responses | FRUITJU1, FRUIT1 | FTJUDA1_, FRUTDA1_, _MISFRTN | _FRTRESP |
| Missing any vegetable responses | VEGETAB1, FVGREEN, FVORANG, FVBEANS | GRENDAY_, ORNGDAY_ , BEANDAY_ , VEGEDA1_, _MISVEGN | _VEGRESP |
| Total fruits consumed per day | FRUITJU1, FRUIT1 | FTJUDA1_, FRUTDA1_ | _FRUTSUM |
| Total vegetables consumed per day | VEGETAB1, FVGREEN, FVORANG, FVBEANS | GRENDAY_, ORNGDAY_ , BEANDAY_ , VEGEDA1_ | _VEGESUM |
| Reported consuming Fruit >16/day | FRUITJU1, FRUIT1 | FTJUDA1_, FRUTDA1_, _FRUTSUM | _FRT16 |
| Reported consuming Vegetables >23/day | VEGETAB1, FVGREEN, FVORANG, FVBEANS | _VEGESUM | _VEG23 |
| Fruit Exclusion from analyses | FRUITJU1, FRUIT1 | FTJUDA1_, FRUTDA1_, _MISFRTN, _FRTRESP | _FRUITEX |
| Vegetable Exclusion from analyses | VEGETAB1, FVGREEN, FVORANG, FVBEANS | GRENDAY_, ORNGDAY_ , BEANDAY_ , VEGEDA1_, _MISVEGN, _VEGESUM, _VEGRESP, _VEG23 | _VEGETEX |
| Section 10: Exercise (Physical Activity) | |||
| CV for no leisure time physical activity | EXERANY2 | _TOTINDA | |
| Activity MET Value for First Activity | EXRACT01 | METVAL1_ | |
| Activity MET Value for Second Activity | EXRACT02 | METVAL2_ | |
| Estimated Age-Gender Specific Maximum Oxygen Consumption | SEX, AGE | MAXVO2_ | |
| Estimated Activity Intensity for First Activity | EXRACT01, SEX, AGE | METVAL1_, FC60_ | ACTINT1_ |
| Estimated Activity Intensity for Second Activity | EXRACT02, SEX, AGE | METVAL2_, FC60_ | ACTINT2_ |
| Minutes of First Activity | EXERHMM1 | PADUR1_ | |
| Minutes of Second Activity | EXERHMM2 | PADUR2_ | |
| Physical Activity Frequency per Week for First Activity | EXERANY2, EXEROFT1 | PAFREQ1_ | |
| Physical Activity Frequency per Week for Second Activity | EXERANY2, EXEROFT2 | PAFREQ2_ | |
| Minutes of Physical Acitivity per week for First Activity | EXRACT01, SEX, AGE, EXERHMM1, EXERANY2, EXEROFT1 | PADUR1_, PAFREQ1_, ACTINT1_ | _MINACT1 |
| Minutes of Physical Acitivity per week for Second Activity | EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | PADUR2_, PAFREQ2_, ACTINT2_ | _MINACT2 |
| Strength Activity Frequency per Week | STRENGTH | STRFREQ_ | |
| Missing Physical Activity Data | EXERANY2, EXRACT01, SEX, AGE, EXRACT02, EXERHMM1, EXEROFT1, EXERHMM2, EXEROFT2 | ACTINT1_, _MINACT1, ACTINT2_, _MINACT2 | PAMISS_ |
| Minutes of Physical Acitivity per week for First Activity | EXRACT01, SEX, AGE, EXERHMM1, EXERANY2, EXEROFT1 | ACTINT1_, _MINACT1 | PAMIN1_ |
| Minutes of Physical Acitivity per week for Second Activity | EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | ACTINT2_, _MINACT2 | PAMIN2_ |
| Minutes of total Physical Acitivity per week | EXRACT01, SEX, AGE, EXERHMM1, EXERANY2, EXEROFT1, EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | PAMIN1_, PAMIN2_ | PAMIN_ |
| Minutes of Vigorous Physical Acitivity per week for First Activity | EXRACT01, SEX, AGE, EXERHMM1, EXERANY2, EXEROFT1 | ACTINT1_, _MINACT1 | PAVIGM1_ |
| Minutes of Vigorous Physical Acitivity per week for Second Activity | EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | ACTINT2_, _MINACT2 | PAVIGM2_ |
| Minutes of total Vigorous Physical Acitivity per week | EXRACT01, SEX, AGE, EXERHMM1, EXERANY2, EXEROFT1, EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | PAVIGM1_, PAVIGM2_ | PAVIGMN_ |
| Physical Activity Categories | EXERANY2, EXRACT01, SEX, AGE, EXERHMM1, EXEROFT1, EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | PAMIN_, PAVIGMN_ | _PACAT |
| Physical Activity Index | EXERANY2, EXRACT01, SEX, AGE, EXERHMM1, EXEROFT1, EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | PAMIN_ | _PAINDEX |
| 150 Minute Physical Activity Calculated Variable | EXERANY2, EXRACT01, SEX, AGE, EXERHMM1, EXEROFT1, EXRACT02, SEX, AGE, EXERHMM2, EXERANY2, EXEROFT2 | PAMIN_, PAVIGMN_ | _PA150R1 |
| 300 Minute Physical Activity Calculated Variable | EXERANY2, EXRACT01, SEX, AGE, EXRACT02, EXERHMM1, EXEROFT1, EXERHMM2, EXEROFT2 | PAMISS_, PAMIN_ | _PA300R1 |
| 300 Minute Physical Activity 2-Level Calculated Variable | EXERANY2, EXRACT01, SEX, AGE, EXRACT02, EXERHMM1, EXEROFT1, EXERHMM2, EXEROFT2 | _PA300R1 | _PA3002L |
| Muscle Strengthening Reccomendation | STRENGTH | STRFREQ_ | _PASTRNG |
| Aerobic and Strengthening Guideline | STRENGTH | _PASTRNG, _PAINDEX | _PAREC |
| Aerobic and Strengthening (2-level) | STRENGTH | _PAREC | _PASTAER |
| Section 13: Seatbelt Use | |||
| CV for Always/Nearly Always wear seatbelt | SEATBELT | _RFSEAT2 | |
| CV for Alwayswear seatbelt | SEATBELT | _RFSEAT3 | |
| Section 14: Immunization | |||
| CV for respondents aged 65 and older that have had a flu shot within the past year | FLUSHOT5 | _FLSHOT5 | |
| CV for respondent aged 65 and older that have ever had a pneumonia vaccine | PNEUVAC3 | _PNEUMO2 | |
| Section 15: Alcohol Consumption | |||
| Drink alcoholic beverages in past 30 days (Y/N) | ALCDAY5 | DRNKANY5 | |
| Drink occasions per day | ALCDAY5 | DROCDY3_ | |
| CV for BINGE drinking (males GE 5 drinks on an occasion, females GE 4 drinks on an occasion) | ALCDAY5, DRNK3GE5 | _RFBING5 | |
| Number of Drinks of Alcohol per day | ALCDAY5, AVEDRNK | DROCDY3_ | _DRNKDY4 |
| Number of Drinks of Alcohol per month | ALCDAY5, AVEDRNK | DROCDY3_, _DRNKDY4 | _DRNKMO4 |
| CV for HEAVY drinking (GT 2 drinks per day for men, GT 1 drink per day for women) | SEX, ALCDAY5, AVEDRNK | _DRNKDY4 | _RFDRHV4 |
| CV for HEAVY drinking in men (GT 2 drinks per day) | SEX, ALCDAY5, AVEDRNK | _DRNKDY4 | _RFDRMN4 |
| CV for HEAVY drinking in women (GT 1 drink per day) | SEX, ALCDAY5, AVEDRNK | _DRNKDY4 | _RFDRWM4 |
Page last reviewed: July 23, 2013