/*Published: 08/01/2025*/ /**********************************************************************/ /*This is the input statement for ACS data for the Zip Code File */ /*Demographic Bucket */ /*Match this file to the zip codes in the claims files */ /*to obtain the 2008-2012, 2013-2017, and 2018-2022 ACS data for each */ /*Zip Code. */ /* */ /**********************************************************************/ *filename zipcode '/directory/zip.encr.acs.demographic.txt'; /*reading in an un-zipped file*/ filename zipcode pipe 'gunzip -c /directory/zip.encr.acs.demographic.txt.gz'; /*reading in a zipped file*/ options nocenter validvarname=upcase; data zipcode; infile zipcode lrecl=606 missover pad; input @001 timeperiod_acs $char2. @003 zip5 $char5. @008 zp_poptot 10. @018 zp_householdtot 10. @028 zp_popdensity 8.2 @036 pct_lt18years 6.2 @042 pct_gte65years 6.2 @048 pct_white 6.2 @054 pct_black 6.2 @060 pct_asian 6.2 @066 pct_AIAN 6.2 @072 pct_NHPI 6.2 @078 pct_nonhispanic 6.2 @084 pct_hispanic 6.2 @090 pct_nonminority 6.2 @096 pct_families_wfemhead_children 6.2 @102 pct_femhead_families_wchildren 6.2 @108 pct_fam_wsinglepar_children 6.2 @114 med_HH_inc 6. @120 percap_inc 6. @126 pct_pov 6.2 @132 pct_100150pctpov 6.2 @138 pct_150200pctpov 6.2 @144 pct_200400pctpov 6.2 @150 pct_gte400pctpov 6.2 @156 pct_pov_lt18years 6.2 @162 pct_pov_1864years 6.2 @168 pct_pov_gte65years 6.2 @174 pct_pov_6574years 6.2 @180 pct_pov_gte75years 6.2 @186 pct_pov_white 6.2 @192 pct_pov_lt18yrs_white 6.2 @198 pct_pov_1864yrs_white 6.2 @204 pct_pov_gte65yrs_white 6.2 @210 pct_pov_6574yrs_white 6.2 @216 pct_pov_gte75yrs_white 6.2 @222 pct_pov_black 6.2 @228 pct_pov_lt18yrs_black 6.2 @234 pct_pov_1864yrs_black 6.2 @240 pct_pov_gte65yrs_black 6.2 @246 pct_pov_6574yrs_black 6.2 @252 pct_pov_gte75yrs_black 6.2 @258 pct_pov_Asian 6.2 @264 pct_pov_lt18yrs_Asian 6.2 @270 pct_pov_1864yrs_Asian 6.2 @276 pct_pov_gte65yrs_Asian 6.2 @282 pct_pov_6574yrs_Asian 6.2 @288 pct_pov_gte75yrs_Asian 6.2 @294 pct_pov_AIAN 6.2 @300 pct_pov_lt18yrs_AIAN 6.2 @306 pct_pov_1864yrs_AIAN 6.2 @312 pct_pov_gte65yrs_AIAN 6.2 @318 pct_pov_6574yrs_AIAN 6.2 @324 pct_pov_gte75yrs_AIAN 6.2 @330 pct_pov_NHPI 6.2 @336 pct_pov_lt18yrs_NHPI 6.2 @342 pct_pov_1864yrs_NHPI 6.2 @348 pct_pov_gte65yrs_NHPI 6.2 @354 pct_pov_6574yrs_NHPI 6.2 @360 pct_pov_gte75yrs_NHPI 6.2 @366 pct_pov_Hisp 6.2 @372 pct_pov_lt18yrs_Hisp 6.2 @378 pct_pov_1864yrs_Hisp 6.2 @384 pct_pov_gte65yrs_Hisp 6.2 @390 pct_pov_6574yrs_Hisp 6.2 @396 pct_pov_gte75yrs_Hisp 6.2 @402 pct_edlt12yrs 6.2 @408 pct_edHSdiploma 6.2 @414 pct_edsomecollege 6.2 @420 pct_edcollege 6.2 @426 pct_edgradprof 6.2 @432 pct_edlt12yrs_w 6.2 @438 pct_edHSdiploma_w 6.2 @444 pct_edsomecollege_w 6.2 @450 pct_edbsorhigher_w 6.2 @456 pct_edlt12yrs_b 6.2 @462 pct_edHSdiploma_b 6.2 @468 pct_edsomecollege_b 6.2 @474 pct_edbsorhigher_b 6.2 @480 pct_edlt12yrs_a 6.2 @486 pct_edHSdiploma_a 6.2 @492 pct_edsomecollege_a 6.2 @498 pct_edbsorhigher_a 6.2 @504 pct_edlt12yrs_aian 6.2 @510 pct_edHSdiploma_aian 6.2 @516 pct_edsomecollege_aian 6.2 @522 pct_edbsorhigher_aian 6.2 @528 pct_edlt12yrs_nhpi 6.2 @534 pct_edHSdiploma_nhpi 6.2 @540 pct_edsomecollege_nhpi 6.2 @546 pct_edbsorhigher_nhpi 6.2 @552 pct_edlt12yrs_h 6.2 @558 pct_edHSdiploma_h 6.2 @564 pct_edsomecollege_h 6.2 @570 pct_edbsorhigher_h 6.2 @576 pct_unemp_civLF 6.2 @582 pct_unemp_totLF 6.2 @588 pct_LF 6.2 @594 pct_whitecollar 6.2 @600 GINI_incomeinequality 6.4; label timeperiod_acs = "Time Period, ACS" zip5 = "Zip Code" zp_poptot = "Total Population" zp_householdtot = "Total Households" zp_popdensity = "Population Density" pct_lt18years = "Pct <18: Total Population" pct_gte65years = "Pct 65+: Total Population" pct_white = "Pct White: Total Population" pct_black = "Pct Black: Total Population" pct_asian = "Pct Asian: Total Population" pct_AIAN = "Pct AI/AN: Total Population" pct_NHPI = "Pct NH/PI: Total Population" pct_nonhispanic = "Pct Not Hispanic: Total Population" pct_hispanic = "Pct Hispanic: Total Population" pct_nonminority = "Pct Non-Minority: Total Population" pct_families_wfemhead_children = "Pct Female Headed Family, <100% FPL, w/ children under 18: Total Families" pct_femhead_families_wchildren = "Pct Female Headed Family, <100% FPL, w/ children under 18: Female Headed Families" pct_fam_wsinglepar_children = "Pct Single Parent Famly, w/ children under 18: Total Families" med_HH_inc = "Median Household Income: Total Households" percap_inc = "Per Capita Income: Total Households" pct_pov = "Pct <100% FPL: Total Population" pct_100150pctpov = "Pct 100-150% FPL: Total Population" pct_150200pctpov = "Pct 150-200% FPL: Total Population" pct_200400pctpov = "Pct 200-400% FPL: Total Population" pct_gte400pctpov = "Pct >=400% FPL: Total Population" pct_pov_lt18years = "Pct <100% FPL: pop'n <18" pct_pov_1864years = "Pct <100% FPL: pop'n 18-64" pct_pov_gte65years = "Pct <100% FPL: pop'n 65+" pct_pov_6574years = "Pct <100% FPL: pop'n 65-74" pct_pov_gte75years = "Pct <100% FPL: pop'n 75+" pct_pov_white = "Pct <100% FPL:pop'n identified as White" pct_pov_lt18yrs_white = "Pct <100% FPL: pop'n <18 and identified as White" pct_pov_1864yrs_white = "Pct <100% FPL: pop'n 18-64 and identified as White" pct_pov_gte65yrs_white = "Pct <100% FPL: pop'n 65+ and identified as White" pct_pov_6574yrs_white = "Pct <100% FPL: pop'n 65-74 and identified as White" pct_pov_gte75yrs_white = "Pct <100% FPL: pop'n 75+ and identified as White" pct_pov_black = "Pct <100% FPL: pop'n identified as Black" pct_pov_lt18yrs_black = "Pct <100% FPL: pop'n <18 and identified as Black" pct_pov_1864yrs_black = "Pct <100% FPL: pop'n 18-64 and identified as Black" pct_pov_gte65yrs_black = "Pct <100% FPL: pop'n 65+ and identified as Black" pct_pov_6574yrs_black = "Pct <100% FPL: pop'n 65-74 and identified as Black" pct_pov_gte75yrs_black = "Pct <100% FPL: pop'n 75+ and identified as Black" pct_pov_Asian = "Pct <100% FPL: pop'n identified as Asian" pct_pov_lt18yrs_Asian = "Pct <100% FPL: pop'n <18 and identified as Asian" pct_pov_1864yrs_Asian = "Pct <100% FPL: pop'n 18-64 and identified as Asian" pct_pov_gte65yrs_Asian = "Pct <100% FPL: pop'n 65+ and identified as Asian" pct_pov_6574yrs_Asian = "Pct <100% FPL: pop'n 65-74 and identified as Asian" pct_pov_gte75yrs_Asian = "Pct <100% FPL: pop'n 75+ and identified as Asian" pct_pov_AIAN = "Pct <100% FPL: pop'n identified as AI/AN" pct_pov_lt18yrs_AIAN = "Pct <100% FPL: pop'n <18 and identified as AI/AN" pct_pov_1864yrs_AIAN = "Pct <100% FPL: pop'n 18-64 and identified as AI/AN" pct_pov_gte65yrs_AIAN = "Pct <100% FPL: pop'n 65+ and identified as AI/AN" pct_pov_6574yrs_AIAN = "Pct <100% FPL: pop'n 65-74 and identified as AI/AN" pct_pov_gte75yrs_AIAN = "Pct <100% FPL: pop'n 75+ and identified as AI/AN" pct_pov_NHPI = "Pct <100% FPL: pop'n identified as NH/PI" pct_pov_lt18yrs_NHPI = "Pct <100% FPL: pop'n <18 and identified as NH/PI" pct_pov_1864yrs_NHPI = "Pct <100% FPL: pop'n 18-64 and identified as NH/PI" pct_pov_gte65yrs_NHPI = "Pct <100% FPL: pop'n 65+ and identified as NH/PI" pct_pov_6574yrs_NHPI = "Pct <100% FPL: pop'n 65-74 and identified as NH/PI" pct_pov_gte75yrs_NHPI = "Pct <100% FPL: pop'n 75+ and identified as NH/PI" pct_pov_Hisp = "Pct <100% FPL: pop'n identified as Hispanic" pct_pov_lt18yrs_Hisp = "Pct <100% FPL: pop'n <18 and identified as Hispanic" pct_pov_1864yrs_Hisp = "Pct <100% FPL: pop'n 18-64 and identified as Hispanic" pct_pov_gte65yrs_Hisp = "Pct <100% FPL: pop'n 65+ and identified as Hispanic" pct_pov_6574yrs_Hisp = "Pct <100% FPL: pop'n 65-74 and identified as Hispanic" pct_pov_gte75yrs_Hisp = "Pct <100% FPL: pop'n 75+ and identified as Hispanic" pct_edlt12yrs = "Pct with <12 years of education: pop'n >= 25 years" pct_edHSdiploma = "Pct with high school diploma: pop'n >= 25 years" pct_edsomecollege = "Pct with some college: pop'n >= 25 years" pct_edcollege = "Pct with college degree: pop'n >= 25 years" pct_edgradprof = "Pct with graduate or professional degree: pop'n >= 25 years" pct_edlt12yrs_w = "Pct with <12 years of education: pop'n >= 25 and identified as white" pct_edHSdiploma_w = "Pct with high school diploma: pop'n >= 25 years and identified as white" pct_edsomecollege_w = "Pct with some college or associate's degree: pop'n >= 25 years and identified as white" pct_edbsorhigher_w = "Pct with a bachelor's degree or higher: pop'n >= 25 years and identified as white" pct_edlt12yrs_b = "Pct with <12 years of education: pop'n >= 25 and identified as black" pct_edHSdiploma_b = "Pct with high school diploma: pop'n >= 25 years and identified as black" pct_edsomecollege_b = "Pct with some college or associate's degree: pop'n >= 25 years and identified as black" pct_edbsorhigher_b = "Pct with a bachelor's degree or higher: pop'n >= 25 years and identified as black" pct_edlt12yrs_a = "Pct with <12 years of education: pop'n >= 25 and identified as Asian" pct_edHSdiploma_a = "Pct with high school diploma: pop'n >= 25 years and identified as Asian" pct_edsomecollege_a = "Pct with some college or associate's degree: pop'n >= 25 years and identified as Asian" pct_edbsorhigher_a = "Pct with a bachelor's degree or higher: pop'n >= 25 years and identified as Asian" pct_edlt12yrs_aian = "Pct with <12 years of education: pop'n >= 25 and identified as AI/AN" pct_edHSdiploma_aian = "Pct with high school diploma: pop'n >= 25 years and identified as AI/AN" pct_edsomecollege_aian = "Pct with some college or associate's degree: pop'n >= 25 years and identified as AI/AN" pct_edbsorhigher_aian = "Pct with a bachelor's degree or higher: pop'n >= 25 years and identified as AI/AN" pct_edlt12yrs_nhpi = "Pct with <12 years of education: pop'n >= 25 and identified as NH/PI" pct_edHSdiploma_nhpi = "Pct with high school diploma: pop'n >= 25 years and identified as NH/PI" pct_edsomecollege_nhpi = "Pct with some college or associate's degree: pop'n >= 25 years and identified as NH/PI" pct_edbsorhigher_nhpi = "Pct with a bachelor's degree or higher: pop'n >= 25 years and identified as NH/PI" pct_edlt12yrs_h = "Pct with <12 years of education: pop'n >= 25 and identified as Hispanic" pct_edHSdiploma_h = "Pct with high school diploma: pop'n >= 25 years and identified as Hispanic" pct_edsomecollege_h = "Pct with some college or associate's degree: pop'n >= 25 years and identified as Hispanic" pct_edbsorhigher_h = "Pct with a bachelor's degree or higher: pop'n >= 25 years and identified as Hispanic" pct_unemp_civLF = "Pct unemployed: pop'n 16 and over in the civilian labor force" pct_unemp_totLF = "Pct unemployed: pop'n 16 and over in the labor force" pct_LF = "Pct in the labor force: pop'n 16 and over in total population" pct_whitecollar = "Pct Employed in White Collar Occupations: pop'n 16 and over in the civilian LF" GINI_incomeinequality = "GINI Index: total households"; proc contents data=zipcode position; run;