Skip directly to search Skip directly to A to Z list Skip directly to page options Skip directly to site content

Summary Matrix of Calculated Variables (CV) in the 2007 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 healthGENHLTH _RFHLTH
Section 3: Health Care Access
CV for respondents aged 18-64 years that have any form of health care coverageHLTHPLAN _HCVU65
Section 4: Exercise
CV for no leisure time physical activityEXERANY2 _TOTINDA
Section 6: Hypertension Awareness
CV for High Blood PressureBPHIGH4 _RFHYPE5
Section 7: Cholesterol Awareness
Three level categorization for cholesterol checked within past five yearsBLOODCHO, CHOLCHK _CHOLCHK
CV for ever having had cholesterol checked and told it was highBLOODCHO, TOLDHI2 _RFCHOL
Section 9: Asthma
CV for lifetime asthma prevalenceASTHMA2 _LTASTHM
CV for current asthma prevalenceASTHMA2, ASTHNOW _CASTHMA
Computed asthma statusASTHMA2, ASTHNOW _ASTHMST
Section 10: Immunization
CV for respondents aged 65 and older that have had a flu shot within the past yearFLUSHOT3 _FLSHOT3
CV for respondent aged 65 and older that have ever had a pneumonia vaccinePNEUVAC3 _PNEUMO2
Section 11: Tobacco Use
Smoking Status: Everyday smoker, someday smoker, former smoker and non smokerSMOKE100, SMOKDAY2 _SMOKER3
CV for current smoking statusSMOKE100, SMOKDAY2_SMOKER3_RFSMOK3
Section 12: Demographics
Reported MRACE with trailing 7,8,9’s removedMRACE MRACEORG
Reported MRACE with trailing 7,8,9’s removed in ascending orderMRACEMRACEORGMRACEASC
Preferred RaceMRACE, ORACE2MRACEORG, MRACEASC_PRACE
Multiracial Race categorizationMRACEMRACEORG, MRACEASC_MRACE
White, non-Hispanic and non-White or Hispanic race/ethnicity groupings.MRACE, HISPANC2MRACEORG, MRACEASC, _MRACE, RACE2_RACEG2
Hispanic and non-Hispanic White, Black, and Other race/ethnicity groupings.MRACE, HISPANC2MRACEORG, MRACEASC, _MRACE, RACE2_RACEGR2
Hispanic and non-Hispanic White, Black, and Other race/ethnicity groupings.MRACE, HISPANC2MRACEORG, MRACEASC, _MRACE, RACE2, _RACEGR2_RACE_G
Number of Census Race Categories ChosenMRACEMRACEORG, MRACEASC_CNRACE
Number of Census Race Categories Chosen, CollapsedMRACEMRACEORG, MRACEASC, _CNRACE_CNRACEC
Race/Hispanic ethnicity combination codeMRACE, HISPANC2MRACEORG, MRACEASC, _MRACERACE2
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
Height in inchesHEIGHT3 HTIN3
Calculated height in metersHEIGHT3HTIN3HTM3
Calculated weight in kilogramsWEIGHT2 WTKG2
Calculated Body Mass IndexSEX, WEIGHT2, HEIGHT3HTIN3, HTM3, WTKG2_BMI4
Tri-level weight variable (normal, overweight, obese) based on Body Mass IndexSEX, WEIGHT2, HEIGHT3HTIN3, HTM3, WTKG2, _BMI4_BMI4CAT
CV for Overweight or Obese Body Mass Index levelSEX, WEIGHT2, HEIGHT3HTIN3, HTM3, WTKG2, _BMI4_RFBMI4
Calculated number of children in householdCHILDREN _CHLDCNT
Calculated education level completedEDUCA _EDUCAG
Calculated income categoriesINCOME2 _INCOMG
Section 13: Alcohol Consumption
Drink occasions per dayALCDAY4 DROCDY2_
CV for BINGE drinking (GE 5 drinks on an occasion)ALCDAY4, DRNK3GE5 _RFBING4
Number of Drinks of Alcohol per dayALCDAY4, AVEDRNKDROCDY2__DRNKDY3
Number of Drinks of Alcohol per monthALCDAY4, AVEDRNKDROCDY2_, _DRNKDY3_DRNKMO3
CV for HEAVY drinking (GT 2 drinks per day for men, GT 1 drink per day for women)SEX, ALCDAY4, AVEDRNK_DRNKDY3_RFDRHV3
CV for HEAVY drinking in men (GT 2 drinks per day)SEX, ALCDAY4, AVEDRNK_DRNKDY3_RFDRMN3
CV for HEAVY drinking in women (GT 1 drink per day)SEX, ALCDAY4, AVEDRNK_DRNKDY3_RFDRWM3
Section 15: Arthritis Burden
CV for respondents that have had a doctor diagnose them as having some form of arthritisHAVARTH2 _DRDXART
Section 16: Fruits & Vegetables
Fruit juice servings per dayFRUITJUI FTJUDAY_
Fruit servings per dayFRUIT FRUTDAY_
Green salad servings per dayGREENSAL GNSLDAY_
Potato servings per dayPOTATOES POTADAY_
Carrot servings per dayCARROTS CRTSDAY_
Vegetable servings per dayVEGETABL VEGEDAY_
Calculated servings of fruits & vegetablesFRUITJUI, FRUIT, GREENSAL, POTATOES, CARROTS, VEGETABLFTJUDAY_, FRUTDAY_, GNSLDAY_, POTADAY_, CRTSDAY_, VEGEDAY__FRTSERV
Summary index of daily servings fruits and vegetablesFRUITJUI, FRUIT, GREENSAL, POTATOES, CARROTS, VEGETABL_FRTSERV_FRTINDX
Consume five or more servings or fruits or vegetables per dayFRUITJUI, FRUIT, GREENSAL, POTATOES, CARROTS, VEGETABL_FRTSERV_FV5SRV
Section 17: Physical Activity
Minutes of Moderate Physical ActivityMODPATIM _MODPAMN
Minutes of Vigorous Physical ActivityVIGPATIM _VIGPAMN
Meet Moderate RecommendationsMODPACT, MODPATIM, MODPADAY_MODPAMNMODCAT_
Meet Vigorous RecommendationsVIGPACT, VIGPATIM, VIGPADAY_VIGPAMNVIGCAT_
Meet Moderate and Vigorous RecommendationsMODPACT, MODPATIM, MODPADAY, VIGPACT, VIGPATIM, VIGPADAYMODCAT_, VIGCAT_PACAT_
CV for Moderate Physical ActivityMODPACT, MODPATIM, MODPADAY, VIGPACT, VIGPATIM, VIGPADAYPACAT__RFPAMOD
CV for Vigorous Physical ActivityVIGPACT, VIGPATIM, VIGPADAYVIGCAT__RFPAVIG
CV for Recommended Physical ActivityMODPACT, MODPATIM, MODPADAY, VIGPACT, VIGPATIM, VIGPADAYPACAT__RFPAREC
CV for no leisure time exercise or physical activityEXERANY2, MODPACT, MODPATIM, MODPADAY, VIGPACT, VIGPATIM, VIGPADAY_RFPAREC_RFNOPA
Section 18: HIV/AIDS
CV for age 18-64 that have ever been tested for HIVHIVTST4, AGE _AIDTST2
Top