/*Published: 12/31/2012*/
/********************************************************************/
/*This is the input statement for the SUMDENOM Cenus File           */
/*Match this file to the zip codes in the SUMDENOM File to obtain   */
/*the Census 1990 and 2000 data for each zip code.                  */
/*                                                                  */
/********************************************************************/

*filename census '/directory/sumdenom.censusfile.noncancer.txt';                   /*reading in an un-zipped file*/
filename census pipe 'gunzip -c /directory/sumdenom.censusfile.noncancer.txt.gz';  /*reading in a zipped file*/

options nocenter validvarname=upcase;

data sumdencen;
  infile census lrecl=872 missover pad;
  input @1 state    $char2.
      @003 zip5     $char5.
      @008 zppci90  10.
      @018 zpmed90  10.
      @028 zpden90  10.
      @038 zpwht90  6.2
      @044 zpblk90  6.2
      @050 zphsp90  6.2
      @056 zpen590  6.2
      @062 zpen690  6.2
      @068 zpnon90  6.2
      @074 zphso90  6.2
      @080 zpscl90  6.2
      @086 zpcol90  6.2
      @092 whtnon90 6.2
      @098 whthso90 6.2
      @104 whtscl90 6.2
      @110 whtcol90 6.2
      @116 blknon90 6.2
      @122 blkhso90 6.2
      @128 blkscl90 6.2
      @134 blkcol90 6.2
      @140 aminon90 6.2
      @146 amihso90 6.2
      @152 amiscl90 6.2
      @158 amicol90 6.2
      @164 asinon90 6.2
      @170 asihso90 6.2
      @176 asiscl90 6.2
      @182 asicol90 6.2
      @188 othnon90 6.2
      @194 othhso90 6.2
      @200 othscl90 6.2
      @206 othcol90 6.2
      @212 hspnon90 6.2
      @218 hsphso90 6.2
      @224 hspscl90 6.2
      @230 hspcol90 6.2
      @236 zppci00  10.
      @246 zpmed00  10.
      @256 zpden00  10.
      @266 zpwht00  6.2
      @272 zpblk00  6.2
      @278 zphsp00  6.2
      @284 zpen500  6.2
      @290 zpen600  6.2
      @296 zpnon00  6.2
      @302 zphso00  6.2
      @308 zpscl00  6.2
      @314 zpcol00  6.2
      @320 whtnon00 6.2
      @326 whthso00 6.2
      @332 whtscl00 6.2
      @338 whtcol00 6.2
      @344 blknon00 6.2
      @350 blkhso00 6.2
      @356 blkscl00 6.2
      @362 blkcol00 6.2
      @368 aminon00 6.2
      @374 amihso00 6.2
      @380 amiscl00 6.2
      @386 amicol00 6.2
      @392 asinon00 6.2
      @398 asihso00 6.2
      @404 asiscl00 6.2
      @410 asicol00 6.2
      @416 othnon00 6.2
      @422 othhso00 6.2
      @428 othscl00 6.2
      @434 othcol00 6.2
      @440 hspnon00 6.2
      @446 hsphso00 6.2
      @452 hspscl00 6.2
      @458 hspcol00 6.2
      @464 natnon00 6.2
      @470 nathso00 6.2
      @476 natscl00 6.2
      @482 natcol00 6.2
      @488 pov_tot90 6.2
      @494 pov_totlt65_90 6.2
      @500 pov_tot6574_90 6.2
      @506 pov_tot75_90 6.2
      @512 pov_wht90 6.2
      @518 pov_blk90 6.2
      @524 pov_ami90 6.2
      @530 pov_asi90 6.2

      @542 pov_oth90 6.2
      @548 pov_hsp90 6.2
      @554 pov_whtlt65_90 6.2
      @560 pov_wht6574_90 6.2
      @566 pov_wht75_90 6.2
      @572 pov_blklt65_90 6.2
      @578 pov_blk6574_90 6.2
      @584 pov_blk75_90 6.2
      @590 pov_amilt65_90 6.2
      @596 pov_ami6574_90 6.2
      @602 pov_ami75_90 6.2
      @608 pov_asilt65_90 6.2
      @614 pov_asi6574_90 6.2
      @620 pov_asi75_90 6.2

      @632 pov_nat6574_90 6.2
      @638 pov_nat75_90 6.2  */
      @644 pov_othlt65_90 6.2
      @650 pov_oth6574_90 6.2
      @656 pov_oth75_90 6.2
      @662 pov_hsplt65_90 6.2
      @668 pov_hsp6574_90 6.2
      @674 pov_hsp75_90 6.2
      @680 pov_tot00 6.2
      @686 pov_totlt65_00 6.2
      @692 pov_tot6574_00 6.2
      @698 pov_tot75_00 6.2
      @704 pov_wht00 6.2
      @710 pov_blk00 6.2
      @716 pov_ami00 6.2
      @722 pov_asi00 6.2
      @728 pov_nat00 6.2
      @734 pov_oth00 6.2
      @740 pov_hsp00 6.2
      @746 pov_whtlt65_00 6.2
      @752 pov_wht6574_00 6.2
      @758 pov_wht75_00 6.2
      @764 pov_blklt65_00 6.2
      @770 pov_blk6574_00 6.2
      @776 pov_blk75_00 6.2
      @782 pov_amilt65_00 6.2
      @788 pov_ami6574_00 6.2
      @794 pov_ami75_00 6.2
      @800 pov_asilt65_00 6.2
      @806 pov_asi6574_00 6.2
      @812 pov_asi75_00 6.2
      @818 pov_natlt65_00 6.2
      @824 pov_nat6574_00 6.2
      @830 pov_nat75_00 6.2
      @836 pov_othlt65_00 6.2
      @842 pov_oth6574_00 6.2
      @848 pov_oth75_00 6.2
      @854 pov_hsplt65_00 6.2
      @860 pov_hsp6574_00 6.2
      @866 pov_hsp75_00 6.2
      ;

