/*Published: 04/19/2023*/ /********************************************************************/ /*This is the input statement for the Zip Code Census File. */ /*Match this file to the 5 digit zip codes in the MBSF and other */ /*Files to obtain the Census 1990, 2000 and 2008-2012 ACS */ /*data for each zip code. */ /* */ /********************************************************************/ *filename zipcen '/directory/sumdenom.censusfile.noncancer.txt'; /*reading in an un-zipped file*/ filename zipcen pipe 'gunzip -c /directory/zipcode.census.encrypted.txt.gz'; /*reading in a zipped file*/ options nocenter validvarname=upcase; data zipcen; infile zipcen lrecl=456 missover pad; input @001 filetype $char2. @003 f_state $char2. @005 zip5 $char5. @010 zppci 10. @020 zpmed 10. @030 zpden 10. @040 zpwht 6.2 @046 zpblk 6.2 @052 zphsp 6.2 @058 zpen5 6.2 @064 zpen6 6.2 @070 zpnon 6.2 @076 zphso 6.2 @082 zpscl 6.2 @088 zpcol 6.2 @094 whtnon 6.2 @100 whthso 6.2 @106 whtscl 6.2 @112 whtcol 6.2 @118 blknon 6.2 @124 blkhso 6.2 @130 blkscl 6.2 @136 blkcol 6.2 @142 aminon 6.2 @148 amihso 6.2 @154 amiscl 6.2 @160 amicol 6.2 @166 asinon 6.2 @172 asihso 6.2 @178 asiscl 6.2 @184 asicol 6.2 @190 othnon 6.2 @196 othhso 6.2 @202 othscl 6.2 @208 othcol 6.2 @214 hspnon 6.2 @220 hsphso 6.2 @226 hspscl 6.2 @232 hspcol 6.2 @238 natnon 6.2 @244 nathso 6.2 @250 natscl 6.2 @256 natcol 6.2 @262 pov_tot 6.2 @268 pov_totlt65 6.2 @274 pov_tot6574 6.2 @280 pov_tot75 6.2 @286 pov_wht 6.2 @292 pov_blk 6.2 @298 pov_ami 6.2 @304 pov_asi 6.2 @310 pov_nat 6.2 @316 pov_oth 6.2 @322 pov_hsp 6.2 @328 pov_whtlt65 6.2 @334 pov_wht6574 6.2 @340 pov_wht75 6.2 @346 pov_blklt65 6.2 @352 pov_blk6574 6.2 @358 pov_blk75 6.2 @364 pov_amilt65 6.2 @370 pov_ami6574 6.2 @376 pov_ami75 6.2 @382 pov_asilt65 6.2 @388 pov_asi6574 6.2 @394 pov_asi75 6.2 @400 pov_natlt65 6.2 @406 pov_nat6574 6.2 @412 pov_nat75 6.2 @418 pov_othlt65 6.2 @424 pov_oth6574 6.2 @430 pov_oth75 6.2 @436 pov_hsplt65 6.2 @442 pov_hsp6574 6.2 @448 pov_hsp75 6.2 @454 s_state $char2. ; ; label filetype = 'File Type Source' f_state = 'State Code (FIPS coding)' zip5 = '5 Digit Zip Code' zppci = 'Zip Code PCI' zpmed = 'Zip Code Median Income' zpden = 'Zip Code Density' zpwht = 'Zip Code Pct Whites' zpblk = 'Zip Code Pct Blacks' zphsp = 'Zip Code Pct Hispanics' zpen5 = 'Zip Code Pct of HHs who do not speak English well or at all 5+' zpen6 = 'Zip Code Pct of HHs who do not speak English well or at all 65+' zpnon = 'Zip Code Pct Non High School Grads' zphso = 'Zip Code Pct High School Only' zpscl = 'Zip Code Pct Some College Education' zpcol = 'Zip Code Pct College Education at least 4 years' whtnon = 'Whites - Zip Code Pct Non High School Grads by Race' whthso = 'Whites - Zip Code Pct High School Only by Race' whtscl = 'Whites - Zip Code Pct Some College by Race' whtcol = 'Whites - Zip Code Pct College Education at least 4 years by Race' blknon = 'Blacks - Zip Code Pct Non High School Grads by Race' blkhso = 'Blacks - Zip Code Pct High School Only by Race' blkscl = 'Blacks - Zip Code Pct Some College by Race' blkcol = 'Blacks - Zip Code Pct College Education at least 4 years by Race' aminon = 'American Indian - Zip Code Pct Non High School Grads by Race' amihso = 'American Indian - Zip Code Pct High School Only by Race' amiscl = 'American Indian - Zip Code Pct Some College by Race' amicol = 'American Indian - Zip Code Pct College Education at least 4 years by Race' asinon = 'Asian - Zip Code Pct Non High School Grads by Race' asihso = 'Asian - Zip Code Pct High School Only by Race' asiscl = 'Asian - Zip Code Pct Some College by Race' asicol = 'Asian - Zip Code Pct College Education at least 4 years by Race' othnon = 'Other - Zip Code Pct Non High School Grads by Race' othhso = 'Other - Zip Code Pct High School Only by Race' othscl = 'Other - Zip Code Pct Some College by Race' othcol = 'Other - Zip Code Pct College Education at least 4 years by Race' hspnon = 'Hispanic - Zip Code Pct Non High School Grads by Race' hsphso = 'Hispanic - Zip Code Pct High School Only by Race' hspscl = 'Hispanic - Zip Code Pct Some College by Race' hspcol = 'Hispanic - Zip Code Pct College Education at least 4 years by Race' natnon = 'Native Hawaiian - Zip Code Pct Non High School Grads by Race' nathso = 'Native Hawaiian - Zip Code Pct High School Only by Race' natscl = 'Native Hawaiian - Zip Code Pct Some College by Race' natcol = 'Native Hawaiian - Zip Code Pct College Education at least 4 years by Race' pov_tot = 'Percent of residents living below poverty' pov_totlt65 = 'Percent of residents living below poverty less than 65' pov_tot6574 = 'Percent of residents living below poverty age 65-74' pov_tot75 = 'Percent of residents living below poverty age 75+' pov_wht = 'White - Percent of residents living below poverty' pov_blk = 'Black - Percent of residents living below poverty' pov_ami = 'American Indian - Percent of residents living below poverty' pov_asi = 'Asian - Percent of residents living below poverty' pov_nat = 'Native Hawaiian - Percent of residents living below poverty' pov_oth = 'Other - Percent of residents living below poverty' pov_hsp = 'Hispanic - Percent of residents living below poverty' pov_whtlt65 = 'White - Percent of residents living below poverty less than 65' pov_wht6574 = 'White - Percent of residents living below poverty age 65-74' pov_wht75 = 'White - Percent of residents living below poverty age 75+' pov_blklt65 = 'Black - Percent of residents living below poverty less than 65' pov_blk6574 = 'Black - Percent of residents living below poverty age 65-74' pov_blk75 = 'Black - Percent of residents living below poverty age 75+' pov_amilt65 = 'American Indian - Percent of residents living below poverty less than 65' pov_ami6574 = 'American Indian - Percent of residents living below poverty age 65-74' pov_ami75 = 'American Indian - Percent of residents living below poverty age 75+' pov_asilt65 = 'Asian - Percent of residents living below poverty less than 65' pov_asi6574 = 'Asian - Percent of residents living below poverty age 65-74' pov_asi75 = 'Asian - Percent of residents living below poverty age 75+' pov_natlt65 = 'Native Hawaiian - Percent of residents living below poverty less than 65' pov_nat6574 = 'Native Hawaiian - Percent of residents living below poverty age 65-74' pov_nat75 = 'Native Hawaiian - Percent of residents living below poverty age 75+' pov_othlt65 = 'Other - Percent of residents living below poverty less than 65' pov_oth6574 = 'Other - Percent of residents living below poverty age 65-74' pov_oth75 = 'Other - Percent of residents living below poverty age 75+' pov_hsplt65 = 'Hispanic - Percent of residents living below poverty less than 65' pov_hsp6574 = 'Hispanic - Percent of residents living below poverty age 65-74' pov_hsp75 = 'Hispanic - Percent of residents living below poverty age 75+' s_state = 'State Code (Census coding)' ; run; proc contents data=zipcen position; run;