/*Published: 08/01/2025*/ /**********************************************************************/ /*This is the input statement for the Zip Code File Insurance */ /*Bucket */ /*Match this file to the zip codes in the claims files */ /*to obtain the CDC Places 2022 data for each */ /*Zip Code. */ /* */ /**********************************************************************/ *filename zipcode '/directory/zip.encr.places.insurance.txt'; /*reading in an un-zipped file*/ filename zipcode pipe 'gunzip -c /directory/zip.encr.places.insurance.txt.gz'; /*reading in a zipped file*/ options nocenter validvarname=upcase; data zipcode; infile zipcode lrecl=242 missover pad; input @001 timeperiod_places $char2. @003 zip5 $char5. @008 CDC_Places_obesity 6.2 @014 CDC_Places_obesity_UL 6.2 @020 CDC_Places_obesity_LL 6.2 @026 CDC_Places_bingedrink 6.2 @032 CDC_Places_bingedrink_UL 6.2 @038 CDC_Places_bingedrink_LL 6.2 @044 CDC_Places_CervScreen 6.2 @050 CDC_Places_CervScreen_UL 6.2 @056 CDC_Places_CervScreen_LL 6.2 @062 CDC_Places_routineMD 6.2 @068 CDC_Places_routineMD_UL 6.2 @074 CDC_Places_routineMD_LL 6.2 @080 CDC_Places_CRCScreen 6.2 @086 CDC_Places_CRCScreen_UL 6.2 @092 CDC_Places_CRCScreen_LL 6.2 @098 CDC_Places_maleprevcare 6.2 @104 CDC_Places_maleprevcare_UL 6.2 @110 CDC_Places_maleprevcare_LL 6.2 @116 CDC_Places_femaleprevcare 6.2 @122 CDC_Places_femaleprevcare_UL 6.2 @128 CDC_Places_femaleprevcare_LL 6.2 @134 CDC_Places_currsmoke 6.2 @140 CDC_Places_currsmoke_UL 6.2 @146 CDC_Places_currsmoke_LL 6.2 @152 CDC_Places_dentvis 6.2 @158 CDC_Places_dentvis_UL 6.2 @164 CDC_Places_dentvis_LL 6.2 @170 CDC_Places_FPhealth 6.2 @176 CDC_Places_Fphealth_UL 6.2 @182 CDC_Places_Fphealth_LL 6.2 @188 CDC_Places_nophysact 6.2 @194 CDC_Places_nophysact_UL 6.2 @200 CDC_Places_nophysact_LL 6.2 @206 CDC_Places_mammog 6.2 @212 CDC_Places_mammog_UL 6.2 @218 CDC_Places_mammog_LL 6.2 @224 CDC_Places_FPmenthlth 6.2 @230 CDC_Places_Fpmenthlth_UL 6.2 @236 CDC_Places_Fpmenthlth_LL 6.2; label timeperiod_places = "Time Period, CDC Places" zip5 = "Zip Code" CDC_Places_obesity = "Model-based estimate for crude prevalence of obesity among adults, 2022" CDC_Places_obesity_UL = "Estimated Upper confidence interval for crude prevalence of obesity among adults" CDC_Places_obesity_LL = "Estimated Lower confidence interval for crude prevalence of obesity among adults" CDC_Places_bingedrink = "Model-based estimate for crude prevalence of binge drinking among adults aged >=18 years, 2020" CDC_Places_bingedrink_UL = "Estimated Upper confidence interval for crude prevalence of binge drinking among adults aged >=18 years" CDC_Places_bingedrink_LL = "Estimated Lower confidence interval for crude prevalence of binge drinking among adults aged >=18 years" CDC_Places_CervScreen = "Model-based estimate for crude prevalence of cervical cancer screening among adult women aged 21–65 years, 2020" CDC_Places_CervScreen_UL = "Estimated Upper confidence interval for crude prevalence of cervical cancer screening among adult women aged 21–65 years" CDC_Places_CervScreen_LL = "Estimated Lower confidence interval for crude prevalence of cervical cancer screening among adult women aged 21–65 years" CDC_Places_routineMD = "Model-based estimate for crude prevalence of visits to doctor for routine checkup within the past year among adults aged >=18 years, 2020" CDC_Places_routineMD_UL = "Estimated Upper confidence interval for crude prevalence of visits to doctor for routine checkup within the past year among adults aged >=18 years" CDC_Places_routineMD_LL = "Estimated Lower confidence interval for crude prevalence of visits to doctor for routine checkup within the past year among adults aged >=18 years" CDC_Places_CRCScreen = "Model-based estimate for crude prevalence of fecal occult blood test, sigmoidoscopy, or colonoscopy among adults aged 50–75 years, 2020" CDC_Places_CRCScreen_UL = "Estimated Upper confidence interval for crude prevalence of fecal occult blood test, sigmoidoscopy, or colonoscopy among adults aged 50–75 years" CDC_Places_CRCScreen_LL = "Estimated Lower confidence interval for crude prevalence of fecal occult blood test, sigmoidoscopy, or colonoscopy among adults aged 50–75 years" CDC_Places_maleprevcare = "Model-based estimate for crude prevalence of men aged >=65 years who are up to date on a core set of clinical preventive services: Flu shot past year, PPV shot ever, Colorectal cancer screening, 2020" CDC_Places_maleprevcare_UL = "Estimated Upper confidence interval for crude prevalence of men aged >=65 years who are up to date on a core set of clinical preventive services: Flu shot past year, PPV shot ever, Colorectal cancer screening" CDC_Places_maleprevcare_LL = "Estimated Lower confidence interval for crude prevalence of older adult men aged >=65 years who are up to date on a core set of clinical preventive services: Flu shot past year, PPV shot ever, Colorectal cancer screening" CDC_Places_femaleprevcare = "Model-based estimate for crude prevalence of older adult women aged >=65 years who are up to date on a core set of clinical preventive services: Flu shot past year, PPV shot ever, Colorectal cancer screening, and Mammogram past 2 years, 2020" CDC_Places_femaleprevcare_UL = "Estimated Upper confidence interval for crude prevalence of older adult women aged >=65 years who are up to date on a core set of clinical preventive services: Flu shot past year, PPV shot ever, Colorectal cancer screening, and Mammogram past 2 years" CDC_Places_femaleprevcare_LL = "Estimated Lower confidence interval for crude prevalence of older adult women aged >=65 years who are up to date on a core set of clinical preventive services: Flu shot past year, PPV shot ever, Colorectal cancer screening, and Mammogram past 2 years" CDC_Places_currsmoke = "Model-based estimate for crude prevalence of current smoking among adults aged >=18 years, 2020" CDC_Places_currsmoke_UL = "Estimated Upper confidence interval for crude prevalence of current smoking among adults aged >=18 years" CDC_Places_currsmoke_LL = "Estimated Lower confidence interval for crude prevalence of current smoking among adults aged >=18 years" CDC_Places_dentvis = "Model-based estimate for crude prevalence of visits to dentist or dental clinic among adults aged >=18 years, 2020" CDC_Places_dentvis_UL = "Estimated Upper confidence interval for crude prevalence of visits to dentist or dental clinic among adults aged >=18 years" CDC_Places_dentvis_LL = "Estimated Lower confidence interval for crude prevalence of visits to dentist or dental clinic among adults aged >=18 years" CDC_Places_FPhealth = "Model-based estimate for crude prevalence of fair or poor health among adults aged >=18 years, 2020" CDC_Places_Fphealth_UL = "Estimated Upper confidence interval for crude prevalence of fair or poor health among adults aged >=18 years" CDC_Places_Fphealth_LL = "Estimated Lower confidence interval for crude prevalence of fair or poor health among adults aged >=18 years" CDC_Places_nophysact = "Model-based estimate for crude prevalence of no leisure-time physical activity among adults aged >=18 years, 2020" CDC_Places_nophysact_UL = "Estimated Upper confidence interval for crude prevalence of no leisure-time physical activity among adults aged >=18 years" CDC_Places_nophysact_LL = "Estimated Lower confidence interval for crude prevalence of no leisure-time physical activity among adults aged >=18 years" CDC_Places_mammog = "Model-based estimate for crude prevalence of mammography use among women aged 50–74 years, 2020" CDC_Places_mammog_UL = "Estimated Upper confidence interval for crude prevalence of mammography use among women aged 50–74 years" CDC_Places_mammog_LL = "Estimated Lower confidence interval for crude prevalence of mammography use among women aged 50–74 years" CDC_Places_FPmenthlth = "Model-based estimate for crude prevalence of mental health not good for >=14 days among adults aged >=18 years, 2020" CDC_Places_Fpmenthlth_UL = "Estimated Upper confidence interval for crude prevalence of mental health not good for >=14 days among adults aged >=18 years" CDC_Places_Fpmenthlth_LL = "Estimated Lower confidence interval for crude prevalence of mental health not good for >=14 days among adults aged >=18 years" ; run; proc contents data=zipcode position; run;