label
  state    = 'State Code'
  zip5     = '5 Digit Zip Code'
  zppci90  = 'Zip Code PCI (Census 1990)'
  zpmed90  = 'Zip Code Median Income (Census 1990)'
  zpden90  = 'Zip Code Density (Census 1990)'
  zpblk90  = 'Zip Code Pct Blacks (Census 1990)'
  zpwht90  = 'Zip Code Pct Whites (Census 1990)'
  zphsp90  = 'Zip Code Pct Hispanics (Census 1990)'
  zpen590  = 'Zip Code Pct of HHs who do not speak English well or at all 5+ (Census 1990)'
  zpen690  = 'Zip Code Pct of HHs who do not speak English well or at all 65+ (Census 1990)'
  zpnon90  = 'Zip Code Pct Non High School Grads (Census 1990)'
  zphso90  = 'Zip Code Pct High School Only (Census 1990)'
  zpscl90  = 'Zip Code Pct Some College Education (Census 1990)'
  zpcol90  = 'Zip Code Pct College Education at least 4 years (Census 1990)'
  whtnon90 = 'Whites - Zip Code Pct Non High School Grads by Race (Census 1990)'
  whthso90 = 'Whites - Zip Code Pct High School Only by Race (Census 1990)'
  whtscl90 = 'Whites - Zip Code Pct Some College by Race (Census 1990)'
  whtcol90 = 'Whites - Zip Code Pct College Education at least 4 years by Race (Census 1990)'
  blknon90 = 'Blacks - Zip Code Pct Non High School Grads by Race (Census 1990)'
  blkhso90 = 'Blacks - Zip Code Pct High School Only by Race (Census 1990)'
  blkscl90 = 'Blacks - Zip Code Pct Some College by Race (Census 1990)'
  blkcol90 = 'Blacks - Zip Code Pct College Education at least 4 years by Race (Census 1990)'
  aminon90 = 'American Indian - Zip Code Pct Non High School Grads by Race (Census 1990)'
  amihso90 = 'American Indian - Zip Code Pct High School Only by Race (Census 1990)'
  amiscl90 = 'American Indian - Zip Code Pct Some College by Race (Census 1990)'
  amicol90 = 'American Indian - Zip Code Pct College Education at least 4 years by Race (Census 1990)'
  asinon90 = 'Asian - Zip Code Pct Non High School Grads by Race (Census 1990)'
  asihso90 = 'Asian - Zip Code Pct High School Only by Race (Census 1990)'
  asiscl90 = 'Asian - Zip Code Pct Some College by Race (Census 1990)'
  asicol90 = 'Asian - Zip Code Pct College Education at least 4 years by Race (Census 1990)'
  othnon90 = 'Other - Zip Code Pct Non High School Grads by Race (Census 1990)'
  othhso90 = 'Other - Zip Code Pct High School Only by Race (Census 1990)'
  othscl90 = 'Other - Zip Code Pct Some College by Race (Census 1990)'
  othcol90 = 'Other - Zip Code Pct College Education at least 4 years by Race (Census 1990)'
  hspnon90 = 'Hispanic - Zip Code Pct Non High School Grads by Race (Census 1990)'
  hsphso90 = 'Hispanic - Zip Code Pct High School Only by Race (Census 1990)'
  hspscl90 = 'Hispanic - Zip Code Pct Some College by Race (Census 1990)'
  hspcol90 = 'Hispanic - Zip Code Pct College Education at least 4 years by Race (Census 1990)'
  zppci00  = 'Zip Code PCI (Census 2000)'
  zpmed00  = 'Zip Code Median Income (Census 2000)'
  zpden00  = 'Zip Code Density (Census 2000)'
  zpwht00  = 'Zip Code Pct Whites (Census 2000)'
  zpblk00  = 'Zip Code Pct Blacks (Census 2000)'
  zphsp00  = 'Zip Code Pct Hispanics (Census 2000)'
  zpen500  = 'Zip Code Pct of HHs who do not speak English well or at all 5+ (Census 2000)'
  zpen600  = 'Zip Code Pct of HHs who do not speak English well or at all 65+ (Census 2000)'
  zpnon00  = 'Zip Code Pct Non High School Grads (Census 2000)'
  zphso00  = 'Zip Code Pct High School Only (Census 2000)'
  zpscl00  = 'Zip Code Pct Some College Education (Census 2000)'
  zpcol00  = 'Zip Code Pct College Education at least 4 years (Census 2000)'
  whtnon00 = 'Whites - Zip Code Pct Non High School Grads by Race (Census 2000)'
  whthso00 = 'Whites - Zip Code Pct High School Only by Race (Census 2000)'
  whtscl00 = 'Whites - Zip Code Pct Some College by Race (Census 2000)'
  whtcol00 = 'Whites - Zip Code Pct College Education at least 4 years by Race (Census 2000)'
  blknon00 = 'Blacks - Zip Code Pct Non High School Grads by Race (Census 2000)'
  blkhso00 = 'Blacks - Zip Code Pct High School Only by Race (Census 2000)'
  blkscl00 = 'Blacks - Zip Code Pct Some College by Race (Census 2000)'
  blkcol00 = 'Blacks - Zip Code Pct College Education at least 4 years by Race (Census 2000)'
  aminon00 = 'American Indian - Zip Code Pct Non High School Grads by Race (Census 2000)'
  amihso00 = 'American Indian - Zip Code Pct High School Only by Race (Census 2000)'
  amiscl00 = 'American Indian - Zip Code Pct Some College by Race (Census 2000)'
  amicol00 = 'American Indian - Zip Code Pct College Education at least 4 years by Race (Census 2000)'
  asinon00 = 'Asian - Zip Code Pct Non High School Grads by Race (Census 2000)'
  asihso00 = 'Asian - Zip Code Pct High School Only by Race (Census 2000)'
  asiscl00 = 'Asian - Zip Code Pct Some College by Race (Census 2000)'
  asicol00 = 'Asian - Zip Code Pct College Education at least 4 years by Race (Census 2000)'
  othnon00 = 'Other - Zip Code Pct Non High School Grads by Race (Census 2000)'
  othhso00 = 'Other - Zip Code Pct High School Only by Race (Census 2000)'
  othscl00 = 'Other - Zip Code Pct Some College by Race (Census 2000)'
  othcol00 = 'Other - Zip Code Pct College Education at least 4 years by Race (Census 2000)'
  hspnon00 = 'Hispanic - Zip Code Pct Non High School Grads by Race (Census 2000)'
  hsphso00 = 'Hispanic - Zip Code Pct High School Only by Race (Census 2000)'
  hspscl00 = 'Hispanic - Zip Code Pct Some College by Race (Census 2000)'
  hspcol00 = 'Hispanic - Zip Code Pct College Education at least 4 years by Race (Census 2000)'
  natnon00 = 'Native Hawaiian - Zip Code Pct Non High School Grads by Race (Census 2000)'
  nathso00 = 'Native Hawaiian - Zip Code Pct High School Only by Race (Census 2000)'
  natscl00 = 'Native Hawaiian - Zip Code Pct Some College by Race (Census 2000)'
  natcol00 = 'Native Hawaiian - Zip Code Pct College Education at least 4 years by Race (Census 2000)'
  pov_tot90       = 'Percent of residents living below poverty (Census 1990)'
  pov_totlt65_90  = 'Percent of residents living below poverty less than 65 (Census 1990)'
  pov_tot6574_90  = 'Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_tot75_90    = 'Percent of residents living below poverty age 75+ (Census 1990)'
  pov_wht90       = 'White - Percent of residents living below poverty (Census 1990)'
  pov_blk90       = 'Black - Percent of residents living below poverty (Census 1990)'
  pov_ami90       = 'American Indian - Percent of residents living below poverty (Census 1990)'
  pov_asi90       = 'Asian - Percent of residents living below poverty (Census 1990)'

  pov_oth90       = 'Other - Percent of residents living below poverty (Census 1990)'
  pov_hsp90       = 'Hispanic - Percent of residents living below poverty (Census 1990)'
  pov_whtlt65_90  = 'White - Percent of residents living below poverty less than 65 (Census 1990)'
  pov_wht6574_90  = 'White - Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_wht75_90    = 'White - Percent of residents living below poverty age 75+ (Census 1990)'
  pov_blklt65_90  = 'Black - Percent of residents living below poverty less than 65 (Census 1990)'
  pov_blk6574_90  = 'Black - Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_blk75_90    = 'Black - Percent of residents living below poverty age 75+ (Census 1990)'
  pov_amilt65_90  = 'American Indian - Percent of residents living below poverty less than 65 (Census 1990)'
  pov_ami6574_90  = 'American Indian - Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_ami75_90    = 'American Indian - Percent of residents living below poverty age 75+ (Census 1990)'
  pov_asilt65_90  = 'Asian - Percent of residents living below poverty less than 65 (Census 1990)'
  pov_asi6574_90  = 'Asian - Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_asi75_90    = 'Asian - Percent of residents living below poverty age 75+ (Census 1990)'

  pov_nat6574_90  = 'Native Hawaiian - Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_nat75_90    = 'Native Hawaiian - Percent of residents living below poverty age 75+ (Census 1990)'
  pov_othlt65_90  = 'Other - Percent of residents living below poverty less than 65 (Census 1990)'
  pov_oth6574_90  = 'Other - Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_oth75_90    = 'Other - Percent of residents living below poverty age 75+ (Census 1990)'
  pov_hsplt65_90  = 'Hispanic - Percent of residents living below poverty less than 65 (Census 1990)'
  pov_hsp6574_90  = 'Hispanic - Percent of residents living below poverty age 65-74 (Census 1990)'
  pov_hsp75_90    = 'Hispanic - Percent of residents living below poverty age 75+ (Census 1990)'
  pov_tot00       = 'Percent of residents living below poverty (Census 2000)'
  pov_totlt65_00  = 'Percent of residents living below poverty less than 65 (Census 2000)'
  pov_tot6574_00  = 'Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_tot75_00    = 'Percent of residents living below poverty age 75+ (Census 2000)'
  pov_wht00       = 'White - Percent of residents living below poverty (Census 2000)'
  pov_blk00       = 'Black - Percent of residents living below poverty (Census 2000)'
  pov_ami00       = 'American Indian - Percent of residents living below poverty (Census 2000)'
  pov_asi00       = 'Asian - Percent of residents living below poverty (Census 2000)'
  pov_nat00       = 'Native Hawaiian - Percent of residents living below poverty (Census 2000)'
  pov_oth00       = 'Other - Percent of residents living below poverty (Census 2000)'
  pov_hsp00       = 'Hispanic - Percent of residents living below poverty (Census 2000)'
  pov_whtlt65_00  = 'White - Percent of residents living below poverty less than 65 (Census 2000)'
  pov_wht6574_00  = 'White - Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_wht75_00    = 'White - Percent of residents living below poverty age 75+ (Census 2000)'
  pov_blklt65_00  = 'Black - Percent of residents living below poverty less than 65 (Census 2000)'
  pov_blk6574_00  = 'Black - Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_blk75_00    = 'Black - Percent of residents living below poverty age 75+ (Census 2000)'
  pov_amilt65_00  = 'American Indian - Percent of residents living below poverty less than 65 (Census 2000)'
  pov_ami6574_00  = 'American Indian - Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_ami75_00    = 'American Indian - Percent of residents living below poverty age 75+ (Census 2000)'
  pov_asilt65_00  = 'Asian - Percent of residents living below poverty less than 65 (Census 2000)'
  pov_asi6574_00  = 'Asian - Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_asi75_00    = 'Asian - Percent of residents living below poverty age 75+ (Census 2000)'
  pov_natlt65_00  = 'Native Hawaiian - Percent of residents living below poverty less than 65 (Census 2000)'
  pov_nat6574_00  = 'Native Hawaiian - Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_nat75_00    = 'Native Hawaiian - Percent of residents living below poverty age 75+ (Census 2000)'
  pov_othlt65_00  = 'Other - Percent of residents living below poverty less than 65 (Census 2000)'
  pov_oth6574_00  = 'Other - Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_oth75_00    = 'Other - Percent of residents living below poverty age 75+ (Census 2000)'
  pov_hsplt65_00  = 'Hispanic - Percent of residents living below poverty less than 65 (Census 2000)'
  pov_hsp6574_00  = 'Hispanic - Percent of residents living below poverty age 65-74 (Census 2000)'
  pov_hsp75_00    = 'Hispanic - Percent of residents living below poverty age 75+ (Census 2000)'
  ;

run;

proc contents data=sumdencen position;
run;