**** * FILE NAME: MMSA14_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 FORMAT14.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 10/05/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 = 329 ; ** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2014\MMSA14.ASC' LRECL = 329 * * 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 GENHLTH 15 /* Section 1: Health Status */ PHYSHLTH 16-17 /* Section 2: Healthy Days — Health Related Quality of Life */ MENTHLTH 18-19 POORHLTH 20-21 HLTHPLN1 22 /* Section 3: Health Care Access */ PERSDOC2 23 MEDCOST 24 CHECKUP1 25 EXERANY2 26 /* Section 4: Exercise */ SLEPTIM1 27-28 /* Section 5: Inadequate Sleep */ CVDINFR4 29 /* Section 6: Chronic Health Conditions */ CVDCRHD4 30 CVDSTRK3 31 ASTHMA3 32 ASTHNOW 33 CHCSCNCR 34 CHCOCNCR 35 CHCCOPD1 36 HAVARTH3 37 ADDEPEV2 38 CHCKIDNY 39 DIABETE3 40 DIABAGE2 41-42 LASTDEN3 43 /* Section 7: Oral Health */ RMVTETH3 44 VETERAN3 45 MARITAL 46 CHILDREN 47-48 EDUCA 49 EMPLOY1 50 INCOME2 51-52 WEIGHT2 53-56 HEIGHT3 57-60 NUMHHOL2 61 NUMPHON2 62 INTERNET 63 RENTHOM1 64 SEX 65 PREGNANT 66 QLACTLM2 67 USEEQUIP 68 BLIND 69 DECIDE 70 DIFFWALK 71 DIFFDRES 72 DIFFALON 73 SMOKE100 74 /* Section 9: Tobacco Use */ SMOKDAY2 75 STOPSMK2 76 LASTSMK2 77-78 USENOW3 79 ALCDAY5 80-82 /* Section 10: Alcohol Consumption */ AVEDRNK2 83-84 DRNK3GE5 85-86 MAXDRNKS 87-88 FLUSHOT6 89 /* Section 11: Immunization */ FLSHTMY2 90-95 PNEUVAC3 96 SHINGLE2 97 FALL12MN 98-99 /* Section 12: Falls */ FALLINJ2 100-101 SEATBELT 102 /* Section 13: Seatbelt Use */ DRNKDRI2 103-104 /* Section 14: Drinking and Driving */ HADMAM 105 /* Section 15: Breast and Cervical Cancer Screening */ HOWLONG 106 PROFEXAM 107 LENGEXAM 108 HADPAP2 109 LASTPAP2 110 HADHYST2 111 PCPSAAD2 112 /* Section 16: Prostate Cancer Screening */ PCPSADI1 113 PCPSARE1 114 PSATEST1 115 PSATIME 116 PCPSARS1 117 BLDSTOOL 118 /* Section 17: Colorectal Cancer Screening */ LSTBLDS3 119 HADSIGM3 120 HADSGCO1 121 LASTSIG3 122 HIVTST6 123 /* Section 18: HIV/AIDS */ HIVTSTD3 124-129 WHRTST10 130-131 LANDLINE 132 HHADULT 133-134 _STSTR 135-140 _AGE80 141-142 _CPRACE 143-144 _RFHLTH 145 /* Section 1: Calculated Variables */ _HCVU651 146 /* Section 3: Calculated Variables */ _TOTINDA 147 /* Section 4: Calculated Variables */ _LTASTH1 148 /* Section 6: Calculated Variables */ _CASTHM1 149 _ASTHMS1 150 _DRDXAR1 151 _EXTETH2 152 /* Section 7: Oral Health */ _ALTETH2 153 _DENVST2 154 _PRACE1 155-156 _MRACE1 157-158 _HISPANC 159 _RACE 160 _RACEG21 161 _RACEGR3 162 _AGEG5YR 163-164 _AGE65YR 165 _AGE_G 166 WTKG3 167-171 _BMI5 172-175 _BMI5CAT 176 _RFBMI5 177 _EDUCAG 178 _INCOMG 179 _SMOKER3 180 /* Section 9: Calculated Variables */ _RFSMOK3 181 DRNKANY5 182 /* Section 10: Calculated Variables */ _RFBING5 183 _DRNKDY4 184-187 _DRNKMO4 188-191 _RFDRHV4 192 _RFDRMN4 193 _RFDRWM4 194 _FLSHOT6 195 /* Section 11: Calculated Variables */ _PNEUMO2 196 _RFSEAT2 197 /* Section 13: Calculated Variables */ _RFSEAT3 198 _RFMAM2Y 199 /* Section 15: Calculated Variables */ _MAM502Y 200 _MAM5021 201 _RFPAP32 202 _RFPAP33 203 _RFPSA21 204 /* Section 16: Calculated Variables */ _RFBLDS2 205 /* Section 17: Calculated Variables */ _RFBLDS3 206 _RFSIGM2 207 _COL10YR 208 _HFOB3YR 209 _FS5YR 210 _FOBTFS 211 _CRCREC 212 _AIDTST3 213 /* Section 18: Calculated Variables */ _MMSAWT 214-223 /* MMSA Weighting and Stratification Variables */ MMSANAME $224-323 /* MMSA Weighting and Stratification Variables */ _MMSA 324-328 /* MMSA Weighting and Stratification Variables */ ENDOFREC 329 /* 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' 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' EXERANY2 = 'EXERCISE IN PAST 30 DAYS' SLEPTIM1 = 'HOW MUCH TIME DO YOU SLEEP' 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' LASTDEN3 = 'LAST VISITED DENTIST OR DENTAL CLINIC' RMVTETH3 = 'NUMBER OF PERMANENT TEETH REMOVED' VETERAN3 = 'ARE YOU A VETERAN' MARITAL = 'MARITAL STATUS' CHILDREN = 'NUMBER OF CHILDREN IN HOUSEHOLD' EDUCA = 'EDUCATION LEVEL' EMPLOY1 = 'EMPLOYMENT STATUS' INCOME2 = 'INCOME LEVEL' WEIGHT2 = 'REPORTED WEIGHT IN POUNDS' HEIGHT3 = 'REPORTED HEIGHT IN FEET AND INCHES' NUMHHOL2 = 'HOUSEHOLD TELEPHONES' NUMPHON2 = 'RESIDENTIAL PHONES' INTERNET = 'INTERNET USE IN THE PAST 30 DAYS?' RENTHOM1 = 'OWN OR RENT HOME' SEX = 'RESPONDENTS SEX' 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' 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?' FALL12MN = 'HAD FALL PAST TWELVE MONTHS' FALLINJ2 = 'INJURED IN FALL' SEATBELT = 'HOW OFTEN USE SEATBELTS IN CAR?' DRNKDRI2 = 'DID YOU DRIVE AFTER HAVING TOO MUCH TO DRINK IN THE PAST 30 DAYS?' HADMAM = 'HAVE YOU EVER HAD A MAMMOGRAM' HOWLONG = 'HOW LONG SINCE LAST MAMMOGRAM' PROFEXAM = 'EVER HAD BREAST PHYSICAL EXAM BY DOCTOR' LENGEXAM = 'HOW LONG SINCE LAST BREAST PHYSICAL EXAM' HADPAP2 = 'EVER HAD A PAP TEST' LASTPAP2 = 'HOW LONG SINCE LAST PAP TEST' HADHYST2 = 'HAD HYSTERECTOMY' PCPSAAD2 = 'HAS A HEALTH PROFESSIONAL EVER TALKED WITH YOU ABOUT THE ADVANTAGES OF THE PSA TEST?' PCPSADI1 = 'HAS A HEALTH PROFESSIONAL EVER TALKED WITH YOU ABOUT THE DISADVANTAGES OF THE PSA TEST?' PCPSARE1 = 'HAS A DOCTOR EVER RECOMMENDED THAT YOU HAVE A PSA TEST?' PSATEST1 = 'EVER HAD PSA TEST' PSATIME = 'TIME SINCE LAST PSA TEST' PCPSARS1 = 'WHAT WAS THE MAIN REASON YOU HAD THIS PSA TEST?' BLDSTOOL = 'EVER HAD BLOOD STOOL TEST USING HOME KIT' LSTBLDS3 = 'TIME SINCE LAST BLOOD STOOL TEST' HADSIGM3 = 'EVER HAD SIGMOIDOSCOPY/COLONOSCOPY' HADSGCO1 = 'WAS LAST TEST A SIGMOIDOSCOPY OR COLONOSCOPY' LASTSIG3 = 'TIME SINCE LAST SIGMOIDOSCOPY/COLONOSCOPY' HIVTST6 = 'EVER TESTED HIV' HIVTSTD3 = 'MONTH AND YEAR OF LAST HIV TEST' WHRTST10 = 'LOCATION OF LAST HIV TEST' LANDLINE = 'DO YOU ALSO HAVE A LANDLINE TELEPHONE?' HHADULT = 'NUMBER OF ADULTS IN HOUSEHOLD' _STSTR = 'SAMPLE DESIGN STRATIFICATION VARIABLE' _AGE80 = 'IMPUTED AGE VALUE COLLAPSED ABOVE 80' _CPRACE = 'PREFERRED CHILD RACE CATEGORIES' _RFHLTH = 'ADULTS WITH GOOD OR BETTER HEALTH' _HCVU651 = 'RESPONDENTS AGED 18-64 WITH HEALTH CARE COVERAGE' _TOTINDA = 'LEISURE TIME PHYSICAL ACTIVITY CALCULATED VARIABLE' _LTASTH1 = 'LIFETIME ASTHMA CALCULATED VARIABLE' _CASTHM1 = 'CURRENT ASTHMA CALCULATED VARIABLE' _ASTHMS1 = 'COMPUTED ASTHMA STATUS' _DRDXAR1 = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' _EXTETH2 = 'RISK FACTOR FOR HAVING HAD PERMANENT TEETH EXTRACTED' _ALTETH2 = 'ADULTS AGED 65+ WHO HAVE HAD ALL THEIR NATURAL TEETH EXTRACTED' _DENVST2 = 'ADULTS WHO HAVE VISITED A DENTIST, DENTAL HYGENIST OR DENTAL CLINIC WITHIN THE PAST YEAR' _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' _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' _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' _FLSHOT6 = 'FLU SHOT CALCULATED VARIABLE' _PNEUMO2 = 'PNEUMONIA VACCINATION CALCULATED VARIABLE' _RFSEAT2 = 'ALWAYS OR NEARLY ALWAYS WEAR SEAT BELTS' _RFSEAT3 = 'ALWAYS WEAR SEAT BELTS' _RFMAM2Y = 'WOMEN RESPONDENTS AGED 40+ WHO HAVE HAD A MAMMOGRAM IN THE PAST TWO YEARS' _MAM502Y = 'WOMEN RESPONDENTS AGED 50+ WHO HAVE HAD A MAMMOGRAM IN THE PAST TWO YEARS' _MAM5021 = 'WOMEN RESPONDENTS AGED 50-74 WHO HAVE HAD A MAMMOGRAM IN THE PAST TWO YEARS' _RFPAP32 = 'WOMEN RESPONDENTS AGED 18+ WHO HAVE HAD A PAP TEST IN THE PAST THREE YEARS' _RFPAP33 = 'WOMEN RESPONDENTS AGED 21-65 WHO HAVE HAD A PAP TEST IN THE PAST THREE YEARS' _RFPSA21 = 'MALE RESPONDENTS AGED 40+ WHO HAVE HAD A PSA TEST IN THE PAST 2 YEARS' _RFBLDS2 = 'RESPONDENTS AGED 50+ WHO HAVE HAD A BLOOD STOOL TEST WITHIN THE PAST TWO YEARS' _RFBLDS3 = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A BLOOD STOOL TEST WITHIN THE PAST YEAR' _RFSIGM2 = 'RESPONDENTS AGED 50 OR OLDER WHO HAVE HAD A SIGMOIDOSCOPY OR COLONOSCOPY' _COL10YR = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A COLONOSCOPY IN THE PAST 10 YEARS' _HFOB3YR = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A BLOOD STOOL TEST WITHIN THE PAST 3 YEARS' _FS5YR = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A SIGMOIDOSCOPY WITHIN THE PAST 5 YEARS' _FOBTFS = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A BLOOD STOOL TEST WITHIN THE PAST 3 YEARS AND A SIGMOIDOSCOPY W' _CRCREC = 'RESPONDENTS AGED 50-75 WHO HAVE FULLY MET THE USPSTF RECOMMENDATION' _AIDTST3 = 'EVER BEEN TESTED FOR HIV CALCULATED VARIABLE' _MMSA = 'MMSA CODE (CBSA OR METRO)' _MMSAWT = 'MMSA-LEVEL WEIGHT' SEQNO = 'SEQUENCE NUMBER' ; RUN;