***************************************************************************************** * FILE NAME: CNTY08_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 = 521 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2008\CNTY08.ASC' LRECL = 521 * * 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 _STATE 1-2 /* Record Identification */ FMONTH 3-4 IDATE $5-12 IMONTH $13-14 IDAY $15-16 IYEAR $17-20 INTVID $21-23 DISPCODE 24-26 SEQNO 27-36 _PSU 37-46 NATTMPTS 47-48 CELLFON 49 NUMADULT 50-51 NUMMEN 52-53 NUMWOMEN 54-55 GENHLTH 56 /* Section 1: Health Status */ PHYSHLTH 57-58 /* Section 2: Healthy Days - Health-Related Quality of Life */ MENTHLTH 59-60 POORHLTH 61-62 HLTHPLAN 63 /* Section 3: Health Care Access */ PERSDOC2 64 MEDCOST 65 CHECKUP1 66 QLREST2 67-68 /* Section 4: Sleep */ EXERANY2 69 /* Section 5: Exercise */ DIABETE2 70 /* Section 6: Diabetes */ LASTDEN3 71 /* Section 7: Oral Health */ RMVTETH3 72 DENCLEAN 73 CVDINFR4 74 /* Section 8: Cardiovascular Disease Prevalence */ CVDCRHD4 75 CVDSTRK3 76 ASTHMA2 77 /* Section 9: Asthma */ ASTHNOW 78 QLACTLM2 79 /* Section 10: Disability */ USEEQUIP 80 SMOKE100 81 /* Section 11: Tobacco Use */ SMOKDAY2 82 STOPSMK2 83 AGE 84-85 /* Section 12: Demographics */ HISPANC2 86 MRACE $87-92 ORACE2 93 VETERAN1 94 MARITAL 95 CHILDREN 96-97 EDUCA 98 EMPLOY 99 INCOME2 100-101 WEIGHT2 102-105 HEIGHT3 106-109 WTYRAGO 110-113 WTCHGINT 114 NUMHHOL2 115 NUMPHON2 116 TELSERV2 117 SEX 118 PREGNANT 119 DRNKANY4 120 /* Section 13: Alcohol Consumption */ ALCDAY4 121-123 AVEDRNK2 124-125 DRNK3GE5 126-127 MAXDRNKS 128-129 FLUSHOT3 130 /* Section 14: Immunization */ FLUSHTMY 131-136 FLUSPRY2 137 FLUSPRMY 138-143 PNEUVAC3 144 FALL3MN2 145-146 /* Section 15: Falls */ FALLINJ2 147-148 SEATBELT 149 /* Section 16: Seatbelt Use */ DRNKDRI2 150-151 /* Section 17: Drinking and Driving */ HADMAM 152 /* Section 18: Women´s Health */ HOWLONG 153 PROFEXAM 154 LENGEXAM 155 HADPAP2 156 LASTPAP2 157 HADHYST2 158 PSATEST 159 /* Section 19: Prostate Cancer Screening */ PSATIME 160 DIGRECEX 161 DRETIME 162 PROSTATE 163 BLDSTOOL 164 /* Section 20: Colorectal Cancer Screening */ LSTBLDS3 165 HADSIGM3 166 HADSGCO1 167 LASTSIG3 168 HIVTST5 169 /* Section 21: HIV/AIDS */ HIVTSTD2 170-175 WHRTST8 176-177 HIVRDTST 178 HIVRISK2 179 EMTSUPRT 180 /* Section 22: Emotional Support and Life Satisfaction */ LSATISFY 181 PDIABTST 182 /* Module 1: Pre-Diabetes */ PREDIAB 183 DIABAGE2 184-185 /* Module 2: Diabetes */ INSULIN 186 BLDSUGAR 187-189 FEETCHK2 190-192 DOCTDIAB 193-194 CHKHEMO3 195-196 FEETCHK 197-198 EYEEXAM 199 DIABEYE 200 DIABEDU 201 PAINACT2 202-203 /* Module 3: Healthy Days (Symptoms) */ QLMENTL2 204-205 QLSTRES2 206-207 QLHLTH2 208-209 VIDFCLT2 210 /* Module 4: Visual Impairment and Access to Eye Care */ VIREDIF2 211 VIPRFVS2 212 VINOCRE2 213-214 VIEYEXM2 215 VIINSUR2 216 VICTRCT2 217 VIGLUMA2 218 VIMACDG2 219 HRVOLNTR 220 /* Module 5: Influenza - High Risk/Health Care Worker */ HRDIRCAR 221 HRCHRNIL 222 HRSTLHAV 223 DRNKBER1 224-225 /* Module 6: Binge Drinking */ DRNKWIN1 226-227 DRNKLIQR 228-229 DRNKPMIX 230-231 DRNKLOC1 232 BINGEDRV 233 BINGEPAY 234-236 USEEVER3 237 /* Module 7: Other Tobacco Products */ USENOW3 238 USOTHNW1 239 SHSINWRK 240-241 /* Module 8: Secondhand Smoke I */ SHSINHOM 242-243 HOUSSMK1 244 SHSALOWB 245 SHSALOWR 246 SHSALOWW 247 ASTHMAGE 248-249 /* Module 9: Adult Asthma History */ ASATTACK 250 ASERVIST 251-252 ASDRVIST 253-254 ASRCHKUP 255-256 ASACTLIM 257-259 ASYMPTOM 260 ASNOSLEP 261 ASTHMED3 262 ASINHALR 263 HPVADVC 264 /* Module 10: Adult HPV (Human Papilloma Virus) */ HPVADSHT 265-266 VETSTAT2 267 /* Module 11: Veterans Health Status */ VACARE1 268 VAIRQAFG 269 RRCLASS2 270 /* Module 12: Reactions to Race */ RRCOGNT2 271 RRATWRK2 272 RRHCARE3 273 RRPHYSM2 274 RREMTSM2 275 ADPLEASR 276-277 /* Module 13: Anxiety and Depression */ ADDOWN 278-279 ADSLEEP 280-281 ADENERGY 282-283 ADEAT1 284-285 ADFAIL 286-287 ADTHINK 288-289 ADMOVE 290-291 ADANXEV 292 ADDEPEV 293 GPWELPR3 294 /* Module 14: General Preparedness */ GP3DYWTR 295 GP3DYFD1 296 GP3DYPRS 297 GPBATRAD 298 GPFLSLIT 299 GPEMRCM1 300 GPEMRIN1 301 GPVACPL1 302 GPMNDEVC 303 GPNOTEV1 304-305 RCSBIRTH $306-311 /* Module 15: Random Child Selection */ RCSGENDR 312 RCHISLAT 313 RCSRACE $314-319 RCSBRACE 320 RCSRLTN2 321 CASTHDX2 322 /* Module 16: Childhood Asthma Prevalence */ CASTHNO2 323 HPVCHVC 324 /* Module 17: Child HPV (Human Papilloma Virus) */ HPVCHSHT 325-326 QSTVER 327 /* Questionnaire Version */ QSTLANG 328-329 /* Questionnaire Language */ _STSTR 330-334 /* Weighting And Stratification Variables */ _WT2 335-344 _AGEG_ 345-346 _SEXG_ 347 _RACEG3_ 348 _IMPAGE 349-350 _IMPNPH 351 MSCODE 352 CHILDAGE 353-355 _CIMPAGE 356-357 /* Child Demographic Variables */ _RFHLTH 358 /* Section 1: Calculated Variables */ _HCVU65 359 /* Section 3: Calculated Variables */ _TOTINDA 360 /* Section 5: Calculated Variables */ _EXTETH2 361 /* Section 7: Calculated Variables */ _ALTETH2 362 _DENVST1 363 _LTASTHM 364 /* Section 9: Calculated Variables */ _CASTHMA 365 _ASTHMST 366 _SMOKER3 367 /* Section 11: Calculated Variables */ _RFSMOK3 368 MRACEORG $369-374 /* Section 12: Calculated Race Variables */ MRACEASC 375-380 _PRACE 381-382 _MRACE 383-384 RACE2 385 _RACEG2 386 _RACEGR2 387 _RACE_G 388 _CNRACE 389 _CNRACEC 390 _AGEG5YR 391-392 _AGE65YR 393 _AGE_G 394 HTIN3 395-397 HTM3 398-400 WTKG2 401-405 _BMI4 406-409 _BMI4CAT 410 _RFBMI4 411 _CHLDCNT 412 _EDUCAG 413 _INCOMG 414 DROCDY2_ 415-417 /* Section 13: Calculated Variables */ _RFBING4 418 _DRNKDY3 419-422 _DRNKMO3 423-426 _RFDRHV3 427 _RFDRMN3 428 _RFDRWM3 429 _FLSHOT3 430 /* Section 14: Calculated Variables */ _PNEUMO2 431 _RFSEAT2 432 /* Section 16: Calculated Variables */ _RFSEAT3 433 _RFMAM2Y 434 /* Section 18: Calculated Variables */ _MAM502Y 435 _RFPAP32 436 _RFPSA2Y 437 /* Section 19: Calculated Variables */ _RFBLDS2 438 /* Section 20: Calculated Variables */ _RFSIGM2 439 _AIDTST2 440 /* Section 21: Calculated Variables */ _CNTYWT 441-450 /* County Weighting and Stratification Variables */ ADJCNTY 451-460 /* County Weighting and Stratification Variables */ AGE_C_F 461-462 /* County Weighting and Stratification Variables */ RACE_C_F 463 /* County Weighting and Stratification Variables */ RACE_CNT 464 /* County Weighting and Stratification Variables */ AGE_CNTY 465-466 /* County Weighting and Stratification Variables */ SEX_CNTY 467 /* County Weighting and Stratification Variables */ _CNTYNAM $468-517 /* County Weighting and Stratification Variables */ _CNTY 518-520 /* County Weighting and Stratification Variables */ ENDOFREC 521 /* 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 _STATE = 'STATE FIPS CODE' 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' _CNTY = 'COUNTY CODE - IMPUTED WHEN MISSING' SEX_CNTY = 'SEX-COUNTY WEIGHTING CLASSES' RACE_CNT = 'RACE-INITIAL COUNTY WEIGHTING CLASSES' AGE_CNTY = 'AGE-INITIAL COUNTY WEIGHTING CLASSES' RACE_C_F = 'RACE-FINAL COUNTY WEIGHTING CLASSES' AGE_C_F = 'AGE-FINAL COUNTY WEIGHTING CLASSES' ADJCNTY = 'COUNTY-LEVEL WEIGHT ADJUSTMENT' _CNTYWT = 'COUNTY-LEVEL WEIGHT' _CNTYNAM = 'COUNTY NAME' ; RUN;