/***********************************************************************/
/* IF YOU RECEIVED THE PEDSF FILE BEFORE APRIL 2007 THEN YOU WILL      */
/* NEED A DIFFERENT INPUT STATEMENT. PLEASE CONTACT ANGELA MEEKINS VIA */
/* E-MAIL MEEKINSA@IMSWEB.COM AND AN INPUT STATEMENT WILL BE SENT TO   */
/* YOU.                                                                */
/* This input statement is used to read in the pedsf.5percent.txt        */
/* file.                                                               */
/***********************************************************************/

*filename inped '/directory/pedsf.5percent.txt';                    /*reading in an unzipped file*/
filename inped pipe 'gunzip -c /directory/pedsf.5percent.txt.gz';   /*reading in a zipped file*/

options nocenter validvarname=upcase;

data pedsf(drop= inc begin end pos i p);  
  infile inped lrecl=1674 missover pad;
  input 
      @0001  regcase   $char10.
      @0011  fivepct   $char1.
      @0012  mat_type  $char1.
      @0013  yobflg1   $char1.
      @0014  dobflg2   $char1.
      @0015  yodflg3   $char1.
      @0016  sexflg4   $char1.
      @0017  lstflg5   $char1.
      @0018  fstflg6   $char1.
      @0019  mobflg7   $char1.
      @0020  midflg8   $char1.
      @0021  numdigit  $char1.
      @0022  dod_flg   $char1.
      @0024  med_dodm  $char2.
      @0026  med_dodd  $char2.
      @0028  med_dody  $char4.
      @0032  birthm    $char2.
      @0036  birthyr   $char4.
      @0040  m_sex     $char1.
      @0041  race      $char1.
      @0042  rsncd1    $char1.
      @0043  cur_ent   $char1.
      @0044  chr_esrd  $char1.
      @0045  med_stcd  $char2.      
      @0047  STATE     $char2.
      @0049  COUNTY    $char3.
      @0052  zip       $char9.        /*Special permission required*/
      @0061  code_sys  $char1.
      @0062  tract     $char6.        /*Special permission required*/
      @0068  tract2k   $char6.        /*Special permission required*/
      @0074  HSA       $char3.
      @0077  URBRUR    $char1.
      @0078  URBAN     $char2.
      @0080  ctpci90   10.
      @0090  ctmed90   10.
      @0100  ctden90   10.
      @0110  ctnon90   6.2
      @0116  cthso90   6.2
      @0122  ctscl90   6.2
      @0128  ctcol90   6.2
      @0134  ctblk90   6.2
      @0140  ctwht90   6.2
      @0146  cthsp90   6.2
      @0152  ctpov90   6.2
      @0158  cten590   6.2
      @0164  cten690   6.2
      @0170  medag90   10.
      @0180  medrc90   10.
      @0190  povrc90   6.2
      @0196  nonrc90   6.2
      @0202  hsorc90   6.2
      @0208  sclrc90   6.2
      @0214  colrc90   6.2            
      @0220  zppci90   10.
      @0230  zpmed90   10.
      @0240  zpden90   10.
      @0250  zpnon90   6.2
      @0256  zphso90   6.2
      @0262  zpscl90   6.2
      @0268  zpcol90   6.2
      @0274  zpblk90   6.2
      @0280  zpwht90   6.2
      @0286  zphsp90   6.2
      @0292  zpen590   6.2 
      @0298  zpen690   6.2
      @0304  znonrc90  6.2
      @0310  zhsorc90  6.2
      @0316  zsclrc90  6.2
      @0322  zcolrc90  6.2
      @0328  ctpci00   10.
      @0338  ctmed00   10.
      @0348  ctden00   10.
      @0358  ctnon00   6.2
      @0364  cthso00   6.2
      @0370  ctscl00   6.2
      @0376  ctcol00   6.2
      @0382  ctblk00   6.2
      @0388  ctwht00   6.2
      @0394  cthsp00   6.2
      @0400  ctpov00   6.2
      @0406  cten500   6.2
      @0412  cten600   6.2      
      @0418  medag00   10.
      @0428  medrc00   10.
      @0438  povrc00   6.2
      @0444  nonrc00   6.2
      @0450  hsorc00   6.2
      @0456  sclrc00   6.2
      @0462  colrc00   6.2      
      @0468  zppci00   10.
      @0478  zpmed00   10.
      @0488  zpden00   10.      
      @0498  zpnon00   6.2
      @0504  zphso00   6.2
      @0510  zpscl00   6.2
      @0516  zpcol00   6.2
      @0522  zpblk00   6.2
      @0528  zpwht00   6.2
      @0534  zphsp00   6.2
      @0540  zpen500   6.2
      @0546  zpen600   6.2
      @0552  znonrc00  6.2
      @0558  zhsorc00  6.2
      @0564  zsclrc00  6.2
      @0570  zcolrc00  6.2      
      @;

  array count1(22)   $ 2 ptacnt1986-ptacnt2007;
  array count2(22)   $ 2 ptbcnt1986-ptbcnt2007;
  array count3(22)   $ 2 hmocnt1986-hmocnt2007;
  array stbuy(22)    $ 2 stbuyin1986-stbuyin2007;
  array enmon(264)   $ 1 mon1-mon264;
  array ghon(264)    $ 1 gho1-gho264;
  array zipcd(22)    $ 9 zip1986-zip2007;
  array registry(22) $ 2 registry1986-registry2007;
  array regcd2(22)   $ 2 reg2cd1986-reg2cd2007;
   
      inc=638;
      retain begin end;
      begin=1;
      end=12;

      do i = 1 to 22;
        do p = begin to end;
        input @inc      enmon(p) $char1.
              @inc + 12 ghon(p)  $char1.
              @;
              inc=inc + 1;
              end;
          begin = begin + 12;
          end = end + 12;
    input @inc + 12  count1(i) $char2.
          @inc + 14  count2(i) $char2.
                @inc + 16  count3(i) $char2.
                @inc + 18  stbuy(i)  $char2.
                @;
          inc=inc + 20;
     end;

     inc2= 1374;
       do i = 1 to 22;                                  /*Special permission required for zipcd */
       input @inc2      zipcd(i)    $char9.
             @inc2 + 9  registry(i) $char2.
                   @inc2 +11  regcd2(i)   $char2.
                   @;
                   inc2=inc2+13;
             end;

  input;

