***************************************************************************************** * FILE NAME: MMSA15_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 FORMAT15.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 10/14/2016 * *****************************************************************************************; ******************************** * 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 = 372 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2015\MMSA15.ASC' LRECL = 372 * * 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 LANDLINE 15 HHADULT 16-17 GENHLTH 18 /* Section 1: Health Status */ PHYSHLTH 19-20 /* Section 2: Healthy Days — Health Related Quality of Life */ MENTHLTH 21-22 POORHLTH 23-24 HLTHPLN1 25 /* Section 3: Health Care Access */ PERSDOC2 26 MEDCOST 27 CHECKUP1 28 BPHIGH4 29 /* Section 4: Hypertension Awareness */ BPMEDS 30 BLOODCHO 31 /* Section 5: Cholesterol Awareness */ CHOLCHK 32 TOLDHI2 33 CVDINFR4 34 /* Section 6: Chronic Health Conditions */ CVDCRHD4 35 CVDSTRK3 36 ASTHMA3 37 ASTHNOW 38 CHCSCNCR 39 CHCOCNCR 40 CHCCOPD1 41 HAVARTH3 42 ADDEPEV2 43 CHCKIDNY 44 DIABETE3 45 DIABAGE2 46-47 SEX 48 /* Section 7: Demographics */ MARITAL 49 EDUCA 50 RENTHOM1 51 NUMHHOL2 52 NUMPHON2 53 VETERAN3 54 EMPLOY1 55 CHILDREN 56-57 INCOME2 58-59 INTERNET 60 WEIGHT2 61-64 HEIGHT3 65-68 PREGNANT 69 QLACTLM2 70 USEEQUIP 71 BLIND 72 DECIDE 73 DIFFWALK 74 DIFFDRES 75 DIFFALON 76 SMOKE100 77 /* Section 8: Tobacco Use */ SMOKDAY2 78 STOPSMK2 79 LASTSMK2 80-81 USENOW3 82 ALCDAY5 83-85 /* Section 9: Alcohol Consumption */ AVEDRNK2 86-87 DRNK3GE5 88-89 MAXDRNKS 90-91 FRUITJU1 92-94 /* Section 10: Fruits & Vegetables */ FRUIT1 95-97 FVBEANS 98-100 FVGREEN 101-103 FVORANG 104-106 VEGETAB1 107-109 EXERANY2 110 /* Section 11: Exercise (Physical Activity) */ EXRACT11 111-112 EXEROFT1 113-115 EXERHMM1 116-118 EXRACT21 119-120 EXEROFT2 121-123 EXERHMM2 124-126 STRENGTH 127-129 LMTJOIN3 130 /* Section 12: Arthritis Burden */ ARTHDIS2 131 ARTHSOCL 132 JOINPAIN 133-134 SEATBELT 135 /* Section 13: Seatbelt Use */ FLUSHOT6 136 /* Section 14: Immunization */ FLSHTMY2 137-142 IMFVPLAC 143-144 PNEUVAC3 145 HIVTST6 146 /* Section 15: HIV/AIDS */ HIVTSTD3 147-152 WHRTST10 153-154 _STSTR 155-160 _RFHLTH 161 /* Section 1: Calculated Variables */ _HCVU651 162 /* Section 3: Calculated Variables */ _RFHYPE5 163 /* Section 4: Calculated Variables */ _CHOLCHK 164 /* Section 5: Calculated Variables */ _RFCHOL 165 _MICHD 166 /* Section 6: Calculated Variables */ _LTASTH1 167 _CASTHM1 168 _ASTHMS1 169 _DRDXAR1 170 _PRACE1 171-172 _MRACE1 173-174 _HISPANC 175 _RACE 176 _RACEG21 177 _RACEGR3 178 _AGEG5YR 179-180 _AGE65YR 181 _AGE80 182-183 _AGE_G 184 WTKG3 185-189 _BMI5 190-193 _BMI5CAT 194 _RFBMI5 195 _EDUCAG 196 _INCOMG 197 _SMOKER3 198 /* Section 8: Calculated Variables */ _RFSMOK3 199 DRNKANY5 200 /* Section 9: Calculated Variables */ _RFBING5 201 _DRNKWEK 202-206 _RFDRHV5 207 _MISFRTN 208 _MISVEGN 209 _FRTRESP 210 _VEGRESP 211 _FRUTSUM 212-217 _VEGESUM 218-223 _FRTLT1 224 _VEGLT1 225 _FRT16 226 _VEG23 227 _FRUITEX 228 _VEGETEX 229 _TOTINDA 230 /* Section 11: Calculated Variables */ _MINAC11 231-235 _MINAC21 236-240 _PACAT1 241 _PAINDX1 242 _PA150R2 243 _PA300R2 244 _PA30021 245 _PASTRNG 246 _PAREC1 247 _PASTAE1 248 _LMTACT1 249 /* Section 12: Calculated Variables */ _LMTWRK1 250 _LMTSCL1 251 _RFSEAT2 252 /* Section 13: Calculated Variables */ _RFSEAT3 253 _FLSHOT6 254 /* Section 14: Calculated Variables */ _PNEUMO2 255 _AIDTST3 256 /* Section 15: Calculated Variables */ _MMSAWT 257-266 /* MMSA Weighting and Stratification Variables */ MMSANAME $267-366 /* MMSA Weighting and Stratification Variables */ _MMSA 367-371 /* MMSA Weighting and Stratification Variables */ ENDOFREC 372 /* 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' LANDLINE = 'DO YOU ALSO HAVE A LANDLINE TELEPHONE?' 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' 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?' CHCCOPD1 = '(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?' DIABETE3 = '(EVER TOLD) YOU HAVE DIABETES' DIABAGE2 = 'AGE WHEN TOLD DIABETIC' SEX = 'RESPONDENTS SEX' MARITAL = 'MARITAL STATUS' EDUCA = 'EDUCATION LEVEL' RENTHOM1 = 'OWN OR RENT HOME' NUMHHOL2 = 'HOUSEHOLD TELEPHONES' NUMPHON2 = 'RESIDENTIAL PHONES' 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' QLACTLM2 = 'ACTIVITY LIMITATION DUE TO HEALTH PROBLEMS' USEEQUIP = 'HEALTH PROBLEMS REQUIRING SPECIAL EQUIPMENT' 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' AVEDRNK2 = 'AVG ALCOHOLIC DRINKS PER DAY IN PAST 30' DRNK3GE5 = 'BINGE DRINKING' MAXDRNKS = 'MOST DRINKS ON SINGLE OCCASION PAST 30 DAYS' FRUITJU1 = 'HOW MANY TIMES DID YOU DRINK 100 PERCENT 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' 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?' 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?' FLUSHOT6 = 'ADULT 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' HIVTST6 = 'EVER TESTED HIV' HIVTSTD3 = 'MONTH AND YEAR OF LAST HIV TEST' WHRTST10 = 'LOCATION OF LAST HIV TEST' _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' _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' _DRDXAR1 = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' _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.' _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' _DRNKWEK = 'COMPUTED NUMBER OF DRINKS OF ALCOHOL BEVERAGES PER WEEK' _RFDRHV5 = 'HEAVY ALCOHOL CONSUMPTION CALCULATED VARIABLE' _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' _FRTLT1 = 'CONSUME FRUIT 1 OR MORE TIMES PER DAY' _VEGLT1 = 'CONSUME VEGETABLES 1 OR MORE TIMES 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' _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)' _LMTACT1 = 'LIMITED USUAL ACTIVITIES' _LMTWRK1 = 'LIMITED WORK ACTIVITIES' _LMTSCL1 = 'LIMITED SOCIAL ACTIVITIES' _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;