***************************************************************************************** * FILE NAME: MMSA12_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 FORMAT12.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 07/09/2013 * *****************************************************************************************; ******************************** * 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 = 328 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2012\MMSA12.ASC' LRECL = 328 * * 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 FMONTH 1-2 DISPCODE 3-6 SEQNO 7-16 GENHLTH 17 /* Section 1: Health Status */ PHYSHLTH 18-19 /* Section 2: Healthy Days - Health-Related Quality of Life */ MENTHLTH 20-21 POORHLTH 22-23 HLTHPLN1 24 /* Section 3: Health Care Access */ PERSDOC2 25 MEDCOST 26 CHECKUP1 27 EXERANY2 28 /* Section 4: Exercise */ CVDINFR4 29 /* Section 5: Chronic Health Conditions */ CVDCRHD4 30 CVDSTRK3 31 ASTHMA3 32 ASTHNOW 33 CHCSCNCR 34 CHCOCNCR 35 CHCCOPD1 36 HAVARTH3 37 ADDEPEV2 38 CHCKIDNY 39 CHCVISN1 40 DIABETE3 41 LASTDEN3 42 /* Section 6: Oral Health */ RMVTETH3 43 AGE 44-45 /* Section 7: Demographics */ HISPANC2 46 MRACE $47-52 ORACE2 53 VETERAN3 54 MARITAL 55 CHILDREN 56-57 EDUCA 58 EMPLOY 59 INCOME2 60-61 WEIGHT2 62-65 HEIGHT3 66-69 NUMHHOL2 70 NUMPHON2 71 RENTHOM1 72 SEX 73 PREGNANT 74 QLACTLM2 75 /* Section 8: Disability */ USEEQUIP 76 SMOKE100 77 /* Section 9: Tobacco Use */ SMOKDAY2 78 STOPSMK2 79 LASTSMK2 80-81 USENOW3 82 ALCDAY5 83-85 /* Section 10: Alcohol Consumption */ AVEDRNK2 86-87 DRNK3GE5 88-89 MAXDRNKS 90-91 FLUSHOT5 92 /* Section 11: Immunization */ FLSHTMY2 93-98 IMFVPLAC 99-100 PNEUVAC3 101 FALL12MN 102-103 /* Section 12: Falls */ FALLINJ2 104-105 SEATBELT 106 /* Section 13: Seatbelt Use */ DRNKDRI2 107-108 /* Section 14: Drinking and Driving */ HADMAM 109 /* Section 15: Breast/Cervical Cancer Screening */ HOWLONG 110 PROFEXAM 111 LENGEXAM 112 HADPAP2 113 LASTPAP2 114 HADHYST2 115 PCPSAAD1 116 /* Section 16: Prostate Cancer Screening */ PCPSADI1 117 PCPSARE1 118 PSATEST1 119 PSATIME 120 PCPSARS1 121 BLDSTOOL 122 /* Section 17: Colorectal Cancer Screening */ LSTBLDS3 123 HADSIGM3 124 HADSGCO1 125 LASTSIG3 126 HIVTST6 127 /* Section 18: HIV/AIDS */ HIVTSTD3 128-133 HIVRISK3 134 QSTVER 135-136 /* Questionnaire Version */ _STSTR 137-141 _RFHLTH 142 /* Section 1: Calculated Variables */ _HCVU651 143 /* Section 3: Calculated Variables */ _TOTINDA 144 /* Section 4: Calculated Variables */ _LTASTH1 145 /* Section 5: Calculated Variables */ _CASTHM1 146 _ASTHMS1 147 _DRDXAR1 148 _EXTETH2 149 /* Section 6: Oral Health */ _ALTETH2 150 _DENVST2 151 _PRACE 152-153 _MRACE 154-155 RACE2 156 _RACEG2 157 _RACEGR2 158 _RACE_G 159 _AGEG5YR 160-161 _AGE65YR 162 _AGE_G 163 HTIN4 164-166 HTM4 167-169 WTKG3 170-174 _BMI5 175-178 _BMI5CAT 179 _RFBMI5 180 _CHLDCNT 181 _EDUCAG 182 _INCOMG 183 _SMOKER3 184 /* Section 9: Calculated Variables */ _RFSMOK3 185 DRNKANY5 186 /* Section 10: Calculated Variables */ DROCDY3_ 187-189 _RFBING5 190 _DRNKDY4 191-194 _DRNKMO4 195-198 _RFDRHV4 199 _RFDRMN4 200 _RFDRWM4 201 _FLSHOT5 202 /* Section 11: Calculated Variables */ _PNEUMO2 203 _RFSEAT2 204 /* Section 13: Calculated Variables */ _RFSEAT3 205 _RFMAM2Y 206 /* Section 15: Calculated Variables */ _MAM502Y 207 _RFPAP32 208 _RFPSA21 209 /* Section 16: Calculated Variables */ _RFBLDS2 210 /* Section 17: Calculated Variables */ _RFSIGM2 211 _AIDTST3 212 /* Section 18: Calculated Variables */ _MMSAWT 213-222 /* MMSA Weighting and Stratification Variables */ MMSANAME $223-322 /* MMSA Weighting and Stratification Variables */ _MMSA 323-327 /* MMSA Weighting and Stratification Variables */ ENDOFREC 328 /* 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 FMONTH = 'FILE MONTH' 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' 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?' CHCVISN1 = 'DO YOU HAVE ANY TROUBLE SEEING, EVEN WHEN WEARING GLASSES OR CONTACT LENSES?' DIABETE3 = '(EVER TOLD) YOU HAVE DIABETES' LASTDEN3 = 'LAST VISITED DENTIST OR DENTAL CLINIC' RMVTETH3 = 'NUMBER OF PERMANENT TEETH REMOVED' AGE = 'REPORTED AGE IN YEARS' HISPANC2 = 'HISPANIC/LATINO' MRACE = 'MULTIPLE RACE' ORACE2 = 'RESPONDENT RACE CHOICE' VETERAN3 = 'ARE YOU A VETERAN' MARITAL = 'MARITAL STATUS' CHILDREN = 'NUMBER OF CHILDREN IN HOUSEHOLD' EDUCA = 'EDUCATION LEVEL' EMPLOY = 'EMPLOYMENT STATUS' INCOME2 = 'INCOME LEVEL' WEIGHT2 = 'REPORTED WEIGHT IN POUNDS' HEIGHT3 = 'REPORTED HEIGHT IN FEET AND INCHES' NUMHHOL2 = 'HOUSEHOLD TELEPHONES' NUMPHON2 = 'RESIDENTIAL PHONES' RENTHOM1 = 'OWN OR RENT HOME' SEX = 'RESPONDENTS SEX' PREGNANT = 'PREGNANCY STATUS' QLACTLM2 = 'ACTIVITY LIMITATION DUE TO HEALTH PROBLEMS' USEEQUIP = 'HEALTH PROBLEMS REQUIRING SPECIAL EQUIPMENT' 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' FLUSHOT5 = 'SEASONAL 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' 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' PCPSAAD1 = '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' HIVRISK3 = 'DO ANY HIGH RISK SITUATIONS APPLY' QSTVER = 'QUESTIONNAIRE VERSION IDENTIFIER' _STSTR = 'SAMPLE DESIGN STRATIFICATION VARIABLE' _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' _PRACE = 'COMPUTED PREFERRED RACE' _MRACE = 'COMPUTED NON-HISPANIC RACE INCLUDING MULTIRACIAL' RACE2 = 'COMPUTED RACE-ETHNICITY GROUPING' _RACEG2 = 'COMPUTED NON-HISPANIC WHITES/ALL OTHERS RACE CATEGORIES RACE/ETHNIC GROUP CODES USED IN POST-STRATIF' _RACEGR2 = 'COMPUTED FIVE LEVEL RACE/ETHNICITY CATEGORY.' _RACE_G = 'COMPUTED RACE GROUPS USED FOR INTERNET PREVALENCE TABLES' _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' HTIN4 = 'COMPUTED HEIGHT IN INCHES' HTM4 = 'COMPUTED HEIGHT IN METERS' WTKG3 = 'COMPUTED WEIGHT IN KILOGRAMS' _BMI5 = 'COMPUTED BODY MASS INDEX' _BMI5CAT = 'COMPUTED BODY MASS INDEX CATEGORIES' _RFBMI5 = 'OVERWEIGHT OR OBESE CALCULATED VARIABLE' _CHLDCNT = 'COMPUTED NUMBER OF CHILDREN IN HOUSEHOLD' _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' DROCDY3_ = 'COMPUTED DRINK-OCCASIONS-PER-DAY' _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' _FLSHOT5 = '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' _RFPAP32 = 'WOMEN RESPONDENTS AGED 18+ 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' _RFSIGM2 = 'RESPONDENTS AGED 50 OR OLDER WHO HAVE HAD A SIGMOIDOSCOPY OR COLONOSCOPY' _AIDTST3 = 'EVER BEEN TESTED FOR HIV CALCULATED VARIABLE' _MMSA = 'MMSA CODE (CBSA OR METRO)' _MMSAWT = 'MMSA-LEVEL WEIGHT' STCTYWT = 'FINAL WEIGHT: LAND-LINE AND CELL-PHONE DATA' SEQNO = 'SEQUENCE NUMBER' ; RUN;