label
  regcase  = 'SEER Registry Case Number'
  fivepct  = 'Five Percent Indicator'
  mat_type = 'Match Type'
  yobflg1  = 'Year of Birth Flag'
  dobflg2  = 'Day of Birth Flag'
  yodflg3  = 'Year of Death Flag'
  sexflg4  = 'Sex Flag'
  lstflg5  = 'Last Name Flag'
  fstflg6  = 'First Name Flag'
  mobflg7  = 'Month of Birth Flag'
  midflg8  = 'Middle Initial Flag'
  dod_flg  = 'Date of Death Flag'
  med_dodm = 'Medicare Month of Death'
  med_dodd = 'Medicare Day of Death'
  med_dody = 'Medicare Year of Death'
  birthm   = 'Medicare Month of Birth'
  birthyr  = 'Medicare Year of Birth'
  m_sex    = 'Medicare Sex'
  race     = 'Medicare Race'
  rsncd1   = 'Original Reason for Entitlement'
  cur_ent  = 'Current Reason for Entitlment'
  chr_esrd = 'Chronic Renal Disease'
  med_stcd = 'Medicare Status Code'
  mon1     = 'Part A and B Entitlement Indicator'
  gho1     = 'HMO Entitlement Indicator'
  ptacnt1986 = 'Number of Months in 1986 Covered for Part A'
  ptacnt1987 = 'Number of Months in 1987 Covered for Part A'
  ptacnt1988 = 'Number of Months in 1988 Covered for Part A'
  ptacnt1989 = 'Number of Months in 1989 Covered for Part A'
  ptacnt1990 = 'Number of Months in 1990 Covered for Part A'
  ptacnt1991 = 'Number of Months in 1991 Covered for Part A'
  ptacnt1992 = 'Number of Months in 1992 Covered for Part A'
  ptacnt1993 = 'Number of Months in 1993 Covered for Part A'
  ptacnt1994 = 'Number of Months in 1994 Covered for Part A'
  ptacnt1995 = 'Number of Months in 1995 Covered for Part A'
  ptacnt1996 = 'Number of Months in 1996 Covered for Part A'
  ptacnt1997 = 'Number of Months in 1997 Covered for Part A'
  ptacnt1998 = 'Number of Months in 1998 Covered for Part A'
  ptacnt1999 = 'Number of Months in 1999 Covered for Part A'
  ptacnt2000 = 'Number of Months in 2000 Covered for Part A'
  ptacnt2001 = 'Number of Months in 2001 Covered for Part A'
  ptacnt2002 = 'Number of Months in 2002 Covered for Part A'
  ptacnt2003 = 'Number of Months in 2003 Covered for Part A'
  ptacnt2004 = 'Number of Months in 2004 Covered for Part A'
  ptacnt2005 = 'Number of Months in 2005 Covered for Part A'
  ptacnt2006 = 'Number of Months in 2006 Covered for Part A'
  ptacnt2007 = 'Number of Months in 2007 Covered for Part A'
  ptbcnt1986 = 'Number of Months in 1986 Covered for Part B'
  ptbcnt1987 = 'Number of Months in 1987 Covered for Part B'
  ptbcnt1988 = 'Number of Months in 1988 Covered for Part B'
  ptbcnt1989 = 'Number of Months in 1989 Covered for Part B'
  ptbcnt1990 = 'Number of Months in 1990 Covered for Part B'
  ptbcnt1991 = 'Number of Months in 1991 Covered for Part B'
  ptbcnt1992 = 'Number of Months in 1992 Covered for Part B'
  ptbcnt1993 = 'Number of Months in 1993 Covered for Part B'
  ptbcnt1994 = 'Number of Months in 1994 Covered for Part B'
  ptbcnt1995 = 'Number of Months in 1995 Covered for Part B'
  ptbcnt1996 = 'Number of Months in 1996 Covered for Part B'
  ptbcnt1997 = 'Number of Months in 1997 Covered for Part B'
  ptbcnt1998 = 'Number of Months in 1998 Covered for Part B'
  ptbcnt1999 = 'Number of Months in 1999 Covered for Part B'
  ptbcnt2000 = 'Number of Months in 2000 Covered for Part B'
  ptbcnt2001 = 'Number of Months in 2001 Covered for Part B'
  ptbcnt2002 = 'Number of Months in 2002 Covered for Part B'
  ptbcnt2003 = 'Number of Months in 2003 Covered for Part B'
  ptbcnt2004 = 'Number of Months in 2004 Covered for Part B'
  ptbcnt2005 = 'Number of Months in 2005 Covered for Part B'
  ptbcnt2006 = 'Number of Months in 2006 Covered for Part B'
  ptbcnt2007 = 'Number of Months in 2007 Covered for Part B'
  hmocnt1986 = 'Number of Months in 1986 as an HMO member'
  hmocnt1987 = 'Number of Months in 1987 as an HMO member'
  hmocnt1988 = 'Number of Months in 1988 as an HMO member'
  hmocnt1989 = 'Number of Months in 1989 as an HMO member'
  hmocnt1990 = 'Number of Months in 1990 as an HMO member'
  hmocnt1991 = 'Number of Months in 1991 as an HMO member'
  hmocnt1992 = 'Number of Months in 1992 as an HMO member'
  hmocnt1993 = 'Number of Months in 1993 as an HMO member'
  hmocnt1994 = 'Number of Months in 1994 as an HMO member'
  hmocnt1995 = 'Number of Months in 1995 as an HMO member'
  hmocnt1996 = 'Number of Months in 1996 as an HMO member'
  hmocnt1997 = 'Number of Months in 1997 as an HMO member'
  hmocnt1998 = 'Number of Months in 1998 as an HMO member'
  hmocnt1999 = 'Number of Months in 1999 as an HMO member'
  hmocnt2000 = 'Number of Months in 2000 as an HMO member'
  hmocnt2001 = 'Number of Months in 2001 as an HMO member'
  hmocnt2002 = 'Number of Months in 2002 as an HMO member'
  hmocnt2003 = 'Number of Months in 2003 as an HMO member'
  hmocnt2004 = 'Number of Months in 2004 as an HMO member'
  hmocnt2005 = 'Number of Months in 2005 as an HMO member'
  hmocnt2006 = 'Number of Months in 2006 as an HMO member'
  hmocnt2007 = 'Number of Months in 2007 as an HMO member'
  stbuyin1986 = 'Number of Months in 1986 with State Buy-in Coverage'
  stbuyin1987 = 'Number of Months in 1987 with State Buy-in Coverage'
  stbuyin1988 = 'Number of Months in 1988 with State Buy-in Coverage'
  stbuyin1989 = 'Number of Months in 1989 with State Buy-in Coverage'
  stbuyin1990 = 'Number of Months in 1990 with State Buy-in Coverage'
  stbuyin1991 = 'Number of Months in 1991 with State Buy-in Coverage'
  stbuyin1992 = 'Number of Months in 1992 with State Buy-in Coverage'
  stbuyin1993 = 'Number of Months in 1993 with State Buy-in Coverage'
  stbuyin1994 = 'Number of Months in 1994 with State Buy-in Coverage'
  stbuyin1995 = 'Number of Months in 1995 with State Buy-in Coverage'
  stbuyin1996 = 'Number of Months in 1996 with State Buy-in Coverage'
  stbuyin1997 = 'Number of Months in 1997 with State Buy-in Coverage'
  stbuyin1998 = 'Number of Months in 1998 with State Buy-in Coverage'
  stbuyin1999 = 'Number of Months in 1999 with State Buy-in Coverage'
  stbuyin2000 = 'Number of Months in 2000 with State Buy-in Coverage'
  stbuyin2001 = 'Number of Months in 2001 with State Buy-in Coverage'
  stbuyin2002 = 'Number of Months in 2002 with State Buy-in Coverage'
  stbuyin2003 = 'Number of Months in 2003 with State Buy-in Coverage'
  stbuyin2004 = 'Number of Months in 2004 with State Buy-in Coverage'
  stbuyin2005 = 'Number of Months in 2005 with State Buy-in Coverage'
  stbuyin2006 = 'Number of Months in 2006 with State Buy-in Coverage'
  stbuyin2007 = 'Number of Months in 2007 with State Buy-in Coverage'
  zip1986   = 'Zip Code in 1986'
  zip1987   = 'Zip Code in 1987'
  zip1988   = 'Zip Code in 1988'
  zip1989   = 'Zip Code in 1989'
  zip1990   = 'Zip Code in 1990'
  zip1991   = 'Zip Code in 1991'
  zip1992   = 'Zip Code in 1992'
  zip1993   = 'Zip Code in 1993'
  zip1994   = 'Zip Code in 1994'
  zip1995   = 'Zip Code in 1995'
  zip1996   = 'Zip Code in 1996'
  zip1997   = 'Zip Code in 1997'
  zip1998   = 'Zip Code in 1998'
  zip1999   = 'Zip Code in 1999'
  zip2000   = 'Zip Code in 2000'
  zip2001   = 'Zip Code in 2001'
  zip2002   = 'Zip Code in 2002'
  zip2003   = 'Zip Code in 2003'
  zip2004   = 'Zip Code in 2004'
  zip2005   = 'Zip Code in 2005'
  zip2006   = 'Zip Code in 2006'
  zip2007   = 'Zip Code in 2007'
  registry1986 ='SEER registry code in 1986 (retained over years)'
  registry1987 ='SEER registry code in 1987 (retained over years)'
  registry1988 ='SEER registry code in 1988 (retained over years)'
  registry1989 ='SEER registry code in 1989 (retained over years)'
  registry1990 ='SEER registry code in 1990 (retained over years)'
  registry1991 ='SEER registry code in 1991 (retained over years)'
  registry1992 ='SEER registry code in 1992 (retained over years)'
  registry1993 ='SEER registry code in 1993 (retained over years)'
  registry1994 ='SEER registry code in 1994 (retained over years)'
  registry1995 ='SEER registry code in 1995 (retained over years)'
  registry1996 ='SEER registry code in 1996 (retained over years)'
  registry1997 ='SEER registry code in 1997 (retained over years)'
  registry1998 ='SEER registry code in 1998 (retained over years)'
  registry1999 ='SEER registry code in 1999 (retained over years)'
  registry2000 ='SEER registry code in 2000 (retained over years)'
  registry2001 ='SEER registry code in 2001 (retained over years)'
  registry2002 ='SEER registry code in 2002 (retained over years)'
  registry2003 ='SEER registry code in 2003 (retained over years)'
  registry2004 ='SEER registry code in 2004 (retained over years)'
  registry2005 ='SEER registry code in 2005 (retained over years)'
  registry2006 ='SEER registry code in 2006 (retained over years)'
  registry2007 ='SEER registry code in 2007 (retained over years)'
  reg2cd1986   = 'SEER registry code at the end of the year (1986)'
  reg2cd1987   = 'SEER registry code at the end of the year (1987)'
  reg2cd1988   = 'SEER registry code at the end of the year (1988)'
  reg2cd1989   = 'SEER registry code at the end of the year (1989)'
  reg2cd1990   = 'SEER registry code at the end of the year (1990)'
  reg2cd1991   = 'SEER registry code at the end of the year (1991)'
  reg2cd1992   = 'SEER registry code at the end of the year (1992)'
  reg2cd1993   = 'SEER registry code at the end of the year (1993)'
  reg2cd1994   = 'SEER registry code at the end of the year (1994)'
  reg2cd1995   = 'SEER registry code at the end of the year (1995)'
  reg2cd1996   = 'SEER registry code at the end of the year (1996)'
  reg2cd1997   = 'SEER registry code at the end of the year (1997)'
  reg2cd1998   = 'SEER registry code at the end of the year (1998)'
  reg2cd1999   = 'SEER registry code at the end of the year (1999)'
  reg2cd2000   = 'SEER registry code at the end of the year (2000)'
  reg2cd2001   = 'SEER registry code at the end of the year (2001)'
  reg2cd2002   = 'SEER registry code at the end of the year (2002)'
  reg2cd2003   = 'SEER registry code at the end of the year (2003)'
  reg2cd2004   = 'SEER registry code at the end of the year (2004)'
  reg2cd2005   = 'SEER registry code at the end of the year (2005)'
  reg2cd2006   = 'SEER registry code at the end of the year (2006)'
  reg2cd2007   = 'SEER registry code at the end of the year (2007)'
  state    = 'State'
  county   = 'County'
  zip      = 'Zip Code'
  tract    = 'Census Tract 1970/80/90'
  tract2k  = 'Census Tract 2000'
  hsa      = 'Health Service Area'
  ctpci00  = 'Census Tract PCI (Census 2000)'                       
  ctmed00  = 'Census Tract Median Income (Census 2000)'             
  ctnon00  = 'Census Tract Pct Non High School Grads (Census 2000)'
  cthso00  = 'Census Tract Pct High School Only (Census 2000)'
  ctscl00  = 'Census Tract Pct Some College Education (Census 2000)'
  ctcol00  = 'Census Tract Pct College Education at least 4 years (Census 2000)' 
  ctden00  = 'Census Tract Density (Census 2000)'
  ctblk00  = 'Census Tract Pct Blacks (Census 2000)'                
  ctwht00  = 'Census Tract Pct Whites (Census 2000)'    
  cthsp00  = 'Census Tract Pct Hispanics (Census 2000)'
  ctpov00  = 'Census Tract Pct Poverty for All (Census 2000)'
  cten500  = 'Census Tract Pct of HHs who do not speak English well or at all 5+ (Census 2000)'
  cten600  = 'Census Tract Pct of HHs who do not speak English well or at all 65+ (Census 2000)'
  medag00  = 'Census Tract Median HH Income by Age (Census 2000)'
  medrc00  = 'Census Tract Median HH Income by Race (Census 2000)'
  povrc00  = 'Census Tract Pct Poverty by Race/Age (Census 2000)'
  nonrc00  = 'Census Tract Pct Non High School Grads by Race (Census 2000)'
  hsorc00  = 'Census Tract Pct High School Only by Race (Census 2000)'
  sclrc00  = 'Census Tract Pct Some College by Race (Census 2000)'
  colrc00  = 'Census Tract Pct College Education by Race (Census 2000)'
  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)'
  znonrc00 = 'Zip Code Pct Non High School Grads by Race (Census 2000)'
  zhsorc00 = 'Zip Code Pct High School Only by Race (Census 2000)'
  zsclrc00 = 'Zip Code Pct Some College by Race (Census 2000)'
  zcolrc00 = 'Zip Code Pct College Education by Race (Census 2000)'
  CODE_SYS = "Census Cod Sys 1970/80/90"
  ;

run;

proc contents data=pedsf;
   title 'proc contents, of PEDSF file';