/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for EJI data for the Census Tract File  */
/*Mobility Bucket                                                     */
/*Match this file to the census tract codes in the SEER File          */
/*to obtain the 2022 EJI data for each Census Tract                   */
/**********************************************************************/



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

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=58 missover pad;
  input @001 ct_version                    $char2.
        @003 timeperiod_eji                $char2.
        @005 state                         $char2.
        @007 county                        $char3.
        @010 tract_num                     $char6.
        @016 pctl_EJI_airqual              6.4  
        @022 pctl_EJI_toxsites             6.4
        @028 pctl_EJI_builtenv             6.4
        @034 pctl_EJI_transport            6.4
        @040 pctl_EJI_waterpol             6.4
        @046 pctl_EJI_envburden            6.4
        @052 sum_EJI_alldoms               6.4; 
      
  label
    ct_version                   = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_eji               = "Time Period, EJI Data"                                                                                                                                                                                                                             
    state                        = "State"                                                                                                                                                                                                                                                                      
    county                       = "County"                                                                                                                                                                                                                                                                     
    tract_num                    = "Tract Number"                                                                                                                                                                                                                                                               
    pctl_EJI_airqual             = "Percentile rank air quality domain"
    pctl_EJI_toxsites            = "Percentile rank of domain capturing proximity to polluted sites or high risk sites"
    pctl_EJI_builtenv            = "Percentile rank of domain capturing built environment"
    pctl_EJI_transport           = "Percentile rank of domain capturing proximity to transportation infrastructure"
    pctl_EJI_waterpol            = "Percentile rank of domain capturing proximity to impaired bodies of water"
    pctl_EJI_envburden           = "The environmental burden module percentile ranks"
    sum_EJI_alldoms              = "Summation of percentile ranks of all the domains";
  
run;                                
                                  
proc contents data=tract position;
run;