/*Published: 08/01/2025*/ /**********************************************************************/ /*This is the input statement for the Census Tract File Insurance */ /*Bucket */ /*Match this file to the census tract codes in the SEER File */ /*to obtain the CDC Places 2022 data for each */ /*Census Tract. */ /* */ /**********************************************************************/ *filename tract '/directory/tract.encr.places.insurance.txt.gz'; /*reading in an un-zipped file*/ filename tract pipe 'gunzip -c /directory/tract.encr.places.insurance.txt.gz'; /*reading in a zipped file*/ options nocenter validvarname=upcase; data tract; infile tract lrecl=250 missover pad; input @001 ct_version $char2. @003 timeperiod_places $char2. @005 state $char2. @007 county $char3. @010 tract_num $char6. @016 CDC_Places_obesity 6.2 @022 CDC_Places_obesity_UL 6.2 @028 CDC_Places_obesity_LL 6.2 @034 CDC_Places_bingedrink 6.2 @040 CDC_Places_bingedrink_UL 6.2 @046 CDC_Places_bingedrink_LL 6.2 @052 CDC_Places_CervScreen 6.2 @058 CDC_Places_CervScreen_UL 6.2 @064 CDC_Places_CervScreen_LL 6.2 @070 CDC_Places_routineMD 6.2 @076 CDC_Places_routineMD_UL 6.2 @082 CDC_Places_routineMD_LL 6.2 @088 CDC_Places_CRCScreen 6.2 @094 CDC_Places_CRCScreen_UL 6.2 @100 CDC_Places_CRCScreen_LL 6.2 @106 CDC_Places_maleprevcare 6.2 @112 CDC_Places_maleprevcare_UL 6.2 @118 CDC_Places_maleprevcare_LL 6.2 @124 CDC_Places_femaleprevcare 6.2 @130 CDC_Places_femaleprevcare_UL 6.2 @136 CDC_Places_femaleprevcare_LL 6.2 @142 CDC_Places_currsmoke 6.2 @148 CDC_Places_currsmoke_UL 6.2 @154 CDC_Places_currsmoke_LL 6.2 @160 CDC_Places_dentvis 6.2 @166 CDC_Places_dentvis_UL 6.2 @172 CDC_Places_dentvis_LL 6.2 @178 CDC_Places_FPhealth 6.2 @184 CDC_Places_Fphealth_UL 6.2 @190 CDC_Places_Fphealth_LL 6.2 @196 CDC_Places_nophysact 6.2 @202 CDC_Places_nophysact_UL 6.2 @208 CDC_Places_nophysact_LL 6.2 @214 CDC_Places_mammog 6.2 @220 CDC_Places_mammog_UL 6.2 @226 CDC_Places_mammog_LL 6.2 @232 CDC_Places_FPmenthlth 6.2 @238 CDC_Places_Fpmenthlth_UL 6.2 @244 CDC_Places_Fpmenthlth_LL 6.2; label ct_version = "Census tract assignment version (2010 vs 2020)" timeperiod_places = "Time Period - CDC Places Data" state = "State" county = "County" tract_num = "Tract Number" 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=tract position; run;