/*Published: 08/01/2025*/ /**********************************************************************/ /*This is the input statement for ACS data for the Census Tract File */ /*Demographic Bucket */ /*Match this file to the census tract codes in the SEER File */ /*to obtain the 2008-2012 and 2013-2017 ACS data for each */ /*Census Tract. */ /* */ /**********************************************************************/ *filename tract '/directory/tract.encr.acs.demographic.txt'; /*reading in an un-zipped file*/ filename tract pipe 'gunzip -c /directory/tract.encr.acs.demographic.txt.gz'; /*reading in a zipped file*/ options nocenter validvarname=upcase; data tract; infile tract lrecl=614 missover pad; input @001 ct_version $char2. @003 timeperiod_acs $char2. @005 state $char2. @007 county $char3. @010 tract_num $char6. @016 ct_poptot 10. @026 ct_householdtot 10. @036 ct_popdensity 8.2 @044 pct_lt18years 6.2 @050 pct_gte65years 6.2 @056 pct_white 6.2 @062 pct_black 6.2 @068 pct_asian 6.2 @074 pct_AIAN 6.2 @080 pct_NHPI 6.2 @086 pct_nonhispanic 6.2 @092 pct_hispanic 6.2 @098 pct_nonminority 6.2 @104 pct_families_wfemhead_children 6.2 @110 pct_femhead_families_wchildren 6.2 @116 pct_fam_wsinglepar_children 6.2 @122 med_HH_inc 6. @128 percap_inc 6. @134 pct_pov 6.2 @140 pct_100150pctpov 6.2 @146 pct_150200pctpov 6.2 @152 pct_200400pctpov 6.2 @158 pct_gte400pctpov 6.2 @164 pct_pov_lt18years 6.2 @170 pct_pov_1864years 6.2 @176 pct_pov_gte65years 6.2 @182 pct_pov_6574years 6.2 @188 pct_pov_gte75years 6.2 @194 pct_pov_white 6.2 @200 pct_pov_lt18yrs_white 6.2 @206 pct_pov_1864yrs_white 6.2 @212 pct_pov_gte65yrs_white 6.2 @218 pct_pov_6574yrs_white 6.2 @224 pct_pov_gte75yrs_white 6.2 @230 pct_pov_black 6.2 @236 pct_pov_lt18yrs_black 6.2 @242 pct_pov_1864yrs_black 6.2 @248 pct_pov_gte65yrs_black 6.2 @254 pct_pov_6574yrs_black 6.2 @260 pct_pov_gte75yrs_black 6.2 @266 pct_pov_Asian 6.2 @272 pct_pov_lt18yrs_Asian 6.2 @278 pct_pov_1864yrs_Asian 6.2 @284 pct_pov_gte65yrs_Asian 6.2 @290 pct_pov_6574yrs_Asian 6.2 @296 pct_pov_gte75yrs_Asian 6.2 @302 pct_pov_AIAN 6.2 @308 pct_pov_lt18yrs_AIAN 6.2 @314 pct_pov_1864yrs_AIAN 6.2 @320 pct_pov_gte65yrs_AIAN 6.2 @326 pct_pov_6574yrs_AIAN 6.2 @332 pct_pov_gte75yrs_AIAN 6.2 @338 pct_pov_NHPI 6.2 @344 pct_pov_lt18yrs_NHPI 6.2 @350 pct_pov_1864yrs_NHPI 6.2 @356 pct_pov_gte65yrs_NHPI 6.2 @362 pct_pov_6574yrs_NHPI 6.2 @368 pct_pov_gte75yrs_NHPI 6.2 @374 pct_pov_Hisp 6.2 @380 pct_pov_lt18yrs_Hisp 6.2 @386 pct_pov_1864yrs_Hisp 6.2 @392 pct_pov_gte65yrs_Hisp 6.2 @398 pct_pov_6574yrs_Hisp 6.2 @404 pct_pov_gte75yrs_Hisp 6.2 @410 pct_edlt12yrs 6.2 @416 pct_edHSdiploma 6.2 @422 pct_edsomecollege 6.2 @428 pct_edcollege 6.2 @434 pct_edgradprof 6.2 @440 pct_edlt12yrs_w 6.2 @446 pct_edHSdiploma_w 6.2 @452 pct_edsomecollege_w 6.2 @458 pct_edbsorhigher_w 6.2 @464 pct_edlt12yrs_b 6.2 @470 pct_edHSdiploma_b 6.2 @476 pct_edsomecollege_b 6.2 @482 pct_edbsorhigher_b 6.2 @488 pct_edlt12yrs_a 6.2 @494 pct_edHSdiploma_a 6.2 @500 pct_edsomecollege_a 6.2 @506 pct_edbsorhigher_a 6.2 @512 pct_edlt12yrs_aian 6.2 @518 pct_edHSdiploma_aian 6.2 @524 pct_edsomecollege_aian 6.2 @530 pct_edbsorhigher_aian 6.2 @536 pct_edlt12yrs_nhpi 6.2 @542 pct_edHSdiploma_nhpi 6.2 @548 pct_edsomecollege_nhpi 6.2 @554 pct_edbsorhigher_nhpi 6.2 @560 pct_edlt12yrs_h 6.2 @566 pct_edHSdiploma_h 6.2 @572 pct_edsomecollege_h 6.2 @578 pct_edbsorhigher_h 6.2 @584 pct_unemp_civLF 6.2 @590 pct_unemp_totLF 6.2 @596 pct_LF 6.2 @602 pct_whitecollar 6.2 @608 GINI_incomeinequality 6.4; label ct_version = "Census tract assignment version (2010 vs 2020)" timeperiod_acs = "Time Period - ACS Data Files" state = "State" county = "County" tract_num = "Tract" ct_poptot = "Total Population" ct_householdtot = "Total Households" ct_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"; run; proc contents data=tract position; run;