***************************************************************************************** * FILE NAME: MMSA11_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 FORMAT11.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 01/03/2013 * *****************************************************************************************; ******************************** * 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 = 569 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2011\MMSA11.ASC' LRECL = 569 * * 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-23 DISPCODE 24-26 SEQNO 27-36 NATTMPTS 37-38 NUMADULT 39-40 NUMMEN 41-42 NUMWOMEN 43-44 GENHLTH 45 /* Section 1: Health Status */ PHYSHLTH 46-47 /* Section 2: Healthy Days - Health-Related Quality of Life */ MENTHLTH 48-49 POORHLTH 50-51 HLTHPLN1 52 /* Section 3: Health Care Access */ PERSDOC2 53 MEDCOST 54 CHECKUP1 55 BPHIGH4 56 /* Section 4: Hypertension Awareness */ BPMEDS 57 BLOODCHO 58 /* Section 5: Cholesterol Awareness */ CHOLCHK 59 TOLDHI2 60 CVDINFR4 61 /* Section 6: Chronic Health Conditions */ CVDCRHD4 62 CVDSTRK3 63 ASTHMA3 64 ASTHNOW 65 CHCSCNCR 66 CHCOCNCR 67 CHCCOPD 68 HAVARTH3 69 ADDEPEV2 70 CHCKIDNY 71 CHCVISON 72 DIABETE3 73 SMOKE100 74 /* Section 7: Tobacco Use */ SMOKDAY2 75 STOPSMK2 76 LASTSMK2 77-78 USENOW3 79 AGE 80-81 /* Section 8: Demographics */ HISPANC2 82 MRACE $83-88 ORACE2 89 VETERAN3 90 MARITAL 91 CHILDREN 92-93 EDUCA 94 EMPLOY 95 INCOME2 96-97 WEIGHT2 98-101 HEIGHT3 102-105 NUMHHOL2 106 NUMPHON2 107 CPDEMO1 108 CPDEMO2 109 CPDEMO3 110 CPDEMO4 111-113 RENTHOM1 114 SEX 115 PREGNANT 116 FRUITJU1 117-119 /* Section 9: Fruits & Vegetables */ FRUIT1 120-122 FVBEANS 123-125 FVGREEN 126-128 FVORANG 129-131 VEGETAB1 132-134 EXERANY2 135 /* Section 10: Exercise (Physical Activity) */ EXRACT01 136-137 EXEROFT1 138-140 EXERHMM1 141-143 EXRACT02 144-145 EXEROFT2 146-148 EXERHMM2 149-151 STRENGTH 152-154 QLACTLM2 155 /* Section 11: Disability */ USEEQUIP 156 LMTJOIN3 157 /* Section 12: Arthritis Burden */ ARTHDIS2 158 ARTHSOCL 159 JOINPAIN 160-161 SEATBELT 162 /* Section 13: Seatbelt Use */ FLUSHOT5 163 /* Section 14: Immunization */ FLSHTMY2 164-169 IMFVPLAC 170-171 PNEUVAC3 172 ALCDAY5 173-175 /* Section 15: Alcohol Consumption */ AVEDRNK2 176-177 DRNK3GE5 178-179 MAXDRNKS 180-181 HIVTST6 182 /* Section 16: HIV/AIDS */ HIVTSTD3 183-188 HIVRISK3 189 QSTVER 190-191 /* Questionnaire Version */ _STSTR 192-196 _RAWRAKE 197-206 _WT2RAKE 207-216 _RFHLTH 217 /* Section 1: Calculated Variables */ _HCVU651 218 /* Section 3: Calculated Variables */ _RFHYPE5 219 /* Section 4: Calculated Variables */ _CHOLCHK 220 /* Section 5: Calculated Variables */ _RFCHOL 221 _LTASTH1 222 /* Section 6: Calculated Variables */ _CASTHM1 223 _ASTHMS1 224 _DRDXAR1 225 _SMOKER3 226 /* Section 7: Calculated Variables */ _RFSMOK3 227 MRACEORG $228-233 /* Section 8: Calculated Race Variables */ MRACEASC 234-239 _PRACE 240-241 _MRACE 242-243 RACE2 244 _RACEG2 245 _RACEGR2 246 _RACE_G 247 _CNRACE 248 _CNRACEC 249 _AGEG5YR 250-251 _AGE65YR 252 _AGE_G 253 HTIN4 254-256 HTM4 257-259 WTKG3 260-264 _BMI5 265-268 _BMI5CAT 269 _RFBMI5 270 _CHLDCNT 271 _EDUCAG 272 _INCOMG 273 FTJUDA1_ 274-277 /* Section 9: Calculated Variables */ FRUTDA1_ 278-281 BEANDAY_ 282-285 GRENDAY_ 286-289 ORNGDAY_ 290-293 VEGEDA1_ 294-297 _MISFRTN 298 _MISVEGN 299 _FRTRESP 300 _VEGRESP 301 _FRUTSUM 302-307 _VEGESUM 308-313 _FRT16 314 _VEG23 315 _FRUITEX 316 _VEGETEX 317 _TOTINDA 318 /* Section 10: Calculated Variables */ METVAL1_ 319-321 METVAL2_ 322-324 MAXVO2_ 325-329 FC60_ 330-334 ACTINT1_ 335 ACTINT2_ 336 PADUR1_ 337-339 PADUR2_ 340-342 PAFREQ1_ 343-347 PAFREQ2_ 348-352 _MINACT1 353-357 _MINACT2 358-362 STRFREQ_ 363-367 PAMISS_ 368 PAMIN1_ 369-373 PAMIN2_ 374-378 PAMIN_ 379-383 PAVIGM1_ 384-388 PAVIGM2_ 389-393 PAVIGMN_ 394-398 _PACAT 399 _PAINDEX 400 _PA150R1 401 _PA300R1 402 _PA3002L 403 _PASTRNG 404 _PAREC 405 _PASTAER 406 _RFSEAT2 407 /* Section 13: Calculated Variables */ _RFSEAT3 408 _FLSHOT5 409 /* Section 14: Calculated Variables */ _PNEUMO2 410 DRNKANY5 411 /* Section 15: Calculated Variables */ DROCDY3_ 412-414 _RFBING5 415 _DRNKDY4 416-419 _DRNKMO4 420-423 _RFDRHV4 424 _RFDRMN4 425 _RFDRWM4 426 _AIDTST3 427 /* Section 16: Calculated Variables */ _MMSAWT 454-463 /* MMSA Weighting and Stratification Variables */ _MMSANAM $464-563 /* MMSA Weighting and Stratification Variables */ _MMSA 564-568 /* MMSA Weighting and Stratification Variables */ ENDOFREC 569 /* 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' NATTMPTS = 'NUMBER OF ATTEMPTS' 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 OR MENTAL HEALTH' HLTHPLN1 = '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' BPHIGH4 = 'EVER TOLD BLOOD PRESSURE HIGH' BPMEDS = 'CURRENTLY TAKING BLOOD PRESSURE MEDICATION' BLOODCHO = 'EVER HAD BLOOD CHOLESTEROL CHECKED' CHOLCHK = 'HOW LONG SINCE CHOLESTEROL CHECKED' TOLDHI2 = 'EVER TOLD BLOOD CHOLESTEROL HIGH' CVDINFR4 = 'EVER DIAGNOSED WITH HEART ATTACK' CVDCRHD4 = 'EVER DIAGNOSED WITH ANGINA OR CORONARY HEART DISEASE' CVDSTRK3 = 'EVER DIAGNOSED WITH A STROKE' ASTHMA3 = 'EVER TOLD HAD ASTHMA' ASTHNOW = 'STILL HAVE ASTHMA' CHCSCNCR = '(EVER TOLD) YOU HAD SKIN CANCER?' CHCOCNCR = '(EVER TOLD) YOU HAD ANY OTHER TYPES OF CANCER?' CHCCOPD = '(EVER TOLD) YOU HAVE (COPD) CHRONIC OBSTRUCTIVE PULMONARY DISEASE, EMPHYSEMA OR CHRONIC BRONCHITIS?' HAVARTH3 = 'TOLD HAVE ARTHRITIS' ADDEPEV2 = 'EVER TOLD YOU HAD A DEPRESSIVE DISORDER' CHCKIDNY = '(EVER TOLD) YOU HAVE KIDNEY DISEASE?' CHCVISON = 'EVER TOLD YOU HAVE VISION OR EYE PROBLEMS?' DIABETE3 = '(EVER TOLD) YOU HAVE DIABETES' SMOKE100 = 'SMOKED AT LEAST 100 CIGARETTES' SMOKDAY2 = 'FREQUENCY OF DAYS NOW SMOKING' STOPSMK2 = 'STOPPED SMOKING IN PAST 12 MONTHS' LASTSMK2 = 'INTERVAL SINCE LAST SMOKED' USENOW3 = 'USE OF SMOKELESS TOBACCO PRODUCTS' AGE = 'REPORTED AGE IN YEARS' HISPANC2 = 'HISPANIC/LATINO' MRACE = 'MULTIPLE RACE' ORACE2 = 'RESPONDENT RACE CHOICE' VETERAN3 = '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' NUMHHOL2 = 'HOUSEHOLD TELEPHONES' NUMPHON2 = 'RESIDENTIAL PHONES' CPDEMO1 = 'DO YOU HAVE A CELL PHONE FOR PERSONAL USE?' CPDEMO2 = 'DO YOU SHARE A CELL PHONE FOR PERSONAL USE?' CPDEMO3 = 'DO YOU USUALLY SHARE THIS CELL PHONE?' CPDEMO4 = 'WHAT PERCENT OF ALL CALLS ARE RECEIVED ON YOUR CELL PHONE?' RENTHOM1 = 'OWN OR RENT HOME' SEX = 'RESPONDENTS SEX' PREGNANT = 'PREGNANCY STATUS' FRUITJU1 = 'HOW MANY TIMES DID YOU DRINK 100% PURE FRUIT JUICES?' FRUIT1 = 'HOW MANY TIMES DID YOU EAT FRUIT?' FVBEANS = 'HOW MANY TIMES DID YOU EAT BEANS OR LENTILS?' FVGREEN = 'HOW MANY TIMES DID YOU EAT DARK GREEN VEGETABLES?' FVORANG = 'HOW MANY TIMES DID YOU EAT ORANGE-COLORED VEGETABLES?' VEGETAB1 = 'HOW MANY TIMES DID YOU EAT OTHER VEGETABLES?' EXERANY2 = 'EXERCISE IN PAST 30 DAYS' EXRACT01 = 'TYPE OF PHYSICAL ACTIVITY' EXEROFT1 = 'HOW MANY TIMES WALKING, RUNNING, JOGGING, OR SWIMMING' EXERHMM1 = 'MINUTES OR HOURS WALKING, RUNNING, JOGGING, OR SWIMMING' EXRACT02 = 'OTHER TYPE OF PHYSICAL ACTIVITY GIVING MOST EXERCISE DURING PAST MONTH' EXEROFT2 = 'HOW MANY TIMES WALKING, RUNNING, JOGGING, OR SWIMMING' EXERHMM2 = 'MINUTES OR HOURS WALKING, RUNNING, JOGGING, OR SWIMMING' STRENGTH = 'HOW MANY TIMES DID YOU DO PHYSICAL ACTIVITIES OR EXERCISES TO STRENGTHEN YOUR MUSCLES?' QLACTLM2 = 'ACTIVITY LIMITATION DUE TO HEALTH PROBLEMS' USEEQUIP = 'HEALTH PROBLEMS REQUIRING SPECIAL EQUIPMENT' LMTJOIN3 = 'LIMITED BECAUSE OF JOINT SYMPTOMS' ARTHDIS2 = 'DOES ARTHRITIS AFFECT WHETHER YOU WORK' ARTHSOCL = 'SOCIAL ACTIVITIES LIMITED BECAUSE OF JOINT SYMPTOMS' JOINPAIN = 'HOW BAD WAS JOINT PAIN' SEATBELT = 'HOW OFTEN USE SEATBELTS IN CAR?' FLUSHOT5 = 'SEASONAL FLU SHOT/SPRAY PAST 12 MOS' FLSHTMY2 = 'WHEN RECEIVED MOST RECENT SEASONAL FLU SHOT/SPRAY' IMFVPLAC = 'WHERE DID YOU GET YOUR LAST FLU SHOT/VACCINE?' PNEUVAC3 = 'PNEUMONIA SHOT EVER' ALCDAY5 = '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' HIVTST6 = 'EVER TESTED HIV' HIVTSTD3 = 'MONTH AND YEAR OF LAST HIV TEST' HIVRISK3 = 'DO ANY HIGH RISK SITUATIONS APPLY' QSTVER = 'QUESTIONNAIRE VERSION IDENTIFIER' _STSTR = 'SAMPLE DESIGN STRATIFICATION VARIABLE' _RFHLTH = 'ADULTS WITH GOOD OR BETTER HEALTH' _HCVU651 = 'RESPONDENTS AGED 18-64 WITH HEALTH CARE COVERAGE' _RFHYPE5 = 'HIGH BLOOD PRESSURE CALCULATED VARIABLE' _CHOLCHK = 'CHOLESTEROL CHECKED CALCULATED VARIABLE' _RFCHOL = 'HIGH CHOLESTEROL CALCULATED VARIABLE' _LTASTH1 = 'LIFETIME ASTHMA CALCULATED VARIABLE' _CASTHM1 = 'CURRENT ASTHMA CALCULATED VARIABLE' _ASTHMS1 = 'COMPUTED ASTHMA STATUS' _DRDXAR1 = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' _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 WEIGHTING' _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' HTIN4 = 'COMPUTED HEIGHT IN INCHES' HTM4 = 'COMPUTED HEIGHT IN METERS' WTKG3 = 'COMPUTED WEIGHT IN KILOGRAMS' _BMI5 = 'COMPUTED BODY MASS INDEX' _BMI5CAT = 'COMPUTED BODY MASS INDEX CATEGORIES' _RFBMI5 = 'OVERWEIGHT OR OBESE CALCULATED VARIABLE' _CHLDCNT = 'COMPUTED NUMBER OF CHILDREN IN HOUSEHOLD' _EDUCAG = 'COMPUTED LEVEL OF EDUCATION COMPLETED CATEGORIES' _INCOMG = 'COMPUTED INCOME CATEGORIES' FTJUDA1_ = 'COMPUTED FRUIT JUICE SERVINGS PER DAY' FRUTDA1_ = 'COMPUTED FRUIT SERVINGS PER DAY' BEANDAY_ = 'COMPUTED BEAN SERVINGS PER DAY' GRENDAY_ = 'COMPUTED DARK GREEN VEGETABLE SERVINGS PER DAY' ORNGDAY_ = 'COMPUTED ORANGE-COLORED VEGETABLE SERVINGS PER DAY' VEGEDA1_ = 'COMPUTED VEGETABLE SERVINGS PER DAY' _MISFRTN = 'THE NUMBER OF MISSING FRUIT RESPONSES' _MISVEGN = 'THE NUMBER OF MISSING VEGETABLE RESPONSES' _FRTRESP = 'MISSING ANY FRUIT RESPONSES' _VEGRESP = 'MISSING ANY VEGETABLE RESPONSES' _FRUTSUM = 'TOTAL FRUITS CONSUMED PER DAY' _VEGESUM = 'TOTAL VEGETABLES CONSUMED PER DAY' _FRT16 = 'REPORTED CONSUMING FRUIT >16/DAY' _VEG23 = 'REPORTED CONSUMING VEGETABLES >23/DAY' _FRUITEX = 'FRUIT EXCLUSION FROM ANALYSES' _VEGETEX = 'VEGETABLE EXCLUSION FROM ANALYSES' _TOTINDA = 'LEISURE TIME PHYSICAL ACTIVITY CALCULATED VARIABLE' METVAL1_ = 'ACTIVITY MET VALUE FOR FIRST ACTIVITY' METVAL2_ = 'ACTIVITY MET VALUE FOR SECOND ACTIVITY' MAXVO2_ = 'ESTIMATED AGE-GENDER SPECIFIC MAXIMUM OXYGEN CONSUMPTION' FC60_ = 'ESTIMATED FUNCTIONAL CAPACITY' ACTINT1_ = 'ESTIMATED ACTIVITY INTENSITY FOR FIRST ACTIVITY' ACTINT2_ = 'ESTIMATED ACTIVITY INTENSITY FOR SECOND ACTIVITY' PADUR1_ = 'MINUTES OF FIRST ACTIVITY' PADUR2_ = 'MINUTES OF SECOND ACTIVITY' PAFREQ1_ = 'PHYSICAL ACTIVITY FREQUENCY PER WEEK FOR FIRST ACTIVITY' PAFREQ2_ = 'PHYSICAL ACTIVITY FREQUENCY PER WEEK FOR SECOND ACTIVITY' _MINACT1 = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR FIRST ACTIVITY' _MINACT2 = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR SECOND ACTIVITY' STRFREQ_ = 'STRENGTH ACTIVITY FREQUENCY PER WEEK' PAMISS_ = 'MISSING PHYSICAL ACTIVITY DATA' PAMIN1_ = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR FIRST ACTIVITY' PAMIN2_ = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR SECOND ACTIVITY' PAMIN_ = 'MINUTES OF TOTAL PHYSICAL ACTIVITY PER WEEK' PAVIGM1_ = 'MINUTES OF VIGOROUS PHYSICAL ACTIVITY PER WEEK FOR FIRST ACTIVITY' PAVIGM2_ = 'MINUTES OF vIGOROUSPHYSICAL ACTIVITY PER WEEK FOR SECOND ACTIVITY' PAVIGMN_ = 'MINUTES OF TOTAL VIGOROUS PHYSICAL ACTIVITY PER WEEK' _PACAT = 'PHYSICAL ACTIVITY CATEGORIES' _PAINDEX = 'PHYSICAL ACTIVITY INDEX' _PA150R1 = '150 MINUTE PHYSICAL ACTIVITY CALCULATED VARIABLE' _PA300R1 = '300 MINUTE PHYSICAL ACTIVITY CALCULATED VARIABLE' _PA3002L = '300 MINUTE PHYSICAL ACTIVITY 2-LEVEL CALCULATED VARIABLE' _PASTRNG = 'MUSCLE STRENGTHENING RECOMMENDATION' _PAREC = 'AEROBIC AND STRENGTHENING GUIDELINE' _PASTAER = 'AEROBIC AND STRENGTHENING (2-LEVEL)' _RFSEAT2 = 'ALWAYS OR NEARLY ALWAYS WEAR SEAT BELTS' _RFSEAT3 = 'ALWAYS WEAR SEAT BELTS' _FLSHOT5 = 'FLU SHOT CALCULATED VARIABLE' _PNEUMO2 = 'PNEUMONIA VACCINATION CALCULATED VARIABLE' DRNKANY5 = 'DRINK ANY ALCOHOLIC BEVERAGES IN PAST 30 DAYS' DROCDY3_ = 'COMPUTED DRINK-OCCASIONS-PER-DAY' _RFBING5 = 'BINGE DRINKING CALCULATED VARIABLE' _DRNKDY4 = 'COMPUTED NUMBER OF DRINKS OF ALCOHOL BEVERAGES PER DAY' _DRNKMO4 = 'COMPUTED TOTAL NUMBER DRINKS A MONTH' _RFDRHV4 = 'HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _RFDRMN4 = 'ADULT MEN HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _RFDRWM4 = 'ADULT WOMEN HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _AIDTST3 = 'EVER BEEN TESTED FOR HIV CALCULATED VARIABLE' _MMSA = 'MMSA CODE (CBSA OR METRO)' MMSA_NAME = ' ' _MMSAWT = 'MMSA-LEVEL WEIGHT' _RAWRAKE = 'RAW WEIGHTING FACTOR USED IN RAKING' _WT2RAKE = 'DESIGN WEIGHT USED IN RAKING' SEQNO = ' ' ; RUN;