***************************************************************************************** * FILE NAME: MMSA17_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 FORMAT17.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 10/05/2018 * *****************************************************************************************; ******************************** * 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 = 435 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2017\MMSA17.ASC' LRECL = 435 * * 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 DISPCODE 1-4 SEQNO 5-14 STATERE1 15 SAFETIME 16 /* Cell Phone Introduction */ HHADULT 17-18 GENHLTH 19 /* Section 1: Health Status */ PHYSHLTH 20-21 /* Section 2: Healthy Days — Health Related Quality of Life */ MENTHLTH 22-23 POORHLTH 24-25 HLTHPLN1 26 /* Section 3: Health Care Access */ PERSDOC2 27 MEDCOST 28 CHECKUP1 29 BPHIGH4 30 /* Section 4: Hypertension Awareness */ BPMEDS 31 CHOLCHK1 32 /* Section 5: Cholesterol Awareness */ TOLDHI2 33 CHOLMED1 34 CVDINFR4 35 /* Section 6: Chronic Health Conditions */ CVDCRHD4 36 CVDSTRK3 37 ASTHMA3 38 ASTHNOW 39 CHCSCNCR 40 CHCOCNCR 41 CHCCOPD1 42 HAVARTH3 43 ADDEPEV2 44 CHCKIDNY 45 DIABETE3 46 DIABAGE2 47-48 LMTJOIN3 49 /* Section 7: Arthritis Burden */ ARTHDIS2 50 ARTHSOCL 51 JOINPAI1 52-53 SEX 54 /* Section 8: Demographics */ MARITAL 55 EDUCA 56 RENTHOM1 57 NUMHHOL2 58 NUMPHON2 59 CPDEMO1A 60 VETERAN3 61 EMPLOY1 62 CHILDREN 63-64 INCOME2 65-66 INTERNET 67 WEIGHT2 68-71 HEIGHT3 72-75 PREGNANT 76 DEAF 77 BLIND 78 DECIDE 79 DIFFWALK 80 DIFFDRES 81 DIFFALON 82 SMOKE100 83 /* Section 9: Tobacco Use */ SMOKDAY2 84 STOPSMK2 85 LASTSMK2 86-87 USENOW3 88 ECIGARET 89 /* Section 10: E-Cigarettes */ ECIGNOW 90 ALCDAY5 91-93 /* Section 11: Alcohol Consumption */ AVEDRNK2 94-95 DRNK3GE5 96-97 MAXDRNKS 98-99 FRUIT2 100-102 /* Section 12: Fruits & Vegetables */ FRUITJU2 103-105 FVGREEN1 106-108 FRENCHF1 109-111 POTATOE1 112-114 VEGETAB2 115-117 EXERANY2 118 /* Section 13: Exercise (Physical Activity) */ EXRACT11 119-120 EXEROFT1 121-123 EXERHMM1 124-126 EXRACT21 127-128 EXEROFT2 129-131 EXERHMM2 132-134 STRENGTH 135-137 SEATBELT 138 /* Section 14: Seatbelt Use */ FLUSHOT6 139 /* Section 15: Immunization */ FLSHTMY2 140-145 PNEUVAC3 146 SHINGLE2 147 HIVTST6 148 /* Section 16: HIV/AIDS */ HIVTSTD3 149-154 HIVRISK5 155 CASTHDX2 156 /* Module 29: Childhood Asthma Prevalence */ CASTHNO2 157 CALLBCKZ /* Zika/Reproductive Health Call Back */ WDUSENOW /* Standardized Wearable Device Questions */ WDINFTRK $160-164 WDHOWOFT WDSHARE NAMTRIBE /* Native American oversample */ NAMOTHR $168-187 _URBNRRL 188 /* Urban Rural */ _STSTR 189-194 _IMPSEX 195 _RFHLTH 196 /* Section 1: Calculated Variables */ _PHYS14D 197 /* Section 2: Calculated Variables */ _MENT14D 198 _HCVU651 199 /* Section 3: Calculated Variables */ _RFHYPE5 200 /* Section 4: Calculated Variables */ _CHOLCH1 201 /* Section 5: Calculated Variables */ _RFCHOL1 202 _MICHD 203 /* Section 6: Calculated Variables */ _LTASTH1 204 _CASTHM1 205 _ASTHMS1 206 _DRDXAR1 207 _LMTACT1 208 /* Section 7: Calculated Variables */ _LMTWRK1 209 _LMTSCL1 210 _PRACE1 211-212 _MRACE1 213-214 _HISPANC 215 _RACE 216 _RACEG21 217 _RACEGR3 218 _AGEG5YR 219-220 _AGE65YR 221 _AGE80 222-223 _AGE_G 224 WTKG3 225-229 _BMI5 230-233 _BMI5CAT 234 _RFBMI5 235 _EDUCAG 236 _INCOMG 237 _SMOKER3 238 /* Section 9: Calculated Variables */ _RFSMOK3 239 _ECIGSTS 240 /* Section 10: Calculated Variables */ _CURECIG 241 DRNKANY5 242 /* Section 11: Calculated Variables */ _RFBING5 243 _DRNKWEK 244-248 _RFDRHV5 249 FTJUDA2_ 250-253 /* Section 12: Calculated Variables */ FRUTDA2_ 254-257 GRENDA1_ 258-261 FRNCHDA_ 262-265 POTADA1_ 266-269 VEGEDA2_ 270-273 _MISFRT1 274 _MISVEG1 275 _FRTRES1 276 _VEGRES1 277 _FRUTSU1 278-283 _VEGESU1 284-289 _FRTLT1A 290 _VEGLT1A 291 _FRT16A 292 _VEG23A 293 _FRUITE1 294 _VEGETE1 295 _TOTINDA 296 /* Section 13: Calculated Variables */ _MINAC11 297-301 _MINAC21 302-306 _PACAT1 307 _PAINDX1 308 _PA150R2 309 _PA300R2 310 _PA30021 311 _PASTRNG 312 _PAREC1 313 _PASTAE1 314 _RFSEAT2 315 /* Section 14: Calculated Variables */ _RFSEAT3 316 _FLSHOT6 317 /* Section 15: Calculated Variables */ _PNEUMO2 318 _AIDTST3 319 /* Section 16: Calculated Variables */ _MMSAWT 320-329 /* MMSA Weighting and Stratification Variables */ MMSANAME $330-429 /* MMSA Weighting and Stratification Variables */ _MMSA 430-434 /* MMSA Weighting and Stratification Variables */ ENDOFREC 435 /* 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 DISPCODE = 'FINAL DISPOSITION' STATERE1 = 'RESIDENT OF STATE' SAFETIME = 'SAFE TIME TO TALK?' HHADULT = 'NUMBER OF ADULTS 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' CHOLCHK1 = 'HOW LONG SINCE CHOLESTEROL CHECKED' TOLDHI2 = 'EVER TOLD BLOOD CHOLESTEROL HIGH' CHOLMED1 = 'CURRENTLY TAKING MEDICINE FOR HIGH CHOLESTEROL' 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?' CHCCOPD1 = '(EVER TOLD) YOU HAVE (COPD) CHRONIC OBSTRUCTIVE PULMONARY DISEASE, EMPHYSEMA OR CHRONI C BRONCHITIS?' HAVARTH3 = 'TOLD HAVE ARTHRITIS' ADDEPEV2 = 'EVER TOLD YOU HAD A DEPRESSIVE DISORDER' CHCKIDNY = '(EVER TOLD) YOU HAVE KIDNEY DISEASE?' DIABETE3 = '(EVER TOLD) YOU HAVE DIABETES' DIABAGE2 = 'AGE WHEN TOLD DIABETIC' LMTJOIN3 = 'LIMITED BECAUSE OF JOINT SYMPTOMS' ARTHDIS2 = 'DOES ARTHRITIS AFFECT WHETHER YOU WORK' ARTHSOCL = 'SOCIAL ACTIVITIES LIMITED BECAUSE OF JOINT SYMPTOMS' JOINPAI1 = 'HOW BAD WAS JOINT PAIN' SEX = 'RESPONDENTS SEX' MARITAL = 'MARITAL STATUS' EDUCA = 'EDUCATION LEVEL' RENTHOM1 = 'OWN OR RENT HOME' NUMHHOL2 = 'HOUSEHOLD TELEPHONES' NUMPHON2 = 'RESIDENTIAL PHONES' CPDEMO1A = 'DO YOU HAVE A CELL PHONE FOR PERSONAL USE?' VETERAN3 = 'ARE YOU A VETERAN' EMPLOY1 = 'EMPLOYMENT STATUS' CHILDREN = 'NUMBER OF CHILDREN IN HOUSEHOLD' INCOME2 = 'INCOME LEVEL' INTERNET = 'INTERNET USE IN THE PAST 30 DAYS?' WEIGHT2 = 'REPORTED WEIGHT IN POUNDS' HEIGHT3 = 'REPORTED HEIGHT IN FEET AND INCHES' PREGNANT = 'PREGNANCY STATUS' DEAF = 'ARE YOU DEAF OR DO YOU HAVE SERIOUS DIFFICULTY HEARING?' BLIND = 'BLIND OR DIFFICULTY SEEING' DECIDE = 'DIFFICULTY CONCENTRATING OR REMEMBERING' DIFFWALK = 'DIFFICULTY WALKING OR CLIMBING STAIRS' DIFFDRES = 'DIFFICULTY DRESSING OR BATHING' DIFFALON = 'DIFFICULTY DOING ERRANDS ALONE' 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' ECIGARET = 'HAVE YOU EVER USED AN E-CIGARETTE OR OTHER ELECTRONIC “VAPING” PRODUCT?' ECIGNOW = 'DO YOU NOW USE E-CIGARETTES, EVERY DAY, SOME DAYS, OR NOT AT ALL?' 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' FRUIT2 = 'HOW MANY TIMES DID YOU EAT FRUIT?' FRUITJU2 = 'HOW MANY TIMES DID YOU DRINK 100 PERCENT PURE FRUIT JUICES?' FVGREEN1 = 'HOW MANY TIMES DID YOU EAT DARK GREEN VEGETABLES?' FRENCHF1 = 'HOW OFTEN DO YOU EAT FRENCH FRIES OR FRIED POTATOES?' POTATOE1 = 'HOW OFTEN DO YOU EAT FRENCH FRIES OR FRIED POTATOES?' VEGETAB2 = 'HOW OFTEN DO YOU EAT FRENCH FRIES OR FRIED POTATOES?' EXERANY2 = 'EXERCISE IN PAST 30 DAYS' EXRACT11 = 'TYPE OF PHYSICAL ACTIVITY' EXEROFT1 = 'HOW MANY TIMES WALKING, RUNNING, JOGGING, OR SWIMMING' EXERHMM1 = 'MINUTES OR HOURS WALKING, RUNNING, JOGGING, OR SWIMMING' EXRACT21 = '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? ' SEATBELT = 'HOW OFTEN USE SEATBELTS IN CAR?' FLUSHOT6 = 'ADULT FLU SHOT/SPRAY PAST 12 MOS' FLSHTMY2 = 'WHEN RECEIVED MOST RECENT SEASONAL FLU SHOT/SPRAY' PNEUVAC3 = 'PNEUMONIA SHOT EVER' SHINGLE2 = 'HAVE YOU EVER HAD THE SHINGLES OR ZOSTER VACCINE?' HIVTST6 = 'EVER TESTED HIV' HIVTSTD3 = 'MONTH AND YEAR OF LAST HIV TEST' HIVRISK5 = 'DO ANY HIGH RISK SITUATIONS APPLY' CASTHDX2 = 'HLTH PRO EVER SAID CHILD HAS ASTHMA' CASTHNO2 = 'CHILD STILL HAVE ASTHMA?' CALLBCKZ = 'ZIKA CALL BACK REQUEST' WDUSENOW = 'DO YOU TRACK INFORMATION ON WEARABLE DEVICE?' WDINFTRK = 'WHAT INFORMATION DO YOU TRACK INFORMATION ON WEARABLE DEVICE?' WDHOWOFT = 'HOW OFTEN DO YOU ENTER INFORMATION ON WEARABLE DEVICE?' WDSHARE = 'WOULD YOU BE WILLING TO SHARE INFORMATION FROM WEARABLE DEVICE?' NAMTRIBE = 'WHAT IS YOUR MAIN TRIBE?' NAMOTHR = 'TRIBAL AFFILIATION OTHER RESPONSE' _URBNRRL = 'NCHS URBAN-RURAL CLASSIFICATION' _STSTR = 'SAMPLE DESIGN STRATIFICATION VARIABLE' _IMPSEX = 'IMPUTED GENDER' _RFHLTH = 'ADULTS WITH GOOD OR BETTER HEALTH' _PHYS14D = 'COMPUTED PHYSICAL HEALTH STATUS' _MENT14D = 'COMPUTED MENTAL HEALTH STATUS' _HCVU651 = 'RESPONDENTS AGED 18-64 WITH HEALTH CARE COVERAGE' _RFHYPE5 = 'HIGH BLOOD PRESSURE CALCULATED VARIABLE' _CHOLCH1 = 'CHOLESTEROL CHECKED CALCULATED VARIABLE' _RFCHOL1 = 'HIGH CHOLESTEROL CALCULATED VARIABLE' _MICHD = 'RESPONDENTS THAT HAVE EVER REPORTED HAVING CORONARY HEART DISEASE (CHD) OR MYOCARDIAL IN FARCTION (MI' _LTASTH1 = 'LIFETIME ASTHMA CALCULATED VARIABLE' _CASTHM1 = 'CURRENT ASTHMA CALCULATED VARIABLE' _ASTHMS1 = 'COMPUTED ASTHMA STATUS' _DRDXAR1 = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' _LMTACT1 = 'LIMITED USUAL ACTIVITIES' _LMTWRK1 = 'LIMITED WORK ACTIVITIES' _LMTSCL1 = 'LIMITED SOCIAL ACTIVITIES' _PRACE1 = 'COMPUTED PREFERRED RACE' _MRACE1 = 'CALCULATED NON-HISPANIC RACE INCLUDING MULTIRACIAL' _HISPANC = 'HISPANIC, LATINO/A, OR SPANISH ORIGIN CALCULATED VARIABLE' _RACE = 'COMPUTED RACE-ETHNICITY GROUPING' _RACEG21 = 'COMPUTED NON-HISPANIC WHITES/ALL OTHERS RACE CATEGORIES RACE/ETHNIC GROUP CODES USED I N POST-STRATIF' _RACEGR3 = 'COMPUTED FIVE LEVEL RACE/ETHNICITY CATEGORY.' _AGEG5YR = 'REPORTED AGE IN FIVE-YEAR AGE CATEGORIES CALCULATED VARIABLE' _AGE65YR = 'REPORTED AGE IN TWO AGE GROUPS CALCULATED VARIABLE' _AGE80 = 'IMPUTED AGE VALUE COLLAPSED ABOVE 80' _AGE_G = 'IMPUTED AGE IN SIX GROUPS' WTKG3 = 'COMPUTED WEIGHT IN KILOGRAMS' _BMI5 = 'COMPUTED BODY MASS INDEX' _BMI5CAT = 'COMPUTED BODY MASS INDEX CATEGORIES' _RFBMI5 = 'OVERWEIGHT OR OBESE CALCULATED VARIABLE' _EDUCAG = 'COMPUTED LEVEL OF EDUCATION COMPLETED CATEGORIES' _INCOMG = 'COMPUTED INCOME CATEGORIES' _SMOKER3 = 'COMPUTED SMOKING STATUS' _RFSMOK3 = 'CURRENT SMOKING CALCULATED VARIABLE' _ECIGSTS = 'COMPUTED E-CIGARETTE USER STATUS' _CURECIG = 'CURRENT E-CIGARETTE USER CALCULATED VARIABLE' DRNKANY5 = 'DRINK ANY ALCOHOLIC BEVERAGES IN PAST 30 DAYS' _RFBING5 = 'BINGE DRINKING CALCULATED VARIABLE' _DRNKWEK = 'COMPUTED NUMBER OF DRINKS OF ALCOHOL BEVERAGES PER WEEK' _RFDRHV5 = 'HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' FTJUDA2_ = 'COMPUTED FRUIT JUICE INTAKE IN TIMES PER DAY' FRUTDA2_ = 'COMPUTED FRUIT INTAKE IN TIMES PER DAY' GRENDA1_ = 'COMPUTED DARK GREEN VEGETABLE INTAKE IN TIMES PER DAY' FRNCHDA_ = 'FRENCH FRY INTAKE IN TIMES PER DAY' POTADA1_ = 'COMPUTED POTATO SERVINGS PER DAY' VEGEDA2_ = 'COMPUTED OTHER VEGETABLE INTAKE IN TIMES PER DAY' _MISFRT1 = 'THE NUMBER OF MISSING FRUIT RESPONSES' _MISVEG1 = 'THE NUMBER OF MISSING VEGETABLE RESPONSES' _FRTRES1 = 'MISSING ANY FRUIT RESPONSES' _VEGRES1 = 'MISSING ANY VEGETABLE RESPONSES' _FRUTSU1 = 'TOTAL FRUITS CONSUMED PER DAY' _VEGESU1 = 'TOTAL VEGETABLES CONSUMED PER DAY' _FRTLT1A = 'CONSUME FRUIT 1 OR MORE TIMES PER DAY' _VEGLT1A = 'CONSUME VEGETABLES 1 OR MORE TIMES PER DAY' _FRT16A = 'REPORTED CONSUMING FRUIT >16/DAY' _VEG23A = 'REPORTED CONSUMING VEGETABLES >23/DAY' _FRUITE1 = 'FRUIT EXCLUSION FROM ANALYSES' _VEGETE1 = 'VEGETABLE EXCLUSION FROM ANALYSES' _TOTINDA = 'LEISURE TIME PHYSICAL ACTIVITY CALCULATED VARIABLE' _MINAC11 = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR FIRST ACTIVITY' _MINAC21 = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR SECOND ACTIVITY' _PACAT1 = 'PHYSICAL ACTIVITY CATEGORIES' _PAINDX1 = 'PHYSICAL ACTIVITY INDEX' _PA150R2 = '150 MINUTE PHYSICAL ACTIVITY CALCULATED VARIABLE' _PA300R2 = '300 MINUTE PHYSICAL ACTIVITY CALCULATED VARIABLE' _PA30021 = '300 MINUTE PHYSICAL ACTIVITY 2-LEVEL CALCULATED VARIABLE' _PASTRNG = 'MUSCLE STRENGTHENING RECOMMENDATION' _PAREC1 = 'AEROBIC AND STRENGTHENING GUIDELINE' _PASTAE1 = 'AEROBIC AND STRENGTHENING (2-LEVEL)' _RFSEAT2 = 'ALWAYS OR NEARLY ALWAYS WEAR SEAT BELTS' _RFSEAT3 = 'ALWAYS WEAR SEAT BELTS' _FLSHOT6 = 'FLU SHOT CALCULATED VARIABLE' _PNEUMO2 = 'PNEUMONIA VACCINATION CALCULATED VARIABLE' _AIDTST3 = 'EVER BEEN TESTED FOR HIV CALCULATED VARIABLE' _MMSA = 'MMSA CODE (CBSA OR METRO)' _MMSAWT = 'MMSA-LEVEL WEIGHT' SEQNO = 'SEQUENCE NUMBER' ; RUN;