***************************************************************************************** * FILE NAME: MMSA05_SASOUT.SAS * * DESCRIPTION: THIS PROGRAM CONVERTS A STATES ASCII DATAFILE OF COMPLETES LOCATED AT * * FILEREF, INTO A SAS DATABASE STORED AT LIBREF * * REFERENCES: * * INPUT DATAIN FILEREF OF ASCII DATAFILE OF COMPLETES * * FORMATS FORMAT05.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 08/20/2006 * *****************************************************************************************; ******************************** * Clear Output and Log Windows * ********************************; DM OUTPUT 'clear' continue; DM LOG 'clear' continue; ********************************** * DEFINE SAS ENVIRONMENT OPTIONS * **********************************; OPTIONS PAGENO=1 NOFMTERR; *************************************** * CLEAR EXISTING TITLES AND FOOTNOTES * ***************************************; TITLE ; FOOTNOTE ; RUN ; ****************************************************************** * INSTRUCTIONS: * * SPECIFY PATH OF WHERE ASCII DATAFILE IS STORED * * SPECIFY PATH OF WHERE SAS DATASET IS TO BE STORED * * SPECIFY PATH OF WHERE SAS FORMAT LIBRARY IS STORED * * SPECIFY PATH OF WHERE THE FORMAT ASSIGNMET STATEMENT IS STORED * ******************************************************************; *FILENAME DATAIN '' LRECL = 639 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2005\MMSA05.ASC' LRECL = 639 * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD FILENAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE FILENAME STATEMENT * *****************************************************************************; *LIBNAME DATAOUT '' ; ***************************************************************************** * EXAMPLE: * * LIBNAME DATAOUT 'C:\' * * A SAS DATABASE WILL BE STORED AT C:\SASDATA.SAS7BDAT * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD LIBNAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE LIBNAME STATEMENT * *****************************************************************************; *LIBNAME LIBRARY '' ; ***************************************************************************** * EXAMPLE: * * LIBNAME LIBRARY 'C:\' * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD LIBNAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE LIBNAME STATEMENT * *****************************************************************************; *FILENAME FORMATIN '' ; ***************************************************************************** * EXAMPLE: * * FILENAME FORMATIN 'C:\FORMATSTATEMENT.SAS' * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD FILENAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE FILENAME STATEMENT * *****************************************************************************; DATA DATAOUT.SASDATA ; INFILE DATAIN MISSOVER ; INPUT FMONTH 1-2 IDATE $3-10 IMONTH $11-12 IDAY $13-14 IYEAR $15-18 INTVID $19-21 DISPCODE 22-24 SEQNO 25-34 _PSU 35-44 NATTMPTS 45-46 CELLFON 47 NUMADULT 48-49 NUMMEN 50-51 NUMWOMEN 52-53 GENHLTH 54 /* Section 1: Health Status */ PHYSHLTH 55-56 /* Section 2: Healthy Days - Health-Related Quality of Life */ MENTHLTH 57-58 POORHLTH 59-60 HLTHPLAN 61 /* Section 3: Health Care Access */ PERSDOC2 62 MEDCOST 63 CHECKUP 64 EXERANY2 65 /* Section 4: Exercise */ DIABETE2 66 /* Section 5: Diabetes */ BPHIGH4 67 /* Section 6: Hypertension Awareness */ BPMEDS 68 BLOODCHO 69 /* Section 7: Cholesterol Awareness */ CHOLCHK 70 TOLDHI2 71 CVDINFR3 72 /* Section 8: Cardiovascular Disease */ CVDCRHD3 73 CVDSTRK3 74 ASTHMA2 75 /* Section 9: Asthma */ ASTHNOW 76 FLUSHOT3 77 /* Section 10: Immunization */ FLUSPRY2 78 PNEUVAC3 79 SMOKE100 80 /* Section 11: Tobacco Use */ SMOKDAY2 81 STOPSMK2 82 DRNKANY4 83 /* Section 12: Alcohol Consumption */ ALCDAY4 84-86 AVEDRNK2 87-88 DRNK2GE5 89-90 MAXDRNKS 91-92 AGE 93-94 /* Section 13: Demographics */ HISPANC2 95 MRACE $96-101 ORACE2 102 MARITAL 103 CHILDREN 104-105 EDUCA 106 EMPLOY 107 INCOME2 108-109 WEIGHT2 110-113 HEIGHT3 114-117 NUMHHOL2 118 NUMPHON2 119 TELSERV2 120 SEX 121 PREGNANT 122 VETERAN 123 /* Section 14: Veterans Status */ QLACTLM2 124 /* Section 15: Disability */ USEEQUIP 125 PAIN30DY 126 /* Section 16: Arthritis Burden */ JOINTSYM 127 JOINTRT2 128 HAVARTH2 129 LMTJOIN2 130 FRUITJUI 131-133 /* Section 17: Fruits & Vegetables */ FRUIT 134-136 GREENSAL 137-139 POTATOES 140-142 CARROTS 143-145 VEGETABL 146-148 JOBACTIV 149 /* Section 18: Physical Activity */ MODPACT 150 MODPADAY 151-152 MODPATIM 153-155 VIGPACT 156 VIGPADAY 157-158 VIGPATIM 159-161 HIVTST5 162 /* Section 19: HIV/AIDS */ HIVTSTD2 163-168 WHRTST7 169-170 HIVRISK2 171 EMTSUPRT 172 /* Section 20: Emotional Support and Life Satisfaction */ LSATISFY 173 DIABAGE2 174-175 /* Module 1: Diabetes */ INSULIN 176 DIABPILL 177 BLDSUGAR 178-180 FEETCHK2 181-183 FEETSORE 184 DOCTDIAB 185-186 CHKHEMO3 187-188 FEETCHK 189-190 EYEEXAM 191 DIABEYE 192 DIABEDU 193 LASTDEN3 194 /* Module 2: Oral Health */ RMVTEETH 195 DENCLEAN 196 VIDIFCLT 197 /* Module 3: Visual Impairment and Access to Eye Care */ VITELDIF 198 VIREADIF 199 VIPRFVST 200 VINOCARE 201-202 VIEYEEXM 203 VIINSUR 204 VICATRCT 205 VIGLUCMA 206 VIMACDEG 207 VIATWORK 208 VIMISWRK 209-211 PAINACT2 212-213 /* Module 4: Healthy Days (Symptoms) */ QLMENTL2 214-215 QLSTRES2 216-217 QLREST2 218-219 QLHLTH2 220-221 HAREHAB 222 /* Module 5: Cardiovascular Health */ STREHAB 223 CVDASPRN 224 ASPUNSAF 225 BPEATHBT 226 /* Module 6: Actions to Control High Blood Pressure */ BPSALT 227 BPALCHOL 228 BPEXER 229 BPEATADV 230 BPSLTADV 231 BPALCADV 232 BPEXRADV 233 BPMEDADV 234 BPHI2MR 235 HASYMP1 236 /* Module 7: Heart Attack and Stroke */ HASYMP2 237 HASYMP3 238 HASYMP4 239 HASYMP5 240 HASYMP6 241 STRSYMP1 242 STRSYMP2 243 STRSYMP3 244 STRSYMP4 245 STRSYMP5 246 STRSYMP6 247 FIRSTAID 248 FLUSTLOC 249-250 /* Module 8: Influenza */ ASTHMAGE 251-252 /* Module 9: Adult Asthma History */ ASATTACK 253 ASERVIST 254-255 ASDRVIST 256-257 ASRCHKUP 258-259 ASACTLIM 260-262 ASYMPTOM 263 ASNOSLEP 264 ASTHMED2 265 ASINHALR 266 RCSBIRTH $267-272 /* Module 10: Random Child Selection */ RCSGENDR 273 RCHISLAT 274 RCSRACE $275-280 RCSBRACE 281 RCSRELTN 282 CASTHDX2 283 /* Module 11: Childhood Asthma */ CASTHNO2 284 CIFLUSHT 285 /* Module 12: Child Immunization */ CIFLUMST 286 HADMAM 287 /* Module 13: Women’s Health */ HOWLONG 288 PROFEXAM 289 LENGEXAM 290 HADPAP2 291 LASTPAP2 292 HADHYST2 293 PSATEST 294 /* Module 14: Prostate Cancer Screening */ PSATIME 295 DIGRECEX 296 DRETIME 297 PROSTATE 298 BLDSTOOL 299 /* Module 15: Colorectal Cancer Screening */ LSTBLDS2 300 HADSIGM3 301 LASTSIG2 302 OSTPROS 303 /* Module 16: Osteoporosis */ ARTTODAY 304 /* Module 17: Arthritis Management */ ARTHWGT 305 ARTHEXER 306 ARTHEDU 307 LOSEWT 308 /* Module 18: Weight Control */ MAINTAIN 309 FEWCAL 310 PHYACT 311 DRADVICE 312 IAQHTSRC 313 /* Module 19: Indoor Air Quality */ IAQGASAP 314 IAQHTDYS 315-317 IAQCODTR 318 IAQMOLD 319 HEWTRSRC 320 /* Module 20: Home Environment */ HEWTRDRK 321 HECHMHOM 322-324 HECHMYRD 325-327 SCLSTSMK 328-329 /* Module 21: Smoking Cessation */ SCGETCAR 330-331 SCQITSMK 332-333 SCDSCMED 334-335 SCDSCMTH 336-337 HOUSESMK 338 /* Module 22: Secondhand Smoke Policy */ INDOORS 339 SMKPUBLC 340 SMKWORK 341 VETSTAT2 342 /* Module 23: Veterans Status */ VACARE 343 RRCLASS2 344 /* Module 24: Reactions to Race */ RRCOGNT2 345 RRATWORK 346 RRHCARE2 347 RRPHYSM1 348 RREMTSM1 349 SVNOTCH 350 /* Module 25: Sexual Violence */ SVSEXTCH 351 SVNOSEX 352 SVHADSEX 353 SVRELATN 354-355 SVGENDER 356 SVEANOSX 357 SVEHDSEX 358 IPVTHRAT 359 /* Module 26: Intimate Partner Violence */ IPVPHHRT 360 IPVPHYVL 361 IPVUWSEX 362 IPVPVL12 363 IPVSXINJ 364 IPVRELTN 365-366 SIPVSKP 367 /* Module 25 or 26 Skipped */ QSTVER 368 /* Questionnaire Version */ QSTLANG 369-370 /* Questionnaire Language */ MSCODE 371 _STSTR 372-376 /* Weighting And Stratification Variables */ _WT2 377-386 _AGEG_ 387-388 _SEXG_ 389 _RACEG3_ 390 _IMPAGE 391-392 _IMPNPH 393 _RFHLTH 394 /* Calculated Variables */ _TOTINDA 395 /* Calculated Variables */ _RFHYPE5 396 /* Calculated Variables */ _CHOLCHK 397 /* Calculated Variables */ _RFCHOL 398 _LTASTHM 399 /* Calculated Variables */ _CASTHMA 400 _ASTHMST 401 _FLSHOT3 402 /* Calculated Variables */ _PNEUMO2 403 _SMOKER3 404 /* Calculated Variables */ _RFSMOK3 405 DROCDY2_ 406-408 /* Calculated Variables */ _RFBING3 409 _DRNKDY3 410-413 _DRNKMO3 414-417 _RFDRHV3 418 _RFDRMN3 419 _RFDRWM3 420 MRACEORG $421-426 /* Calculated Race Variables */ MRACEASC 427-432 _PRACE 433-434 _MRACE 435-436 RACE2 437 _RACEG2 438 _RACEGR2 439 _RACE_G 440 _CNRACE 441 _CNRACEC 442 _AGEG5YR 443-444 _AGE65YR 445 _AGE_G 446 HTIN3 447-449 HTM3 450-452 WTKG2 453-457 _BMI4 458-461 _BMI4CAT 462 _RFBMI4 463 _CHLDCNT 464 _EDUCAG 465 _INCOMG 466 _DRDXART 467 /* Calculated Variables */ FTJUDAY_ 468-470 /* Calculated Variables */ FRUTDAY_ 471-473 GNSLDAY_ 474-476 POTADAY_ 477-479 CRTSDAY_ 480-482 VEGEDAY_ 483-485 _FRTSERV 486-490 _FRTINDX 491 _FV5SRV 492 _MODPAMN 493-495 /* Calculated Variables */ _VIGPAMN 496-498 MODCAT_ 499 VIGCAT_ 500 PACAT_ 501 _RFPAMOD 502 _RFPAVIG 503 _RFPAREC 504 _RFNOPA 505 _AIDTST2 506 /* Calculated Variables */ _HIGHRSK 507 _MMSAWT 508-517 /* MMSA Weighting and Stratification Variables */ ADJMMSA 518-527 /* MMSA Weighting and Stratification Variables */ AGE_M_F 528-529 /* MMSA Weighting and Stratification Variables */ RACE_M_F 530 /* MMSA Weighting and Stratification Variables */ RACE_MMS 531 /* MMSA Weighting and Stratification Variables */ AGE_MMSA 532-533 /* MMSA Weighting and Stratification Variables */ SEX_MMSA 534 /* MMSA Weighting and Stratification Variables */ _MMSANAM $535-634 /* MMSA Weighting and Stratification Variables */ _MMSA 635-639 /* MMSA Weighting and Stratification Variables */ ; ***************************************************************** * TO INCLUDE THE FORMAT ASSIGNEMT STATEMENT REMOVE THE ASTERISK * * FROM THE BEGINNING OF THE FOLLOWING LINE * *****************************************************************; * %INCLUDE FORMATIN ; ************************************************* * THIS SECTION CREATES LABELS FOR THE VARIABLES * *************************************************; Label FMONTH = 'MONTH NAME OF SOURCE FILE' IDATE = 'DATE OF INTERVIEW' IMONTH = 'MONTH OF INTERVIEW' IDAY = 'DAY OF INTERVIEW' IYEAR = 'YEAR OF INTERVIEW' INTVID = 'INTERVIEWER ID' DISPCODE = 'DISPOSITION OF INTERVIEW' SEQNO = 'ANNUAL SEQUENCE NUMBER' _PSU = 'PRIMARY SAMPLING UNIT' NATTMPTS = 'NUMBER OF ATTEMPTS' CELLFON = 'CELLULAR TELEPHONE' NUMADULT = 'NUMBER OF ADULTS IN HOUSEHOLD' NUMMEN = 'NUMBER OF ADULT MALES IN HOUSEHOLD' NUMWOMEN = 'NUMBER OF ADULT FEMALES IN HOUSEHOLD' GENHLTH = 'GENERAL HEALTH' PHYSHLTH = 'NUMBER OF DAYS PHYSICAL HEALTH NOT GOOD' MENTHLTH = 'NUMBER OF DAYS MENTAL HEALTH NOT GOOD' POORHLTH = 'DAYS HEALTH IMPAIRED LAST MO' HLTHPLAN = 'HAVE HEALTH CARE COVERAGE' PERSDOC2 = 'HAVE PERSONAL HEALTH CARE PROVIDER' MEDCOST = 'COULD NOT SEE DR. BECAUSE OF COST' CHECKUP = 'HOW LONG SINCE LAST ROUTINE CHECKUP' EXERANY2 = 'EXERCISE LAST 30 DAYS' DIABETE2 = 'EVER TOLD BY DOCTOR YOU HAVE DIABETES' BPHIGH4 = 'EVER TOLD BLOOD PRESSURE HIGH' BPMEDS = 'MEDS FOR BLOOD PRESSURE' BLOODCHO = 'EVER HAD BLOOD CHOLESTEROL CHECKED' CHOLCHK = 'HOW LONG SINCE CHOLESTEROL CHECKED' TOLDHI2 = 'EVER TOLD BLOOD CHOLESTEROL HIGH' CVDINFR3 = 'EVER TOLD HAD MYOCARDIAL INFARCTION' CVDCRHD3 = 'EVER TOLD HAD CORONARY HEART DISEASE' CVDSTRK3 = 'EVER TOLD HAD STROKE' ASTHMA2 = 'EVER HAD ASTHMA' ASTHNOW = 'HAVE ASTHMA NOW' FLUSHOT3 = 'FLU SHOT PAST 12 MOS' FLUSPRY2 = 'FLU SPRAY PAST 12 MOS' PNEUVAC3 = 'PNEUMONIA SHOT EVER' SMOKE100 = 'SMOKED AT LEAST 100 CIGARETTES' SMOKDAY2 = 'FREQUENCY OF DAYS NOW SMOKING' STOPSMK2 = 'QUIT SMOKING A DAY OR MORE IN PAST YEAR' DRNKANY4 = 'DAYS IN PAST 30 HAD ALCOHOLIC BEVERAGE' ALCDAY4 = 'DAYS IN PAST 30 HAD ALCOHOLIC BEVERAGE' AVEDRNK2 = 'AVG ALCOHOLIC DRINKS PER DAY IN PAST 30' DRNK2GE5 = 'FIVE OR MORE DRINKS ON AN OCCASION' MAXDRNKS = 'MOST DRINKS ON SINGLE OCCASION PAST 30 DAYS' AGE = 'REPORTED AGE IN YEARS' HISPANC2 = 'HISPANIC ORIGIN' MRACE = 'ORIGINAL REPORTED RACE' ORACE2 = 'PREFERRED RACE' MARITAL = 'MARITAL STATUS' CHILDREN = '# CHILDREN UNDER 18 IN HOUSEHOLD' EDUCA = 'EDUCATION LEVEL' EMPLOY = 'EMPLOYMENT STATUS' INCOME2 = 'INCOME LEVEL' WEIGHT2 = 'REPORTED WEIGHT IN POUNDS' HEIGHT3 = 'REPORTED HEIGHT IN FEET AND INCHES' NUMHHOL2 = 'MORE THAN ONE TELPHONE NUMBER IN HH' NUMPHON2 = 'NUMBER OF RESIDENTIAL PHONE NUMBERS' TELSERV2 = 'LOST PHONE SERVICE ONE WEEK+ LAST 12 MOS' SEX = 'SEX' PREGNANT = 'ARE YOU NOW PREGNANT' VETERAN = 'ARE YOU A VETERAN' QLACTLM2 = 'ACTIVITIES LIMITED BY HEALTH PROBLEM' USEEQUIP = 'REQ SPECIAL EQUIPMENT FOR HLTH PROBLEM' PAIN30DY = 'HAD JOINT PAIN, SWELLING LST 30 DAYS' JOINTSYM = 'JOINT SYMPTOMS 1ST BEGAN 3 MOS AGO?' JOINTRT2 = 'SEEN DOC FOR JOINT SYMPTOMS' HAVARTH2 = 'TOLD HAVE ARTHRITIS BY DOCTOR' LMTJOIN2 = 'LIMITED BECAUSE OF JOINT SYMPTOMS' FRUITJUI = 'HOW OFTEN DO YOU DRINK FRUIT JUICES' FRUIT = 'HOW OFTEN DO YOU EAT FRUIT' GREENSAL = 'HOW OFTEN DO YOU EAT GREEN SALAD' POTATOES = 'HOW OFTEN DO YOU EAT POTATOES' CARROTS = 'HOW OFTEN DO YOU EAT CARROTS' VEGETABL = 'SERVINGS OF VEGETABLES' JOBACTIV = 'PHYSICAL ACTIVITY ON JOB' MODPACT = 'MODERATE PHYSICAL ACTIVITY' MODPADAY = 'DAYS PER WEEK OF MOD. PHYS. ACT.' MODPATIM = 'MINS. PER DAY OF MOD. PHYS. ACT.' VIGPACT = 'VIGOROUS PHYSICAL ACTIVITY' VIGPADAY = 'DAYS PER WEEK OF VIG. PHYS. ACT.' VIGPATIM = 'MINS. PER DAY OF VIG. PHYS. ACT.' HIVTST5 = 'EVER TESTED HIV' HIVTSTD2 = 'MO/YR OF HIV TEST' WHRTST7 = 'LOCATION OF LAST HIV TEST' HIVRISK2 = 'ANY HIGH RISK SITUATIONS APPLY' EMTSUPRT = 'HOW OFTEN GET EMOT SUPPORT NEEDED' LSATISFY = 'SATISFACTION W/ LIFE' DIABAGE2 = 'AGE TOLD HAVE DIABETES' INSULIN = 'NOW TAKING INSULIN' DIABPILL = 'NOW TAKING DIABETES PILLS' BLDSUGAR = 'HOW OFTEN CHECK BLOOD FOR GLUCOSE' FEETCHK2 = 'HOW OFTEN CHECK FEET FOR SORES' FEETSORE = 'SORES ON FEET MORE THAN 4 WEEKS TO HEAL' DOCTDIAB = 'TIMES SEEN HEALTH PROF FOR DIABETES' CHKHEMO3 = 'CHECKED FOR HEMOGLOBIN “A ONE C”' FEETCHK = 'TIMES FEET CHECK FOR SORES/IRRITATIONS' EYEEXAM = 'LAST EYE EXAM WHERE PUPILS WERE DILATED' DIABEYE = 'DIABETES AFFECT EYES OR HAD RETINOPATHY' DIABEDU = 'EVER TAKEN CLASS TO MANAGE DIABETES' LASTDEN3 = 'HOW LONG SINCE LAST DENTIST VISIT' RMVTEETH = 'NUMBER OF PERMANENT TEETH REMOVED' DENCLEAN = 'HOW LONG SINCE LAST TEETH CLEANING' VIDIFCLT = 'DIFFICULTY RECOGNIZING FRIEND ACROSS STREET' VITELDIF = 'DIFFICULTY WATCHING TV' VIREADIF = 'DIFFICULTY READING TYPED TEXT' VIPRFVST = 'LAST TIME VISITED EYE CARE PRO' VINOCARE = 'REASON DID NOT USE EYE DOC PAST 12 MOS' VIEYEEXM = 'LAST EYE EXAM' VIINSUR = 'EYE CARE HEALTH INSURANCE?' VICATRCT = 'HLTH CARE PRO SAID NOW HAVE CATARACTS' VIGLUCMA = 'HLTH CARE PRO EVER SAID HAVE GLAUCOMA' VIMACDEG = 'HLTH CARE PRO EVER SAID HAVE MACULAR DEGENERATION' VIATWORK = 'EYE INJURY AT WORKPLACE' VIMISWRK = 'WORK DAYS MISSED DUE TO EYE INJURY' PAINACT2 = 'TIMES IN PAST MONTH PAIN INTERFERED' QLMENTL2 = 'TIMES IN PAST MONTH FELT DEPRESSED' QLSTRES2 = 'TIMES IN PAST MONTH BEEN STRESSED' QLREST2 = 'TIMES IN PAST MONTH NOT ENOUGH REST' QLHLTH2 = 'TIMES IN PAST MONTH FELT HEALTHY' HAREHAB = 'OUTPATIENT REHAB AFTER HEART ATTACK HOSP STAY' STREHAB = 'OUTPATIENT REHAB AFTER HOSP STAY FOR STROKE' CVDASPRN = 'TAKE ASPIRIN DAILY OR EVERY OTHER DAY' ASPUNSAF = 'HEALTH MAKES TAKING ASPIRIN UNSAFE' BPEATHBT = 'CHANGE EATING HABITS FOR BP?' BPSALT = 'REDUCE SALT INTAKE TO LOWER BP?' BPALCHOL = 'REDUCE ALCOHOL USE FOR BP?' BPEXER = 'EXERCISING TO LOWER BP?' BPEATADV = 'HLTH CARE PRO EVER ADVISED CHANGE IN EATING HABITS TO REDUCE BP' BPSLTADV = 'HLTH CARE PRO EVER ADVISED USING LESS SALT TO REDUCE BP' BPALCADV = 'HLTH CARE PRO EVER ADVISED REDUCED ALCOHOL USE TO REDUCE BP' BPEXRADV = 'HLTH CARE PRO EVER ADVISED EXERCISE TO REDUCE BP' BPMEDADV = 'HLTH CARE PRO EVER ADVISED MEDS TO REDUCE BP' BPHI2MR = 'TOLD HAD HIGH BP DURING 2+ VISITS TO HLTH CARE PRO?' HASYMP1 = 'HRT ATTK SYMPTOM: JAW NECK BACK PAIN' HASYMP2 = 'HRT ATTK SYMPTOM: LIGHTHEADED, FAINT' HASYMP3 = 'HRT ATTK SYMPTOM: CHEST PAIN' HASYMP4 = 'HRT ATTK SYMPTOM: LOSE VISION' HASYMP5 = 'HRT ATTK SYMPTOM: ARM SHOULDER PAIN' HASYMP6 = 'HRT ATTK SYMPTOM: SHORTNESS OF BREATH' STRSYMP1 = 'STROKE SYMPT: SUDDEN CONFUSION' STRSYMP2 = 'STROKE SYMPT: NUMBNESS ON ONE SIDE BODY' STRSYMP3 = 'STROKE SYMPT: SUDDEN VISION LOSS' STRSYMP4 = 'STROKE SYMPT: SUDDEN CHEST PAIN' STRSYMP5 = 'STROKE SYMPT: SUDDEN DIZZINESS' STRSYMP6 = 'STROKE SYMPT: SEVERE UNXPLND HEADACHE' FIRSTAID = 'STROKE SYMPT: 1ST RESP FOR H ATTK VICTIM' FLUSTLOC = 'WHERE OBTAINED MOST RECENT FLU SHOT/SPRAY' ASTHMAGE = 'AGE WHEN DOC SAID HAD ASTHMA' ASATTACK = 'ASTHMA ATTACK LAST 12 MOS' ASERVIST = 'ER VISITS LAST 12 MOS FOR ASTHMA' ASDRVIST = 'DOC VISITS LAST 12 MOS FOR ASTHMA' ASRCHKUP = 'ROUTINE CHECKUPS LAST 12 MOS FOR ASTHMA' ASACTLIM = 'DAYS MISSED WORK DUE TO ASTHMA' ASYMPTOM = 'SYMPTOMS OF ASTHMA LAST 30 DAYS' ASNOSLEP = 'SLEEP PROBS FROM ASTHMA LAST 30 DAYS' ASTHMED2 = 'TIMES USED PRESCRIBED PREVENTATIVE ASTHMA MED IN PAST 30 DAYS' ASINHALR = 'TIMES USED ASTHMA INHALER DURING AN ATTACK IN PAST 30 DAYS' RCSBIRTH = 'BIRTH DATE OF CHILD' RCSGENDR = 'GENDER OF CHILD' RCHISLAT = 'ETHNICITY OF CHILD' RCSRACE = 'RACE OF CHILD (MULTIPLE POSSIBLE)' RCSBRACE = 'RACE OF CHILD' RCSRELTN = 'RELATIONSHIP TO CHILD' CASTHDX2 = 'HLTH PRO EVER SAID CHILD HAS ASTHMA' CASTHNO2 = 'CHILD STILL HAVE ASTHMA?' CIFLUSHT = 'CHILD FLU SHOT PAST 12 MOS' CIFLUMST = 'CHILD FLU SPRAY PAST 12 MOS' HADMAM = 'HAVE YOU EVER HAD A MAMMOGRAM' HOWLONG = 'HOW LONG SINCE LAST MAMMOGRAM' PROFEXAM = 'EVER HAD BREAST PHYSICAL EXAM BY DOCTOR' LENGEXAM = 'HOW LONG SINCE LAST BREAST PHYSICAL EXAM' HADPAP2 = 'EVER HAD A PAP TEST' LASTPAP2 = 'HOW LONG SINCE LAST PAP TEST' HADHYST2 = 'EVER HAD A HYSTERECTOMY' PSATEST = 'EVER HAD PSA' PSATIME = 'TIME SINCE PSA' DIGRECEX = 'EVER HAD RECTAL EXAM' DRETIME = 'TIME SINCE RECTAL EXAM' PROSTATE = 'EVER TOLD HAVE PROSTATE CANCER' BLDSTOOL = 'EVER HAD BLOOD STOOL TEST USING HOME KIT' LSTBLDS2 = 'HOW LONG SINCE LAST HOME BLOOD STOOL TST' HADSIGM3 = 'EVER HAD A SIGMOIDOSCOPY/COLONOSCOPY' LASTSIG2 = 'LAST TIME HAD SIGMOIDOSCOPY/COLONOSCOPY' OSTPROS = 'HLTH PRO EVER SAID HAVE OSTEOPOROSIS' ARTTODAY = 'WHAT CAN YOU DO BECAUSE OF ARTHRITIS OR JOINT SYMPTOMS' ARTHWGT = 'DR. SUGGEST LOSE WEIGHT FOR ARTHRITIS OR JOINT SYMPTOMS' ARTHEXER = 'DR. SUGGEST USE OF PHYSICAL ACTIVITY OR EXERCISE FOR ARTHRITIS OR JOINT SYMPTOMS' ARTHEDU = 'EVER TAKEN CLASS IN MANAGING ARTHRITIS OR JOINT SYMPTOMS' LOSEWT = 'TRYING TO LOSE WEIGHT' MAINTAIN = 'TRYING TO MAINTAIN CURRENT WEIGHT' FEWCAL = 'FEWER CALORIES AND/OR LESS FAT' PHYACT = 'INCREASED PHYSICAL ACTIVITY' DRADVICE = 'PROFESSIONAL ADVICE ABOUT WEIGHT' IAQHTSRC = 'HOME HEATED WITH FURNACE THAT BURNS FUEL' IAQGASAP = 'HAVE NATRUAL GAS POWERED APPLIANCES' IAQHTDYS = '# DAYS IN PAST 12 MONTHS USED FUEL BURNING STOVE, FIREPLACE OR HEATER' IAQCODTR = 'HAVE CO DETECTOR IN HOME' IAQMOLD = 'HAVE MOLD GREATER THAN SIZE OF DOLLAR BILL' HEWTRSRC = 'MAIN SOURCE OF HOME WATER' HEWTRDRK = 'WHICH BEST DESCRIBES WATER YOU DRINK AT HOME' HECHMHOM = '# DAYS CHEMICALS APPLIED IN HOME TO KILL PESTS IN PAST 12 MONTHS' HECHMYRD = '# DAYS CHEMICALS APPLIED IN LAWN TO KILL PESTS IN PAST 12 MONTHS' SCLSTSMK = 'TIME SINCE LAST SMOKED REGULARLY' SCGETCAR = '# TIMES SAW A DOCTOR FOR CARE LAST 12 MONTHS' SCQITSMK = '# VISITS ADVISED TO QUIT SMOKING LAST 12 MONTHS' SCDSCMED = '# VISITS DOCTOR DISCUSSED MEDICATION TO ASSIST QUITTING SMOKING' SCDSCMTH = '# VISITS DOCTOR DISCUSSED METHODS TO QUIT SMOKING' HOUSESMK = 'SMOKING ALLOWED AT HOME' INDOORS = 'NORMALLY WORK INDOORS?' SMKPUBLC = 'SMOKING POLICY AT WORK FOR COMMON AREAS' SMKWORK = 'SMOKING POLICY AT WORK FOR WORK AREAS' VETSTAT2 = 'CURRENT VETERAN STATUS' VACARE = 'RECEIVED HEALTH CARE FROM VA FACILITY' RRCLASS2 = 'OTHERS CLASSIFY YOUR RACE' RRCOGNT2 = 'HOW OFTEN THINK ABOUR YOUR RACE' RRATWORK = 'TREATED DIFF THAN OTH RACE AT WORK' RRHCARE2 = 'TREATED DIFF THAN OTH RACE HLTH CARE' RRPHYSM1 = 'TIMES PAST 12 MOS FELT PHYSICAL SYMPTOMS BECAUSE OF TREATMENT DUE TO YOUR RACE' RREMTSM1 = 'TIMES PAST 12 MOS FELT EMOTIONALLY UPSET BECAUSE OF TREATMENT DUE TO YOUR RACE' SVNOTCH = 'SOMEONE PAST 12 MOS PUT YOU IN UNWANTED SEX SITUATION W/O TOUCHING' SVSEXTCH = 'UNWANTED TOUCHING OF SEXUAL PARTS OF BODY PAST 12 MOS' SVNOSEX = 'SOMEONE PAST 12 MOS ATTEMPT TO HAVE SEX AGAINST WILL BUT DID NOT HAPPEN' SVHADSEX = 'SOMEONE PAST 12 MOS HAD SEX WITH YOU AGAINST YOUR WILL' SVRELATN = 'RELATIONSHIP TO PERSON MOST RECENTLY ATTEMPTING OR HAVING UNWANTED SEX' SVGENDER = 'PERSON’S GENDER WHO HAD SEX WITH YOU AGAINST YOUR WILL' SVEANOSX = 'SOMEONE EVER ATTEMPT TO HAVE SEX AGAINST WILL BUT DID NOT HAPPEN' SVEHDSEX = 'SOMEONE EVER HAD SEX WITH YOU AGAINST YOUR WILL' IPVTHRAT = 'SEX PARTNER EVER THREATENED VIOLENCE' IPVPHHRT = 'SEX PARTNER EVER VIOLENT' IPVPHYVL = 'SEX PARTNER EVER ATTEMPTED VIOLENCE' IPVUWSEX = 'EVER HAD UNWANTED SEX W/ PARTNER' IPVPVL12 = 'HAD UNWANTED SEX OR VIOLENCE FROM SEX PARTNER LAST 12 MOS' IPVSXINJ = 'INJURIES FROM VIOLENCE OR UNWANTED SEX PAST 12 MOS' IPVRELTN = 'RELATIONSHIP TO SEX PARTNER LAST VIOLENCE OR UNWANTED SEX' SIPVSKP = 'OPTION TO SKIP QUESTION DUE TO PERSONAL SAFETY' QSTVER = 'QUESTIONNAIRE VERSION' QSTLANG = 'QUESTIONNAIRE LANGUAGE' MSCODE = 'METROPOLITAN STATUS CODE' _STSTR = 'CONCATENATED STRATIFICATION VARIABLES' _WT2 = 'DESIGN WEIGHT' _AGEG_ = 'AGE GROUPS USED IN POST-STRATIFICATION' _SEXG_ = 'SEX CATEGORIES USED IN POST-STRAT' _RACEG3_ = 'RACE CATEGORIES USED IN POST-STRATIFICATION' _IMPAGE = 'IMPUTED AGE USED IN POST-STRATIFICATION' _IMPNPH = 'IMPUTED NUMBER OF PHONES USED IN POST-STRATIFICATION' _RFHLTH = 'HEALTH STATUS' _TOTINDA = 'NO LEISURE TIME PHYSICAL ACTIVITY OR EXERCISE PAST 30 DAYS' _RFHYPE5 = 'HIGH BLOOD PRESSURE RISK FACTOR' _CHOLCHK = 'CHOLESTEROL CHECKED RISK FACTOR' _RFCHOL = 'HIGH CHOLESTEROL RISK FACTOR' _LTASTHM = 'RISK FACTOR FOR LIFETIME ASTHMA PREVALENCE' _CASTHMA = 'RISK FACTOR FOR CURRENT ASTHMA PREVALENCE' _ASTHMST = 'COMPUTED ASTHMA STATUS' _FLSHOT3 = 'RISK FACTOR FOR RESPONDENTS AGED 65+ THAT HAD A FLU SHOT IN THE PAST 12 MONTHS.' _PNEUMO2 = 'RISK FACTOR FOR RESPONDENTS AGED 65+ THAT HAVE EVER HAD A PNEUMONIA SHOT.' _SMOKER3 = 'FOUR LEVEL SMOKER STATUS.' _RFSMOK3 = 'CURRENT SMOKING STATUS RISK FACTOR.' DROCDY2_ = 'DRINK-OCCASIONS-PER-DAY' _RFBING3 = 'BINGE DRINKING RISK FACTOR.' _DRNKDY3 = 'NUMBER OF ALCOHOL DRINKS PER DAY' _DRNKMO3 = 'NUMBER OF ALCOHOL DRINKS PER MONTH' _RFDRHV3 = 'HEAVY DRINKING RISK' _RFDRMN3 = 'HEAVY DRINKING AMONG MEN RISK FACTOR.' _RFDRWM3 = 'HEAVY DRINKING AMONG FEMALES RISK FACTOR.' MRACEORG = 'REPORTED MRACE VARIABLE WITH TRAILING 7,8,9’S REMOVED.' MRACEASC = 'REPORTED MRACE VARIABLE WITH TRAILING 7,8,9’S REMOVED, IN ASCENDING ORDER.' _PRACE = 'PREFERRED RACE CATEGORY.' _MRACE = 'MULTIRACIAL RACE CATEGORIZATION.' RACE2 = 'RACE/ETHNICITY CATEGORIES.' _RACEG2 = 'WHITE/HISPANIC RACE GROUP' _RACEGR2 = '5 LEVEL RACE/ETHNICITY CATEGORY.' _RACE_G = 'RACE GROUPS USED FOR INTERNET PREVALENCE TABLES' _CNRACE = 'NUMBER OF CENSUS RACE CATEGORIES CHOSEN.' _CNRACEC = 'NUMBER OF CENSUS RACE CATEGORIES CHOSEN, COLLAPSED.' _AGEG5YR = 'FOURTEEN LEVEL AGE CATEGORY.' _AGE65YR = 'TWO LEVEL AGE CATEGORY.' _AGE_G = 'SIX LEVEL IMPUTED AGE CATEGORY' HTIN3 = 'REPORTED HEIGHT IN INCHES.' HTM3 = 'REPORTED HEIGHT IN METERS.' WTKG2 = 'REPORTED WEIGHT IN KILOGRAMS.' _BMI4 = 'BODY MASS INDEX.' _BMI4CAT = 'BODY MASS INDEX- THREE LEVELS CATEGORY.' _RFBMI4 = 'RISK FACTOR FOR OVERWEIGHT OR OBESE.' _CHLDCNT = 'NUMBER OF CHILDREN IN THE HOUSEHOLD' _EDUCAG = 'LEVEL OF EDUCATION COMPLETED' _INCOMG = 'INCOME CATEGORIES' _DRDXART = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' FTJUDAY_ = 'FRUIT JUICE SERVINGS PER DAY' FRUTDAY_ = 'FRUIT SERVINGS PER DAY' GNSLDAY_ = 'GREEN SALAD SERVINGS PER DAY' POTADAY_ = 'POTATO SERVINGS PER DAY' CRTSDAY_ = 'CARROT SERVINGS PER DAY' VEGEDAY_ = 'VEGETABLE SERVINGS PER DAY' _FRTSERV = 'FRUIT & VEGETABLE SERVINGS PER DAY' _FRTINDX = 'FRUIT & VEGETABLE SERVINGS INDEX' _FV5SRV = 'CONSUMED FIVE OR MORE SERVINGS OF FRUITS OR VEGETABLES PER DAY' _MODPAMN = 'MINUTES OF MODERATE PHYSICAL ACITIVITY' _VIGPAMN = 'MINUTES OF VIGOROUS PHYSICAL ACTIVITY' MODCAT_ = 'MODERATE PHYSICAL ACTIVITY CATEGORIES' VIGCAT_ = 'VIGOROUS PHYSICAL ACTIVITY CATEGORIES' PACAT_ = 'OVERALL PHYSICAL ACTIVITY CATEGORIES' _RFPAMOD = 'MODERATE PHYSICAL ACTIVITY RISK FACTOR' _RFPAVIG = 'VIGOROUS PHYSICAL ACTIVITY RISK FACTOR' _RFPAREC = 'RECOMMENDED PHYSICAL ACTIVITY RISK FACTOR' _RFNOPA = 'NO PHYSICAL ACTIVITY OR EXERCISE RISK FACTOR' _AIDTST2 = 'EVER BEEN TESTED FOR HIV RISK FACTOR.' _HIGHRSK = 'EVER PARTICIPATED IN HIGH-RISK BEHAVIOR RISK FACTOR.' _MMSA = 'MMSA CODE (CBSA OR METRO)' _MMSANAM = 'MMSA NAME (CBSA OR METRO)' RACE_MMS = 'RACE-INITIAL MMSA WEIGHTING CLASSES' RACE_M_F = 'RACE-FINAL MMSA WEIGHTING CLASSES' AGE_M_F = 'AGE-FINAL MMSA WEIGHTING CLASSES' ADJMMSA = 'MMSA-LEVEL WEIGHT ADJUSTMENT' _MMSAWT = 'MMSA-LEVEL WEIGHT' ; RUN;