/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for the Census Tract File Mobility      */
/*Bucket for the Home Owner Load Corporation Subfile                  */
/*Match this file to the census tract codes in the SEER File          */
/*to obtain the HOLC Data                                             */
/*                                                                    */
/**********************************************************************/

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

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=40 missover pad;
  input @001 ct_version                    $char2.
        @003 timeperiod_holc               $char2.
        @005 state                         $char2.
        @007 county                        $char3.
        @010 tract_num                     $char6.
        @016 HOLC_class1                   $1. 
        @017 HOLC_class2_red               $23.; 
      
  label
    ct_version      = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_holc = "Time Period, HOLC Data"                                                                                                                                                                                                                             
    state           = "State"                                                                                                                                                                                                                                                                      
    county          = "County"                                                                                                                                                                                                                                                                     
    tract_num       = "Tract Number"                                                                                                                                                                                                                                                               
    HOLC_class1     = "Percentile rank air quality domain"
    HOLC_class2_red = "Percentile rank of domain capturing proximity to polluted sites or high risk sites";
  
run;                                
                                  
proc contents data=tract position;
run;