***************************************************************************************** * FILE NAME: MMSA16_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 FORMAT16.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 06/19/2017 * *****************************************************************************************; ******************************** * 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 = 337 ; ***************************************************************************** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2016\MMSA16.ASC' LRECL = 337 * * 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 CELLFON4 15 CELLFON5 16 PVTRESD3 17 CSTATE1 18 RSPSTAT1 19-20 LANDLINE 21 HHADULT 22-23 GENHLTH 24 /* Section 1: Health Status */ PHYSHLTH 25-26 /* Section 2: Healthy Days ?Health Related Quality of Life */ MENTHLTH 27-28 POORHLTH 29-30 HLTHPLN1 31 /* Section 3: Health Care Access */ PERSDOC2 32 MEDCOST 33 CHECKUP1 34 EXERANY2 35 /* Section 4: Exercise */ SLEPTIM1 36-37 /* Section 5: Inadequate Sleep */ CVDINFR4 38 /* Section 6: Chronic Health Conditions */ CVDCRHD4 39 CVDSTRK3 40 ASTHMA3 41 ASTHNOW 42 CHCSCNCR 43 CHCOCNCR 44 CHCCOPD1 45 HAVARTH3 46 ADDEPEV2 47 CHCKIDNY 48 DIABETE3 49 DIABAGE2 50-51 LASTDEN3 52 /* Section 7: Oral Health */ RMVTETH3 53 SEX 54 /* Section 8: Demographics */ MARITAL 55 EDUCA 56 RENTHOM1 57 NUMHHOL2 58 NUMPHON2 59 VETERAN3 60 EMPLOY1 61 CHILDREN 62-63 INCOME2 64-65 INTERNET 66 WEIGHT2 67-70 HEIGHT3 71-74 PREGNANT 75 DEAF 76 BLIND 77 DECIDE 78 DIFFWALK 79 DIFFDRES 80 DIFFALON 81 SMOKE100 82 /* Section 9: Tobacco Use */ SMOKDAY2 83 STOPSMK2 84 LASTSMK2 85-86 USENOW3 87 ECIGARET 88 /* Section 10: E-Cigarettes */ ECIGNOW 89 ALCDAY5 90-92 /* Section 11: Alcohol Consumption */ AVEDRNK2 93-94 DRNK3GE5 95-96 MAXDRNKS 97-98 FLUSHOT6 99 /* Section 12: Immunization */ FLSHTMY2 100-105 PNEUVAC3 106 TETANUS 107 FALL12MN 108-109 /* Section 13: Falls */ FALLINJ2 110-111 SEATBELT 112 /* Section 14: Seatbelt Use */ DRNKDRI2 113-114 /* Section 15: Drinking and Driving */ HADMAM 115 /* Section 16: Breast and Cervical Cancer Screening */ HOWLONG 116 HADPAP2 117 LASTPAP2 118 HPVTEST 119 HPLSTTST 120 HADHYST2 121 PCPSAAD2 122 /* Section 17: Prostate Cancer Screening */ PCPSADI1 123 PCPSARE1 124 PSATEST1 125 PSATIME 126 PCPSARS1 127 BLDSTOOL 128 /* Section 18: Colorectal Cancer Screening */ LSTBLDS3 129 HADSIGM3 130 HADSGCO1 131 LASTSIG3 132 HIVTST6 133 /* Section 19: HIV/AIDS */ HIVTSTD3 134-139 HIVRISK4 140 PFPPRVN1 141 /* Preconception Health/Family Planning */ TYPCNTR7 142-143 NOBCUSE6 144-145 PREG4549 146 _STSTR 147-152 _IMPSEX 153 _RFHLTH 154 /* Section 1: Calculated Variables */ _PHYS14D 155 /* Section 2: Calculated Variables */ _MENT14D 156 _HCVU651 157 /* Section 3: Calculated Variables */ _TOTINDA 158 /* Section 4: Calculated Variables */ _MICHD 159 /* Section 6: Calculated Variables */ _LTASTH1 160 _CASTHM1 161 _ASTHMS1 162 _DRDXAR1 163 _EXTETH2 164 /* Section 7: Calculated Variables */ _ALTETH2 165 _DENVST2 166 _PRACE1 167-168 _MRACE1 169-170 _HISPANC 171 _RACE 172 _RACEG21 173 _RACEGR3 174 _AGEG5YR 175-176 _AGE65YR 177 _AGE80 178-179 _AGE_G 180 WTKG3 181-185 _BMI5 186-189 _BMI5CAT 190 _RFBMI5 191 _EDUCAG 192 _INCOMG 193 _SMOKER3 194 /* Section 9: Calculated Variables */ _RFSMOK3 195 _ECIGSTS 196 /* Section 10: Calculated Variables */ _CURECIG 197 DRNKANY5 198 /* Section 11: Calculated Variables */ _RFBING5 199 _DRNKWEK 200-204 _RFDRHV5 205 _FLSHOT6 206 /* Section 12: Calculated Variables */ _PNEUMO2 207 _RFSEAT2 208 /* Section 14: Calculated Variables */ _RFSEAT3 209 _DRNKDRV 210 /* Section 15: Calculated Variables */ _RFMAM2Y 211 /* Section 16: Calculated Variables */ _MAM5021 212 _RFPAP33 213 _RFPSA21 214 /* Section 17: Calculated Variables */ _RFBLDS3 215 /* Section 18: Calculated Variables */ _COL10YR 216 _HFOB3YR 217 _FS5YR 218 _FOBTFS 219 _CRCREC 220 _AIDTST3 221 /* Section 19: Calculated Variables */ _MMSAWT 222-231 /* MMSA Weighting and Stratification Variables */ MMSANAME $232-331 /* MMSA Weighting and Stratification Variables */ _MMSA 332-336 /* MMSA Weighting and Stratification Variables */ ENDOFREC 337 /* 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' CELLFON4 = 'CELLULAR TELEPHONE' CELLFON5 = 'IS THIS A CELL TELEPHONE?' PVTRESD3 = 'DO YOU LIVE IN A PRIVATE RESIDENCE?' CSTATE1 = 'DO YOU CURRENTLY LIVE IN ____(STATE)____?' RSPSTAT1 = 'IN WHAT STATE DO YOU CURRENTLY LIVE?' 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' 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' 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' 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' ECIGARET = 'HAVE YOU EVER USED AN E-CIGARETTE OR OTHER ELECTRONIC 揤APING?PRODUCT?' ECIGNOW = 'DO YOU NOW USE E-CIGARETTES, EVERY DAY, SOME DAYS, OR NOT AT ALL?' 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' TETANUS = 'RECEIVED TETANUS SHOT SINCE 2005?' 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' HADPAP2 = 'EVER HAD A PAP TEST' LASTPAP2 = 'HOW LONG SINCE LAST PAP TEST' HPVTEST = 'HAVE YOU EVER HAD AN HPV TEST?' HPLSTTST = 'HOW LONG SINCE YOUR LAST HPV 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' HIVRISK4 = 'DO ANY HIGH RISK SITUATIONS APPLY' PFPPRVN1 = 'DID YOU DO ANYTHING TO KEEP FROM GETTING PREGNANT?' TYPCNTR7 = 'WHAT DID YOU DO TO KEEP YOU FROM GETTING PREGNANT?' NOBCUSE6 = 'WHAT WAS MAIN REASON FOR NOT DOING ANYTHING TO KEEP YOU FROM GETTING PREGNANT?' PREG4549 = 'PREGNANCY STATUS' _STSTR = 'SAMPLE DESIGN STRATIFICATION VARIABLE' _IMPSEX = 'IMPUTED GENDER' _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' _TOTINDA = 'LEISURE TIME PHYSICAL ACTIVITY 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' _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' _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' _ECIGSTS = 'COMPUTED E-CIGARETTE USER STATUS' _CURECIG = 'CURRENT E-CIGARETTE USER 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' _FLSHOT6 = 'FLU SHOT CALCULATED VARIABLE' _PNEUMO2 = 'PNEUMONIA VACCINATION CALCULATED VARIABLE' _RFSEAT2 = 'ALWAYS OR NEARLY ALWAYS WEAR SEAT BELTS' _RFSEAT3 = 'ALWAYS WEAR SEAT BELTS' _DRNKDRV = 'DRINKING AND DRIVING' _RFMAM2Y = 'WOMEN RESPONDENTS AGED 40+ 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' _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' _RFBLDS3 = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A BLOOD STOOL TEST WITHIN THE PAST YEAR' _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; 国产精品久久久久久一级毛片