/********************************************************************/
/*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=488 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
      ;

label
  state    = 'State Code'
  zip5     = '5 Digit Zip Code'
  zppci90  = 'Zip Code PCI (Census 1990)'                       
  zpmed90  = 'Zip Code Median Income (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)' 
  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)'
  zppci00  = 'Zip Code PCI (Census 2000)'                       
  zpmed00  = 'Zip Code Median Income (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)' 
  zpden00  = 'Zip Code Density (Census 2000)'
  zpblk00  = 'Zip Code Pct Blacks (Census 2000)'                
  zpwht00  = 'Zip Code Pct Whites (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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  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)'
  ;

run;

proc contents data=sumdencen position;
run;