***************************************************************************************** * FILE NAME: MMSA08_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 FORMAT08.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 07/06/2009 * *****************************************************************************************; ******************************** * 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 = 571 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2008\MMSA08.ASC' LRECL = 571 * * 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 CHECKUP1 64 QLREST2 65-66 /* Section 4: Sleep */ EXERANY2 67 /* Section 5: Exercise */ DIABETE2 68 /* Section 6: Diabetes */ LASTDEN3 69 /* Section 7: Oral Health */ RMVTETH3 70 DENCLEAN 71 CVDINFR4 72 /* Section 8: Cardiovascular Disease Prevalence */ CVDCRHD4 73 CVDSTRK3 74 ASTHMA2 75 /* Section 9: Asthma */ ASTHNOW 76 QLACTLM2 77 /* Section 10: Disability */ USEEQUIP 78 SMOKE100 79 /* Section 11: Tobacco Use */ SMOKDAY2 80 STOPSMK2 81 AGE 82-83 /* Section 12: Demographics */ HISPANC2 84 MRACE $85-90 ORACE2 91 VETERAN1 92 MARITAL 93 CHILDREN 94-95 EDUCA 96 EMPLOY 97 INCOME2 98-99 WEIGHT2 100-103 HEIGHT3 104-107 WTYRAGO 108-111 WTCHGINT 112 NUMHHOL2 113 NUMPHON2 114 TELSERV2 115 SEX 116 PREGNANT 117 DRNKANY4 118 /* Section 13: Alcohol Consumption */ ALCDAY4 119-121 AVEDRNK2 122-123 DRNK3GE5 124-125 MAXDRNKS 126-127 FLUSHOT3 128 /* Section 14: Immunization */ FLUSHTMY 129-134 FLUSPRY2 135 FLUSPRMY 136-141 PNEUVAC3 142 FALL3MN2 143-144 /* Section 15: Falls */ FALLINJ2 145-146 SEATBELT 147 /* Section 16: Seatbelt Use */ DRNKDRI2 148-149 /* Section 17: Drinking and Driving */ HADMAM 150 /* Section 18: Women´s Health */ HOWLONG 151 PROFEXAM 152 LENGEXAM 153 HADPAP2 154 LASTPAP2 155 HADHYST2 156 PSATEST 157 /* Section 19: Prostate Cancer Screening */ PSATIME 158 DIGRECEX 159 DRETIME 160 PROSTATE 161 BLDSTOOL 162 /* Section 20: Colorectal Cancer Screening */ LSTBLDS3 163 HADSIGM3 164 HADSGCO1 165 LASTSIG3 166 HIVTST5 167 /* Section 21: HIV/AIDS */ HIVTSTD2 168-173 WHRTST8 174-175 HIVRDTST 176 HIVRISK2 177 EMTSUPRT 178 /* Section 22: Emotional Support and Life Satisfaction */ LSATISFY 179 PDIABTST 180 /* Module 1: Pre-Diabetes */ PREDIAB 181 DIABAGE2 182-183 /* Module 2: Diabetes */ INSULIN 184 BLDSUGAR 185-187 FEETCHK2 188-190 DOCTDIAB 191-192 CHKHEMO3 193-194 FEETCHK 195-196 EYEEXAM 197 DIABEYE 198 DIABEDU 199 PAINACT2 200-201 /* Module 3: Healthy Days (Symptoms) */ QLMENTL2 202-203 QLSTRES2 204-205 QLHLTH2 206-207 VIDFCLT2 208 /* Module 4: Visual Impairment and Access to Eye Care */ VIREDIF2 209 VIPRFVS2 210 VINOCRE2 211-212 VIEYEXM2 213 VIINSUR2 214 VICTRCT2 215 VIGLUMA2 216 VIMACDG2 217 HRVOLNTR 218 /* Module 5: Influenza - High Risk/Health Care Worker */ HRDIRCAR 219 HRCHRNIL 220 HRSTLHAV 221 DRNKBER1 222-223 /* Module 6: Binge Drinking */ DRNKWIN1 224-225 DRNKLIQR 226-227 DRNKPMIX 228-229 DRNKLOC1 230 BINGEDRV 231 BINGEPAY 232-234 USEEVER3 235 /* Module 7: Other Tobacco Products */ USENOW3 236 USOTHNW1 237 SHSINWRK 238-239 /* Module 8: Secondhand Smoke I */ SHSINHOM 240-241 HOUSSMK1 242 SHSALOWB 243 SHSALOWR 244 SHSALOWW 245 ASTHMAGE 246-247 /* Module 9: Adult Asthma History */ ASATTACK 248 ASERVIST 249-250 ASDRVIST 251-252 ASRCHKUP 253-254 ASACTLIM 255-257 ASYMPTOM 258 ASNOSLEP 259 ASTHMED3 260 ASINHALR 261 HPVADVC 262 /* Module 10: Adult HPV (Human Papilloma Virus) */ HPVADSHT 263-264 VETSTAT2 265 /* Module 11: Veterans Health Status */ VACARE1 266 VAIRQAFG 267 RRCLASS2 268 /* Module 12: Reactions to Race */ RRCOGNT2 269 RRATWRK2 270 RRHCARE3 271 RRPHYSM2 272 RREMTSM2 273 ADPLEASR 274-275 /* Module 13: Anxiety and Depression */ ADDOWN 276-277 ADSLEEP 278-279 ADENERGY 280-281 ADEAT1 282-283 ADFAIL 284-285 ADTHINK 286-287 ADMOVE 288-289 ADANXEV 290 ADDEPEV 291 GPWELPR3 292 /* Module 14: General Preparedness */ GP3DYWTR 293 GP3DYFD1 294 GP3DYPRS 295 GPBATRAD 296 GPFLSLIT 297 GPEMRCM1 298 GPEMRIN1 299 GPVACPL1 300 GPMNDEVC 301 GPNOTEV1 302-303 RCSBIRTH $304-309 /* Module 15: Random Child Selection */ RCSGENDR 310 RCHISLAT 311 RCSRACE $312-317 RCSBRACE 318 RCSRLTN2 319 CASTHDX2 320 /* Module 16: Childhood Asthma Prevalence */ CASTHNO2 321 HPVCHVC 322 /* Module 17: Child HPV (Human Papilloma Virus) */ HPVCHSHT 323-324 QSTVER 325 /* Questionnaire Version */ QSTLANG 326-327 /* Questionnaire Language */ _STSTR 328-332 /* Weighting And Stratification Variables */ _WT2 333-342 _AGEG_ 343-344 _SEXG_ 345 _RACEG3_ 346 _IMPAGE 347-348 _IMPNPH 349 MSCODE 350 CHILDAGE 351-353 _CIMPAGE 354-355 /* Child Demographic Variables */ _RFHLTH 356 /* Section 1: Calculated Variables */ _HCVU65 357 /* Section 3: Calculated Variables */ _TOTINDA 358 /* Section 5: Calculated Variables */ _EXTETH2 359 /* Section 7: Calculated Variables */ _ALTETH2 360 _DENVST1 361 _LTASTHM 362 /* Section 9: Calculated Variables */ _CASTHMA 363 _ASTHMST 364 _SMOKER3 365 /* Section 11: Calculated Variables */ _RFSMOK3 366 MRACEORG $367-372 /* Section 12: Calculated Race Variables */ MRACEASC 373-378 _PRACE 379-380 _MRACE 381-382 RACE2 383 _RACEG2 384 _RACEGR2 385 _RACE_G 386 _CNRACE 387 _CNRACEC 388 _AGEG5YR 389-390 _AGE65YR 391 _AGE_G 392 HTIN3 393-395 HTM3 396-398 WTKG2 399-403 _BMI4 404-407 _BMI4CAT 408 _RFBMI4 409 _CHLDCNT 410 _EDUCAG 411 _INCOMG 412 DROCDY2_ 413-415 /* Section 13: Calculated Variables */ _RFBING4 416 _DRNKDY3 417-420 _DRNKMO3 421-424 _RFDRHV3 425 _RFDRMN3 426 _RFDRWM3 427 _FLSHOT3 428 /* Section 14: Calculated Variables */ _PNEUMO2 429 _RFSEAT2 430 /* Section 16: Calculated Variables */ _RFSEAT3 431 _RFMAM2Y 432 /* Section 18: Calculated Variables */ _MAM502Y 433 _RFPAP32 434 _RFPSA2Y 435 /* Section 19: Calculated Variables */ _RFBLDS2 436 /* Section 20: Calculated Variables */ _RFSIGM2 437 _AIDTST2 438 /* Section 21: Calculated Variables */ _MMSAWT 439-448 /* MMSA Weighting and Stratification Variables */ ADJMMSA 449-458 /* MMSA Weighting and Stratification Variables */ AGE_M_F 459-460 /* MMSA Weighting and Stratification Variables */ RACE_M_F 461 /* MMSA Weighting and Stratification Variables */ RACE_MMS 462 /* MMSA Weighting and Stratification Variables */ AGE_MMSA 463-464 /* MMSA Weighting and Stratification Variables */ SEX_MMSA 465 /* MMSA Weighting and Stratification Variables */ _MMSANAM $466-565 /* MMSA Weighting and Stratification Variables */ _MMSA 566-570 /* MMSA Weighting and Stratification Variables */ ENDOFREC 571 /* End of Record Marker */ ; ***************************************************************** * 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 = 'FILE MONTH' IDATE = 'INTERVIEW DATE' IMONTH = 'INTERVIEW MONTH' IDAY = 'INTERVIEW DAY' IYEAR = 'INTERVIEW YEAR' INTVID = 'INTERVIEWER IDENTIFICATION' DISPCODE = 'FINAL DISPOSITION' 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 MEN IN HOUSEHOLD' NUMWOMEN = 'NUMBER OF ADULT WOMEN IN HOUSEHOLD' GENHLTH = 'GENERAL HEALTH' PHYSHLTH = 'NUMBER OF DAYS PHYSICAL HEALTH NOT GOOD' MENTHLTH = 'NUMBER OF DAYS MENTAL HEALTH NOT GOOD' POORHLTH = 'POOR PHYSICAL HEALTH' HLTHPLAN = 'HAVE ANY HEALTH CARE COVERAGE' PERSDOC2 = 'MULTIPLE HEALTH CARE PROFESSIONALS' MEDCOST = 'COULD NOT SEE DR. BECAUSE OF COST' CHECKUP1 = 'LENGTH OF TIME SINCE LAST ROUTINE CHECKUP' QLREST2 = 'HOW MANY DAYS DID YOU GET ENOUGH SLEEP IN PAST 30 DAYS' EXERANY2 = 'EXERCISE IN PAST 30 DAYS' DIABETE2 = 'EVER TOLD BY DOCTOR YOU HAVE DIABETES' LASTDEN3 = 'LAST VISITED DENTIST OR DENTAL CLINIC' RMVTETH3 = 'NUMBER OF PERMANENT TEETH REMOVED' DENCLEAN = 'WHEN TEETH LAST CLEANED BY DENTIST OR HYGIENIST' CVDINFR4 = 'EVER DIAGNOSED WITH HEART ATTACK' CVDCRHD4 = 'EVER DIAGNOSED WITH ANGINA OR CORONARY HEART DISEASE' CVDSTRK3 = 'EVER DIAGNOSED WITH A STROKE' ASTHMA2 = 'EVER TOLD HAD ASTHMA' ASTHNOW = 'STILL HAVE ASTHMA' QLACTLM2 = 'ACTIVITY LIMITATION DUE TO HEALTH PROBLEMS' USEEQUIP = 'HEALTH PROBLEMS REQUIRING SPECIAL EQUIPMENT' SMOKE100 = 'SMOKED AT LEAST 100 CIGARETTES' SMOKDAY2 = 'FREQUENCY OF DAYS NOW SMOKING' STOPSMK2 = 'STOPPED SMOKING IN PAST 12 MONTHS' AGE = 'REPORTED AGE IN YEARS' HISPANC2 = 'HISPANIC/LATINO' MRACE = 'MULTIPLE RACE' ORACE2 = 'RESPONDENT RACE CHOICE' VETERAN1 = 'ARE YOU A VETERAN' MARITAL = 'MARITAL STATUS' CHILDREN = 'NUMBER OF CHILDREN IN HOUSEHOLD' EDUCA = 'EDUCATION LEVEL' EMPLOY = 'EMPLOYMENT STATUS' INCOME2 = 'INCOME LEVEL' WEIGHT2 = 'REPORTED WEIGHT IN POUNDS' HEIGHT3 = 'REPORTED HEIGHT IN FEET AND INCHES' WTYRAGO = 'REPORTED WEIGHT YEAR AGO IN POUNDS' WTCHGINT = 'CHANGE IN WEIGHT SINCE YEAR AGO' NUMHHOL2 = 'HOUSEHOLD TELEPHONES' NUMPHON2 = 'RESIDENTIAL PHONES' TELSERV2 = 'LOST PHONE SERVICE ONE WEEK+ LAST 12 MOS' SEX = 'RESPONDENTS SEX' PREGNANT = 'PREGNANCY STATUS' DRNKANY4 = 'DRINK ANY ALCOHOLIC BEVERAGES IN PAST 30 DAYS' ALCDAY4 = 'DAYS IN PAST 30 HAD ALCOHOLIC BEVERAGE' AVEDRNK2 = 'AVG ALCOHOLIC DRINKS PER DAY IN PAST 30' DRNK3GE5 = 'BINGE DRINKING' MAXDRNKS = 'MOST DRINKS ON SINGLE OCCASION PAST 30 DAYS' FLUSHOT3 = 'FLU SHOT PAST 12 MOS' FLUSHTMY = 'WHEN RECEIVED MOST RECENT FLU SHOT' FLUSPRY2 = 'FLU SPRAY PAST 12 MOS' FLUSPRMY = 'WHEN RECEIVED MOST RECENT FLU SPRAY IN NOSE' PNEUVAC3 = 'PNEUMONIA SHOT EVER' FALL3MN2 = 'HAD FALL PAST THREE MONTHS' FALLINJ2 = 'INJURED IN FALL' SEATBELT = 'HOW OFTEN USE SEATBELTS IN CAR?' DRNKDRI2 = 'DID YOU DRIVE AFTER HAVING TOO MUCH TO DRINK IN THE PAST 30 DAYS?' 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 = 'HAD HYSTERECTOMY' PSATEST = 'EVER HAD PSA TEST' PSATIME = 'TIME SINCE LAST PSA TEST' DIGRECEX = 'EVER HAD DIGITAL RECTAL EXAM' DRETIME = 'TIME SINCE LAST DIGITAL RECTAL EXAM' PROSTATE = 'EVER TOLD YOU HAD PROSTATE CANCER' BLDSTOOL = 'EVER HAD BLOOD STOOL TEST USING HOME KIT' LSTBLDS3 = 'TIME SINCE LAST BLOOD STOOL TEST' HADSIGM3 = 'EVER HAD SIGMOIDOSCOPY/COLONOSCOPY' HADSGCO1 = 'WAS LAST TEST A SIGMOIDOSCOPY OR COLONOSCOPY' LASTSIG3 = 'TIME SINCE LAST SIGMOIDOSCOPY/COLONOSCOPY' HIVTST5 = 'EVER TESTED HIV' HIVTSTD2 = 'MONTH AND YEAR OF LAST HIV TEST' WHRTST8 = 'LOCATION OF LAST HIV TEST' HIVRDTST = 'WAS YOUR LAST HIV TEST A RAPID TEST?' HIVRISK2 = 'DO ANY HIGH RISK SITUATIONS APPLY' EMTSUPRT = 'HOW OFTEN GET EMOTIONAL SUPPORT NEEDED' LSATISFY = 'SATISFACTION WITH LIFE' PDIABTST = 'HAD A TEST FOR HIGH BLOOD SUGAR IN PAST THREE YEARS' PREDIAB = 'EVER BEEN TOLD YOU HAVE PRE-DIABETES OR BORDERLINE DIABETES' DIABAGE2 = 'AGE WHEN TOLD DIABETIC' INSULIN = 'NOW TAKING INSULIN' BLDSUGAR = 'HOW OFTEN CHECK BLOOD FOR GLUCOSE' FEETCHK2 = 'HOW OFTEN CHECK FEET FOR SORES OR IRRITATIONS' DOCTDIAB = 'TIMES SEEN HEALTH PROFESSIONAL FOR DIABETES' CHKHEMO3 = 'TIMES CHECKED FOR GLYCOSYLATED HEMOGLOBIN' FEETCHK = 'TIMES FEET CHECK FOR SORES/IRRITATIONS' EYEEXAM = 'LAST EYE EXAM WHERE PUPILS WERE DILATED' DIABEYE = 'EVER TOLD DIABETES HAS AFFECTED EYES' DIABEDU = 'EVER TAKEN CLASS IN MANAGING DIABETES' PAINACT2 = 'HOW MANY DAYS HARD TO DO USUAL ACTIVITIES IN PAST 30 DAYS' QLMENTL2 = 'HOW MANY DAYS DEPRESSED IN PAST 30 DAYS' QLSTRES2 = 'HOW MANY DAYS FELT ANXIOUS IN PAST 30 DAYS' QLHLTH2 = 'HOW MANY DAYS FULL OF ENERGY IN PAST 30 DAYS' VIDFCLT2 = 'DIFFICULTY RECOGNIZING FRIEND ACROSS STREET' VIREDIF2 = 'DIFFICULTY READING TYPED TEXT' VIPRFVS2 = 'LAST TIME VISITED EYE CARE PROVIDER' VINOCRE2 = 'REASON DID NOT USE EYE DOC PAST 12 MOS' VIEYEXM2 = 'WHEN LAST EYEXAM' VIINSUR2 = 'EYE CARE HEALTH INSURANCE' VICTRCT2 = 'HLTH CARE PRO SAID NOW HAVE CATARACTS' VIGLUMA2 = 'HLTH CARE PRO EVER SAID HAVE GLAUCOMA' VIMACDG2 = 'HLTH CARE PRO EVER SAID HAVE MACULAR DEGENERATION' HRVOLNTR = 'CURRENTLY VOLUNTEER OR WORK IN MEDICAL OR HEALTH CARE FACILITY' HRDIRCAR = 'PROVIDE DIRECT PATIENT CARE AS PART OF ROUTINE WORK' HRCHRNIL = 'HAVE YOU BEEN TOLD YOU CHRONIC HEALTH PROBLEM?' HRSTLHAV = 'STILL HAVE CHRONIC ILLNESS?' DRNKBER1 = 'HOW MANY BEERS CONSUMED WHEN BINGE DRINKING' DRNKWIN1 = 'HOW MANY GLASSES OF WINE CONSUMED WHEN BINGE DRINKING' DRNKLIQR = 'HOW MANY DRINKS OF LIQUOR CONSUMED WHEN BINGE DRINKING' DRNKPMIX = 'HOW MANY PRE-MIXED DRINKS CONSUMED WHEN BINGE DRINKING' DRNKLOC1 = 'WHERE WERE YOU WHEN YOU BINGE DRANK' BINGEDRV = 'DRIVE A MOTOR VEHICLE AFTER BINGE DRINKING?' BINGEPAY = 'HOW MUCH DID YOU PAY FOR THE ALCOHOL YOU DRANK?' USEEVER3 = 'EVER USED SMOKELESS TOBACCO PRODUCTS' USENOW3 = 'USE OF SMOKELESS TOBACCO PRODUCTS' USOTHNW1 = 'DO YOU CURRENTLY USE ANY TOBACCO PRODUCTS OTHER THAN CIGARETTES?' SHSINWRK = 'ANYONE SMOKE IN YOUR INDOOR WORKPLACE IN PAST 7 DAYS?' SHSINHOM = 'ANYONE SMOKE IN YOUR HOME IN PAST 7 DAYS?' HOUSSMK1 = 'SMOKING POLICY AT HOME' SHSALOWB = 'SHOULD SMOKING BE ALLOWED IN BARS?' SHSALOWR = 'SHOULD SMOKING BE ALLOWED IN RESTAURANTS?' SHSALOWW = 'SHOULD SMOKING BE ALLOWED IN INDOOR WORKPLACES?' ASTHMAGE = 'AGE AT ASTHMA DIAGNOSIS' ASATTACK = 'ASTHMA DURING PAST 12 MONTHS' ASERVIST = 'EMERGENCY ASTHMA CARE DURING PAST 12 MONTHS' ASDRVIST = 'URGENT ASTHMA TREATMENT DURING PAST 12 MONTHS' ASRCHKUP = 'ROUTINE ASTHMA CARE DURING PAST 12 MONTHS' ASACTLIM = 'ACTIVITIES LIMITED DUE TO ASTHMA DURING PAST 12 MONTHS' ASYMPTOM = 'ASTHMA SYMPTOMS DURING PAST 30 DAYS' ASNOSLEP = 'SLEEP DIFFICULTY DUE TO ASTHMA DURING PAST 30 DAYS' ASTHMED3 = 'DAYS USED PRESCRIBED PREVENTATIVE ASTHMA MED IN PAST 30 DAYS' ASINHALR = 'TIMES USED ASTHMA INHALER DURING AN ATTACK IN PAST 30 DAYS' HPVADVC = 'EVER HAD THE HPV VACCINATION?' HPVADSHT = 'NUMBER OF HPV SHOTS RECEIVED' VETSTAT2 = 'CURRENT VETERAN STATUS' VACARE1 = 'RECEIVED SOME OR ALL OF YOUR HEALTH CARE FROM VA FACILITIES IN THE LAST 12 MONTHS' VAIRQAFG = 'MILITARY DEPLOYMENT TO AFGHANISTAN OR IRAQ SINCE 9/11?' RRCLASS2 = 'HOW DO OTHER PEOPLE USUALLY CLASSIFY YOU IN THIS COUNTRY?' RRCOGNT2 = 'HOW OFTEN DO YOU THINK ABOUT YOUR RACE?' RRATWRK2 = 'HOW DO YOU FEEL YOU WERE TREATED AT WORK COMPARED TO PEOPLE OF OTHER RACES IN PAST 12 MONTHS?' RRHCARE3 = 'WHEN SEEKING HEALTH CARE PAST 12 MONTHS, WAS EXPERIENCE WORSE, SAME, BETTER THAN PEOPLE OF OTHER RAC' RRPHYSM2 = 'TIMES PAST 30 DAYS FELT PHYSICAL SYMPTOMS BECAUSE OF TREATMENT DUE TO YOUR RACE' RREMTSM2 = 'TIMES PAST 30 DAYS FELT EMOTIONALLY UPSET BECAUSE OF TREATMENT DUE TO YOUR RACE' ADPLEASR = 'DAYS HAD LITTLE PLEASURE DOING THINGS' ADDOWN = 'DAYS FELT DOWN, DEPRESSED OR HOPELESS' ADSLEEP = 'DAYS HAD TROUBLE WITH SLEEP' ADENERGY = 'DAYS WERE TIRED OR HAD LITTLE ENERGY' ADEAT1 = 'DAYS ATE TOO LITTLE OR TOO MUCH' ADFAIL = 'DAYS FELT LIKE FAILURE OR LET FAMILY DOWN' ADTHINK = 'DAYS HAD TROUBLE CONCENTRATING' ADMOVE = 'DAYS TALKED TO MOVE SLOWER OR FASTER THAN USUAL' ADANXEV = 'EVER TOLD YOU HAD AN ANXIETY DISORDER' ADDEPEV = 'EVER TOLD YOU HAD A DEPRESSIVE DISORDER' GPWELPR3 = 'HOUSEHOLD PREPARED TO HANDLE LARGE-SCALE DISASTER OR EMERGENCY' GP3DYWTR = 'DOES YOUR HOUSEHOLD HAVE A 3-DAY SUPPLY OF WATER FOR EVERYONE WHO LIVES THERE?' GP3DYFD1 = 'DOES YOUR HOUSEHOLD HAVE A 3-DAY SUPPLY OF NON-PERISHABLE FOOD FOR EVERYONE WHO LIVES THERE?' GP3DYPRS = 'DOES YOUR HOUSEHOLD HAVE A 3-DAY SUPPLY OF PRESCRIPTION MEDICATION FOR EACH PERSON WHO TAKES PRESCRI' GPBATRAD = 'DOES YOUR HOUSEHOLD HAVE A WORKING BATTERY OPERATED RADIO AND WORKING BATTERIES FOR YOUR USE IF THE' GPFLSLIT = 'DOES YOUR HOUSEHOLD HAVE A WORKING FLASHLIGHT AND WORKING BATTERIES FOR YOUR USE IF THE ELECTRICITY' GPEMRCM1 = 'IN A LARGE-SCALE DISASTER OR EMERGENCY, WHAT WOULD BE YOUR MAIN METHOD OF COMMUNICATING WITH RELATIV' GPEMRIN1 = 'WHAT WOULD BE YOUR MAIN METHOD OF GETTING INFORMATION FROM AUTHORITIES IN A LARGE-SCALE DISASTER OR' GPVACPL1 = 'DOES YOUR HOUSEHOLD HAVE A DISASTER EVACUATION PLAN?' GPMNDEVC = 'IF PUBLIC AUTHORITIES ANNOUNCED MANDATORY EVACUATION FROM YOUR COMMUNITY DUE TO A LARGE-SCALE DISAST' GPNOTEV1 = 'WHAT WOULD BE THE MAIN REASON WHY YOU MIGHT NOT EVACUATE IF ASKED TO DO SO?' RCSBIRTH = 'BIRTH DATE OF CHILD' RCSGENDR = 'GENDER OF CHILD' RCHISLAT = 'ETHNICITY OF CHILD' RCSRACE = 'RACE OF CHILD (MULTIPLE POSSIBLE)' RCSBRACE = 'RACE OF CHILD' RCSRLTN2 = 'RELATIONSHIP TO CHILD' CASTHDX2 = 'HLTH PRO EVER SAID CHILD HAS ASTHMA' CASTHNO2 = 'CHILD STILL HAVE ASTHMA?' HPVCHVC = 'CHILD EVER HAD THE HPV VACCINATION?' HPVCHSHT = 'HOW MANY HPV SHOTS DID CHILD RECEIVE?' QSTVER = 'QUESTIONNAIRE VERSION IDENTIFIER' QSTLANG = 'LANGUAGE IDENTIFIER' _STSTR = 'SAMPLE DESIGN STRATIFICATION VARIABLE' _WT2 = 'DESIGN WEIGHT' _AGEG_ = 'AGE GROUP CODES USED IN POST-STRATIFICATION.' _SEXG_ = 'GENDER GROUP CODES USED IN POST-STRATIFICATION.' _RACEG3_ = 'RACE GROUP CODES USED IN POST-STRATIFICATION.' _IMPAGE = 'AGE VALUE USED TO DETERMINE AGE GROUPS' _IMPNPH = 'IMPUTED NUMBER OF PHONES' MSCODE = 'METROPOLITAN STATUS CODE' CHILDAGE = 'CHILD AGE' _CIMPAGE = 'IMPUTED CHILD AGE' _RFHLTH = 'ADULTS WITH GOOD OR BETTER HEALTH' _HCVU65 = 'RESPONDENTS AGED 18-64 WITH HEALTH CARE COVERAGE' _TOTINDA = 'LEISURE TIME PHYSICAL ACTIVITY CALCULATED VARIABLE' _EXTETH2 = 'RISK FACTOR FOR HAVING HAD PERMANENT TEETH EXTRACTED' _ALTETH2 = 'ADULTS AGED 65+ WHO HAVE HAD ALL THEIR NATURAL TEETH EXTRACTED' _DENVST1 = 'ADULTS THAT HAVE VISITED A DENTIST, DENTAL HYGENIST OR DENTAL CLINIC WITHIN THE PAST YEAR' _LTASTHM = 'LIFETIME ASTHMA CALCULATED VARIABLE' _CASTHMA = 'CURRENT ASTHMA CALCULATED VARIABLE' _ASTHMST = 'COMPUTED ASTHMA STATUS' _SMOKER3 = 'COMPUTED SMOKING STATUS' _RFSMOK3 = 'CURRENT SMOKING CALCULATED VARIABLE' MRACEORG = 'MRACE WITH TRAILING 7,8,9S REMOVED CALCULATED VARIABLE' MRACEASC = 'MRACEORG WITH RESPONSES IN ASCENDING ORDER CALCULATED VARIABLE' _PRACE = 'COMPUTED PREFERRED RACE' _MRACE = 'COMPUTED NON-HISPANIC RACE INCLUDING MULTIRACIAL' RACE2 = 'COMPUTED RACE-ETHNICITY GROUPING' _RACEG2 = 'COMPUTED NON-HISPANIC WHITES/ALL OTHERS RACE CATEGORIES RACE/ETHNIC GROUP CODES USED IN POST-STRATIF' _RACEGR2 = 'COMPUTED FIVE LEVEL RACE/ETHNICITY CATEGORY.' _RACE_G = 'COMPUTED RACE GROUPS USED FOR INTERNET PREVALENCE TABLES' _CNRACE = 'COMPUTED NUMBER OF CENSUS RACE CATEGORIES CHOSEN' _CNRACEC = 'COMPUTED NUMBER OF CENSUS RACE CATEGORIES CHOSEN, COLLAPSED' _AGEG5YR = 'REPORTED AGE IN FIVE-YEAR AGE CATEGORIES CALCULATED VARIABLE' _AGE65YR = 'REPORTED AGE IN TWO AGE GROUPS CALCULATED VARIABLE' _AGE_G = 'IMPUTED AGE IN SIX GROUPS' HTIN3 = 'COMPUTED HEIGHT IN INCHES' HTM3 = 'COMPUTED HEIGHT IN METERS' WTKG2 = 'COMPUTED WEIGHT IN KILOGRAMS' _BMI4 = 'COMPUTED BODY MASS INDEX' _BMI4CAT = 'COMPUTED BODY MASS INDEX CATEGORIES' _RFBMI4 = 'OVERWEIGHT OR OBESE CALCULATED VARIABLE' _CHLDCNT = 'COMPUTED NUMBER OF CHILDREN IN HOUSEHOLD' _EDUCAG = 'COMPUTED LEVEL OF EDUCATION COMPLETED CATEGORIES' _INCOMG = 'COMPUTED INCOME CATEGORIES' DROCDY2_ = 'COMPUTED DRINK-OCCASIONS-PER-DAY' _RFBING4 = 'BINGE DRINKING CALCULATED VARIABLE' _DRNKDY3 = 'COMPUTED NUMBER OF DRINKS OF ALCOHOL BEVERAGES PER DAY' _DRNKMO3 = 'COMPUTED TOTAL NUMBER DRINKS A MONTH' _RFDRHV3 = 'HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _RFDRMN3 = 'ADULT MEN HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _RFDRWM3 = 'ADULT WOMEN HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _FLSHOT3 = 'FLU SHOT CALCULATED VARIABLE' _PNEUMO2 = 'PNEUMONIA VACCINATION CALCULATED VARIABLE' _RFSEAT2 = 'ALWAYS OR NEARLY ALWAYS WEAR SEAT BELTS' _RFSEAT3 = 'ALWAYS WEAR SEAT BELTS' _RFMAM2Y = 'WOMEN RESPONDENTS AGED 40+ THAT HAVE HAD A MAMMOGRAM IN THE PAST TWO YEARS' _MAM502Y = 'WOMEN RESPONDENTS AGED 50+ THAT HAVE HAD A MAMMOGRAM IN THE PAST TWO YEARS' _RFPAP32 = 'WOMEN RESPONDENTS AGED 18+ THAT HAVE HAD A PAP TEST IN THE PAST THREE YEARS' _RFPSA2Y = 'MALE RESPONDENTS AGED 40+ THAT HAVE HAD A PSA TEST IN THE PAST 2 YEARS' _RFBLDS2 = 'RESPONDENTS AGED 50+ THAT HAVE HAD A BLOOD STOOL TEST WITHIN THE PAST TWO YEARS' _RFSIGM2 = 'RESPONDENTS AGED 50 OR OLDER THAT HAVE HAD A SIGMOIDOSCOPY OR COLONOSCOPY' _AIDTST2 = 'EVER BEEN TESTED FOR HIV CALCULATED VARIABLE' _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;