**** * FILE NAME: MMSA21_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 FORMAT21.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 10/28/2022 * ****; ** * 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 = 368 ; ** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2021\MMSA21.ASC' LRECL = 368 * * 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 CELPHON1 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 PRIMINSR 34-35 /* Section 3: Health Care Access */ PERSDOC3 36 MEDCOST1 37 CHECKUP1 38 EXERANY2 39 /* Section 4: Exercise */ BPHIGH6 40 /* Section 5: Hypertension Awareness */ BPMEDS 41 CHOLCHK3 42 /* Section 6: Cholesterol Awareness */ TOLDHI3 43 CHOLMED3 44 CVDINFR4 45 /* Section 7: Chronic Health Conditions */ CVDCRHD4 46 CVDSTRK3 47 ASTHMA3 48 ASTHNOW 49 CHCSCNCR 50 CHCOCNCR 51 CHCCOPD3 52 ADDEPEV3 53 CHCKDNY2 54 DIABETE4 55 DIABAGE3 56-57 HAVARTH5 58 /* Section 8: Arthritis */ ARTHEXER 59 ARTHEDU 60 LMTJOIN3 61 ARTHDIS2 62 JOINPAI2 63-64 MARITAL 65 EDUCA 66 RENTHOM1 67 NUMHHOL3 68 NUMPHON3 69 CPDEMO1B 70 VETERAN3 71 EMPLOY1 72 CHILDREN 73-74 INCOME3 75-76 PREGNANT 77 WEIGHT2 78-81 HEIGHT3 82-85 DEAF 86 /* Section 10: Disability */ BLIND 87 DECIDE 88 DIFFWALK 89 DIFFDRES 90 DIFFALON 91 SMOKE100 92 /* Section 11: Tobacco Use */ SMOKDAY2 93 USENOW3 94 ECIGNOW1 95 ALCDAY5 96-98 /* Section 12: Alcohol Consumption */ AVEDRNK3 99-100 DRNK3GE5 101-102 MAXDRNKS 103-104 FLUSHOT7 105 /* Section 13: Immunization */ FLSHTMY3 106-111 IMFVPLA2 112-113 PNEUVAC4 114 HIVTST7 115 /* Section 14: HIV/AIDS */ HIVTSTD3 116-121 FRUIT2 122-124 /* Section 15: Fruits & Vegetables */ FRUITJU2 125-127 FVGREEN1 128-130 FRENCHF1 131-133 POTATOE1 134-136 VEGETAB2 137-139 _STSTR 140-145 _IMPSEX 146 CAGEG 147 _RFHLTH 148 /* Section 1: Calculated Variables */ _PHYS14D 149 /* Section 2: Calculated Variables */ _MENT14D 150 _HLTHPLN 151 /* Section 3: Calculated Variables */ _HCVU652 152 _TOTINDA 153 /* Section 4: Calculated Variables */ _RFHYPE6 154 /* Section 5: Calculated Variables */ _CHOLCH3 155 /* Section 6: Calculated Variables */ _RFCHOL3 156 _MICHD 157 /* Section 7: Calculated Variables */ _LTASTH1 158 _CASTHM1 159 _ASTHMS1 160 _DRDXAR3 161 /* Section 8: Calculated Variables */ _LMTACT3 162 _LMTWRK3 163 _PRACE1 164-165 _MRACE1 166-167 _HISPANC 168 _RACE 169 _RACEG21 170 _RACEGR3 171 _RACEPRV 172 _SEX 173 _AGEG5YR 174-175 _AGE65YR 176 _AGE80 177-178 _AGE_G 179 WTKG3 180-184 _BMI5 185-188 _BMI5CAT 189 _RFBMI5 190 _EDUCAG 191 _INCOMG1 192 _SMOKER3 193 /* Section 11: Calculated Variables */ _RFSMOK3 194 _CURECI1 195 DRNKANY5 196 /* Section 12: Calculated Variables */ _RFBING5 197 _DRNKWK1 198-202 _RFDRHV7 203 _FLSHOT7 204 /* Section 13: Calculated Variables */ _PNEUMO3 205 _AIDTST4 206 /* Section 14: Calculated Variables */ FTJUDA2_ 207-210 /* Section 15: Calculated Variables */ FRUTDA2_ 211-214 GRENDA1_ 215-218 FRNCHDA_ 219-222 POTADA1_ 223-226 VEGEDA2_ 227-230 _MISFRT1 231 _MISVEG1 232 _FRTRES1 233 _VEGRES1 234 _FRUTSU1 235-240 _VEGESU1 241-246 _FRTLT1A 247 _VEGLT1A 248 _FRT16A 249 _VEG23A 250 _FRUITE1 251 _VEGETE1 252 _MMSAWT 253-262 /* MMSA Weighting and Stratification Variables */ MMSANAME $263-362 /* MMSA Weighting and Stratification Variables */ _MMSA 363-367 /* MMSA Weighting and Stratification Variables */ ENDOFREC 368 /* 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' CELPHON1 = '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' PRIMINSR = 'WHAT IS PRIMARY SOURCE OF HEALTH INSURANCE?' PERSDOC3 = 'HAVE PERSONAL HEALTH CARE PROVIDER?' MEDCOST1 = 'COULD NOT AFFORD TO SEE DOCTOR' CHECKUP1 = 'LENGTH OF TIME SINCE LAST ROUTINE CHECKUP' EXERANY2 = 'EXERCISE IN PAST 30 DAYS' BPHIGH6 = 'EVER TOLD BLOOD PRESSURE HIGH' BPMEDS = 'CURRENTLY TAKING BLOOD PRESSURE MEDICATION' CHOLCHK3 = 'HOW LONG SINCE CHOLESTEROL CHECKED' TOLDHI3 = 'EVER TOLD CHOLESTEROL IS HIGH' CHOLMED3 = '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?' CHCCOPD3 = 'EVER TOLD YOU HAD C.O.P.D. EMPHYSEMA OR CHRONIC BRONCHITIS?' 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' HAVARTH5 = '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' INCOME3 = 'INCOME LEVEL' PREGNANT = 'PREGNANCY STATUS' WEIGHT2 = 'REPORTED WEIGHT IN POUNDS' HEIGHT3 = 'REPORTED HEIGHT IN FEET AND INCHES' 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' USENOW3 = 'USE OF SMOKELESS TOBACCO PRODUCTS' ECIGNOW1 = 'DO YOU NOW USE E-CIGARETTES, EVERY DAY, SOME DAYS, OR NOT AT ALL?' 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' FLUSHOT7 = 'ADULT FLU SHOT/SPRAY PAST 12 MOS' FLSHTMY3 = 'WHEN RECEIVED MOST RECENT SEASONAL FLU SHOT/SPRAY' IMFVPLA2 = 'WHERE DID YOU GET YOUR LAST FLU SHOT/VACCINE?' PNEUVAC4 = 'PNEUMONIA SHOT EVER' HIVTST7 = 'EVER TESTED H.I.V.' HIVTSTD3 = 'MONTH AND YEAR OF LAST HIV TEST' 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?' _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' _HLTHPLN = 'HAVE ANY HEALTH INSURANCE' _HCVU652 = 'RESPONDENTS AGED 18-64 WITH HEALTH INSURANCE' _TOTINDA = 'LEISURE TIME PHYSICAL ACTIVITY CALCULATED VARIABLE' _RFHYPE6 = 'HIGH BLOOD PRESSURE CALCULATED VARIABLE' _CHOLCH3 = 'CHOLESTEROL CHECKED CALCULATED VARIABLE' _RFCHOL3 = 'HIGH CHOLESTEROL CALCULATED VARIABLE' _MICHD = 'RESPONDENTS THAT HAVE EVER REPORTED HAVING CORONARY HEART DISEASE (CHD) OR MYOCARDIAL INFARCTION (MI' _LTASTH1 = 'LIFETIME ASTHMA CALCULATED VARIABLE' _CASTHM1 = 'CURRENT ASTHMA CALCULATED VARIABLE' _ASTHMS1 = 'COMPUTED ASTHMA STATUS' _DRDXAR3 = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' _LMTACT3 = 'LIMITED USUAL ACTIVITIES' _LMTWRK3 = '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 POST-STRATIF' _RACEGR3 = 'COMPUTED FIVE LEVEL RACE/ETHNICITY CATEGORY.' _RACEPRV = 'COMPUTED RACE GROUPS USED FOR INTERNET PREVALENCE TABLES' _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' _INCOMG1 = 'COMPUTED INCOME CATEGORIES' _SMOKER3 = 'COMPUTED SMOKING STATUS' _RFSMOK3 = 'CURRENT SMOKING CALCULATED VARIABLE' _CURECI1 = 'CURRENT E-CIGARETTE USER 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' _FLSHOT7 = 'FLU SHOT CALCULATED VARIABLE' _PNEUMO3 = 'PNEUMONIA VACCINATION CALCULATED VARIABLE' _AIDTST4 = 'EVER BEEN TESTED FOR HIV 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' _MMSA = 'MMSA CODE (CBSA OR METRO)' _MMSAWT = 'MMSA-LEVEL WEIGHT' SEQNO = 'SEQUENCE NUMBER' ; RUN;