/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for USDA Poverty data for the Census    */
/*Tract File Demographic Bucket                                       */
/*Match this file to the census tract codes in the SEER File          */
/*to obtain the 2007-2011 and 2015-2019 poverty measures for each     */
/*Census Tract.                                                       */
/**********************************************************************/

*filename tract '/directory/tract.encr.usda_pov.demographic.txt';                    /*reading in an un-zipped file*/
filename tract pipe 'gunzip -c /directory/tract.encr.usda_pov.demographic.txt.gz';   /*reading in a zipped file*/

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=24 missover pad;
  input @001 ct_version                    $char2.
        @003 timeperiod_usda               $char2.
        @005 state                         $char2.
        @007 county                        $char3.
        @010 tract_num                     $char6.
        @016 highpov_ct                    2.
        @018 extremepov_ct                 2.
        @020 persistentpov_ct              2.
        @022 enduringpov_ct                2.;
        ; 
      
  label
    ct_version                   = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_usda              = "Time Period - USDA Poverty Data Files"                                                                                                                                                                                                                             
    state                        = "State"                                                                                                                                                                                                                                                                      
    county                       = "County"                                                                                                                                                                                                                                                                     
    tract_num                    = "Tract Number"                                                                                                                                                                                                                                                               
    highpov_ct                   = "High Poverty"
    extremepov_ct                = "Extreme Poverty"
    persistentpov_ct             = "Persistent Poverty"
    enduringpov_ct               = "Enduring Poverty";
  
run;                                
                                  
proc contents data=tract position;
run;