**** * FILE NAME: MMSA19_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 FORMAT19.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 08/02/2020 * ****; ** * 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 ASSIGNMENT STATEMENT IS STORED * **; *FILENAME DATAIN '' LRECL = 446 ; ** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2019\MMSA19.ASC' LRECL = 446 * * 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 STATERE1 15 CELPHONE 16 LADULT1 17 COLGSEX 18 LANDSEX 19 RESPSLCT 20 SAFETIME 21 /* Cell Phone Introduction */ CADULT1 22 CELLSEX 23 HHADULT 24-25 SEXVAR 26 /* Respondent Sex */ GENHLTH 27 /* Section 1: Health Status */ PHYSHLTH 28-29 /* Section 2: Healthy Days */ MENTHLTH 30-31 POORHLTH 32-33 HLTHPLN1 34 /* Section 3: Health Care Access */ PERSDOC2 35 MEDCOST 36 CHECKUP1 37 BPHIGH4 38 /* Section 4: Hypertension Awareness */ BPMEDS 39 CHOLCHK2 40 /* Section 5: Cholesterol Awareness */ TOLDHI2 41 CHOLMED2 42 CVDINFR4 43 /* Section 6: Chronic Health Conditions */ CVDCRHD4 44 CVDSTRK3 45 ASTHMA3 46 ASTHNOW 47 CHCSCNCR 48 CHCOCNCR 49 CHCCOPD2 50 ADDEPEV3 51 CHCKDNY2 52 DIABETE4 53 DIABAGE3 54-55 HAVARTH4 56 /* Section 7: Arthritis */ ARTHEXER 57 ARTHEDU 58 LMTJOIN3 59 ARTHDIS2 60 JOINPAI2 61-62 MARITAL 63 EDUCA 64 RENTHOM1 65 NUMHHOL3 66 NUMPHON3 67 CPDEMO1B 68 VETERAN3 69 EMPLOY1 70 CHILDREN 71-72 INCOME2 73-74 WEIGHT2 75-78 HEIGHT3 79-82 PREGNANT 83 DEAF 84 BLIND 85 DECIDE 86 DIFFWALK 87 DIFFDRES 88 DIFFALON 89 SMOKE100 90 /* Section 9: Tobacco Use */ SMOKDAY2 91 STOPSMK2 92 LASTSMK2 93-94 USENOW3 95 ALCDAY5 96-98 /* Section 10: Alcohol Consumption */ AVEDRNK3 99-100 DRNK3GE5 101-102 MAXDRNKS 103-104 EXERANY2 105 /* Section 11: Exercise (Physical Activity) */ EXRACT11 106-107 EXEROFT1 108-110 EXERHMM1 111-113 EXRACT21 114-115 EXEROFT2 116-118 EXERHMM2 119-121 STRENGTH 122-124 FRUIT2 125-127 /* Section 12: Fruits & Vegetables */ FRUITJU2 128-130 FVGREEN1 131-133 FRENCHF1 134-136 POTATOE1 137-139 VEGETAB2 140-142 FLUSHOT7 143 /* Section 13: Immunization */ FLSHTMY3 144-149 TETANUS1 150 PNEUVAC4 151 HIVTST7 152 /* Section 14: HIV/AIDS */ HIVTSTD3 153-158 HIVRISK5 159 _STSTR 160-165 _IMPSEX 166 CAGEG 167 _RFHLTH 168 /* Section 1: Calculated Variables */ _PHYS14D 169 /* Section 2: Calculated Variables */ _MENT14D 170 _HCVU651 171 /* Section 3: Calculated Variables */ _RFHYPE5 172 /* Section 4: Calculated Variables */ _CHOLCH2 173 /* Section 5: Calculated Variables */ _RFCHOL2 174 _MICHD 175 /* Section 6: Calculated Variables */ _LTASTH1 176 _CASTHM1 177 _ASTHMS1 178 _DRDXAR2 179 _LMTACT2 180 /* Section 7: Calculated Variables */ _LMTWRK2 181 _PRACE1 182-183 _MRACE1 184-185 _HISPANC 186 _RACE 187 _RACEG21 188 _RACEGR3 189 _SEX 190 _AGEG5YR 191-192 _AGE65YR 193 _AGE80 194-195 _AGE_G 196 WTKG3 197-201 _BMI5 202-205 _BMI5CAT 206 _RFBMI5 207 _EDUCAG 208 _INCOMG 209 _SMOKER3 210 /* Section 9: Calculated Variables */ _RFSMOK3 211 DRNKANY5 212 /* Section 10: Calculated Variables */ _RFBING5 213 _DRNKWK1 214-218 _RFDRHV7 219 _TOTINDA 220 /* Section 11: Calculated Variables */ MAXVO21_ 221-225 FC601_ 226-230 ACTIN12_ 231 ACTIN22_ 232 _MINAC11 233-237 _MINAC21 238-242 PAMISS2_ 243 PAMIN12_ 244-248 PAMIN22_ 249-253 PA2MIN_ 254-258 PAVIG12_ 259-263 PAVIG22_ 264-268 PA2VIGM_ 269-273 _PACAT2 274 _PAINDX2 275 _PA150R3 276 _PA300R3 277 _PA30022 278 _PASTRNG 279 _PAREC2 280 _PASTAE2 281 FTJUDA2_ 282-285 /* Section 12: Calculated Variables */ FRUTDA2_ 286-289 GRENDA1_ 290-293 FRNCHDA_ 294-297 POTADA1_ 298-301 VEGEDA2_ 302-305 _MISFRT1 306 _MISVEG1 307 _FRTRES1 308 _VEGRES1 309 _FRUTSU1 310-315 _VEGESU1 316-321 _FRTLT1A 322 _VEGLT1A 323 _FRT16A 324 _VEG23A 325 _FRUITE1 326 _VEGETE1 327 _FLSHOT7 328 /* Section 13: Calculated Variables */ _PNEUMO3 329 _AIDTST4 330 /* Section 14: Calculated Variables */ _MMSAWT 331-340 /* MMSA Weighting and Stratification Variables */ MMSANAME $341-440 /* MMSA Weighting and Stratification Variables */ _MMSA 441-445 /* MMSA Weighting and Stratification Variables */ ENDOFREC 446 /* 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' CELPHONE = 'CELLULAR TELEPHONE' LADULT1 = 'ARE YOU 18 YEARS OF AGE OR OLDER?' COLGSEX = 'ARE YOU MALE OR FEMALE?' LANDSEX = 'ARE YOU MALE OR FEMALE?' RESPSLCT = 'RESPONDENT SELECTION' SAFETIME = 'SAFE TIME TO TALK?' CADULT1 = 'ARE YOU 18 YEARS OF AGE OR OLDER?' CELLSEX = 'ARE YOU MALE OR FEMALE?' HHADULT = 'NUMBER OF ADULTS IN HOUSEHOLD' SEXVAR = 'SEX OF RESPONDENT' 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' CHOLCHK2 = 'HOW LONG SINCE CHOLESTEROL CHECKED' TOLDHI2 = 'EVER TOLD BLOOD CHOLESTEROL HIGH' CHOLMED2 = '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?' CHCCOPD2 = '(EVER TOLD) YOU HAD (COPD) CHRONIC OBSTRUCTIVE PULMONARY DISEASE, EMPHYSEMA OR CHRONIC BRO NCHITIS?' ADDEPEV3 = '(EVER TOLD) YOU HAD A DEPRESSIVE DISORDER' CHCKDNY2 = 'EVER TOLD YOU HAVE KIDNEY DISEASE?' DIABETE4 = '(EVER TOLD) YOU HAD DIABETES' DIABAGE3 = 'AGE WHEN TOLD DIABETES' HAVARTH4 = 'TOLD HAVE ARTHRITIS' ARTHEXER = 'DR. SUGGEST USE OF PHYSICAL ACTIVITY OR EXERCISE FOR ARTHRITIS OR JOINT SYMPTOMS' ARTHEDU = 'EVER TAKEN CLASS IN MANAGING ARTHRITIS OR JOINT SYMPTOMS' LMTJOIN3 = 'LIMITED BECAUSE OF JOINT SYMPTOMS' ARTHDIS2 = 'DOES ARTHRITIS AFFECT WHETHER YOU WORK' JOINPAI2 = 'HOW BAD WAS JOINT PAIN' MARITAL = 'MARITAL STATUS' EDUCA = 'EDUCATION LEVEL' RENTHOM1 = 'OWN OR RENT HOME' NUMHHOL3 = 'HOUSEHOLD TELEPHONES' NUMPHON3 = 'RESIDENTIAL PHONES' CPDEMO1B = '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' 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' ALCDAY5 = 'DAYS IN PAST 30 HAD ALCOHOLIC BEVERAGE' AVEDRNK3 = 'AVG ALCOHOLIC DRINKS PER DAY IN PAST 30' DRNK3GE5 = 'BINGE DRINKING' MAXDRNKS = 'MOST DRINKS ON SINGLE OCCASION PAST 30 DAYS' 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?' 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?' FLUSHOT7 = 'ADULT FLU SHOT/SPRAY PAST 12 MOS' FLSHTMY3 = 'WHEN RECEIVED MOST RECENT SEASONAL FLU SHOT/SPRAY' TETANUS1 = 'RECEIVED TETANUS SHOT SINCE 2005?' PNEUVAC4 = 'PNEUMONIA SHOT EVER' HIVTST7 = 'EVER TESTED H.I.V.' HIVTSTD3 = 'MONTH AND YEAR OF LAST HIV TEST' HIVRISK5 = 'DO ANY HIGH RISK SITUATIONS APPLY' _STSTR = 'SAMPLE DESIGN STRATIFICATION VARIABLE' _IMPSEX = 'IMPUTED GENDER' CAGEG = 'FOUR LEVEL CHILD AGE' _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' _CHOLCH2 = 'CHOLESTEROL CHECKED CALCULATED VARIABLE' _RFCHOL2 = 'HIGH CHOLESTEROL CALCULATED VARIABLE' _MICHD = 'RESPONDENTS THAT HAVE EVER REPORTED HAVING CORONARY HEART DISEASE (CHD) OR MYOCARDIAL INFARC TION (MI' _LTASTH1 = 'LIFETIME ASTHMA CALCULATED VARIABLE' _CASTHM1 = 'CURRENT ASTHMA CALCULATED VARIABLE' _ASTHMS1 = 'COMPUTED ASTHMA STATUS' _DRDXAR2 = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' _LMTACT2 = 'LIMITED USUAL ACTIVITIES' _LMTWRK2 = 'LIMITED WORK 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 IN PO ST-STRATIF' _RACEGR3 = 'COMPUTED FIVE LEVEL RACE/ETHNICITY CATEGORY.' _SEX = 'CALCULATED SEX VARIABLE' _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' DRNKANY5 = 'DRINK ANY ALCOHOLIC BEVERAGES IN PAST 30 DAYS' _RFBING5 = 'BINGE DRINKING CALCULATED VARIABLE' _DRNKWK1 = 'COMPUTED NUMBER OF DRINKS OF ALCOHOL BEVERAGES PER WEEK' _RFDRHV7 = 'HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _TOTINDA = 'LEISURE TIME PHYSICAL ACTIVITY CALCULATED VARIABLE' MAXVO21_ = 'ESTIMATED AGE-GENDER SPECIFIC MAXIMUM OXYGEN CONSUMPTION' FC601_ = 'ESTIMATED FUNCTIONAL CAPACITY' ACTIN12_ = 'ESTIMATED ACTIVITY INTENSITY FOR FIRST ACTIVITY' ACTIN22_ = 'ESTIMATED ACTIVITY INTENSITY FOR SECOND ACTIVITY' _MINAC11 = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR FIRST ACTIVITY' _MINAC21 = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR SECOND ACTIVITY' PAMISS2_ = 'MISSING PHYSICAL ACTIVITY DATA' PAMIN12_ = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR FIRST ACTIVITY' PAMIN22_ = 'MINUTES OF PHYSICAL ACTIVITY PER WEEK FOR SECOND ACTIVITY' PA2MIN_ = 'MINUTES OF TOTAL PHYSICAL ACTIVITY PER WEEK' PAVIG12_ = 'MINUTES OF VIGOROUS PHYSICAL ACTIVITY PER WEEK FOR FIRST ACTIVITY' PAVIG22_ = 'MINUTES OF VIGOROUSPHYSICAL ACTIVITY PER WEEK FOR SECOND ACTIVITY' PA2VIGM_ = 'MINUTES OF TOTAL VIGOROUS PHYSICAL ACTIVITY PER WEEK' _PACAT2 = 'PHYSICAL ACTIVITY CATEGORIES' _PAINDX2 = 'PHYSICAL ACTIVITY INDEX' _PA150R3 = '150 MINUTE PHYSICAL ACTIVITY CALCULATED VARIABLE' _PA300R3 = '300 MINUTE PHYSICAL ACTIVITY CALCULATED VARIABLE' _PA30022 = '300 MINUTE PHYSICAL ACTIVITY 2-LEVEL CALCULATED VARIABLE' _PASTRNG = 'MUSCLE STRENGTHENING RECOMMENDATION' _PAREC2 = 'AEROBIC AND STRENGTHENING GUIDELINE' _PASTAE2 = 'AEROBIC AND STRENGTHENING (2-LEVEL)' 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' _FLSHOT7 = 'FLU SHOT CALCULATED VARIABLE' _PNEUMO3 = 'PNEUMONIA VACCINATION CALCULATED VARIABLE' _AIDTST4 = 'EVER BEEN TESTED FOR HIV CALCULATED VARIABLE' _MMSA = 'MMSA CODE (CBSA OR METRO)' _MMSAWT = 'MMSA-LEVEL WEIGHT' SEQNO = 'SEQUENCE NUMBER' ; RUN;