/*Published: 11/19/2024*/
/**********************************************************************/
/*This is the input statement for the Census Tract File Mobility      */
/*Bucket for the USDA Food Access Subfile                             */
/*Match this file to the census tract codes in the SEER File          */
/*to obtain the USDA Food Access Data                                 */
/*                                                                    */
/**********************************************************************/

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

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=71 missover pad;
  input @001 ct_version                    $char2.
        @003 timeperiod_foodacc            $char2.
        @005 state                         $char2.
        @007 county                        $char3.
        @010 tract_num                     $char6.
        @016 ct_non_rural                  1. 
        @017 ct_rural                      1.
        @018 lowfoodct_halfmile            1.
        @019 lowfoodct_1mile               1.
        @020 lowfoodct_10mile              1.
        @021 lowfoodct_20mile              1.
        @022 lowfood_nocar_20mile          1.
        @023 pct_lowfood_halfmile          6.2   
        @029 pct_lowfood_nocar_halfmile    6.2
        @035 pct_lowfood_1mile             6.2
        @041 pct_lowfood_nocar_1mile       6.2
        @047 pct_lowfood_10mile            6.2
        @053 pct_lowfood_nocar_10mile      6.2
        @059 pct_lowfood_20mile            6.2
        @065 pct_lowfood_nocar_20mile      6.2; 
      
  label
    ct_version                 = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_foodacc         = "Time Period, Food Access Data"                                                                                                                                                                                                                             
    state                      = "State"                                                                                                                                                                                                                                                                      
    county                     = "County"                                                                                                                                                                                                                                                                     
    tract_num                  = "Tract Number"                                                                                                                                                                                                                                                               
    ct_non_rural               = "Urban Tract"
    ct_rural                   = "Rural Tract"
    lowfoodct_halfmile         = "Low access tract at 1/2 mile"
    lowfoodct_1mile            = "Low access tract at 1 mile"
    lowfoodct_10mile           = "Low access tract at 10 miles"
    lowfoodct_20mile           = "Low access tract at 20 miles"
    lowfood_nocar_20mile       = "Low access tract using vehicle access and  20 mile threshold"
    pct_lowfood_halfmile       = "Low access, people at 1/2 mile, share"
    pct_lowfood_nocar_halfmile = "Vehicle access, housing units without and low access at 1/2 mile, share"
    pct_lowfood_1mile          = "Percent low access, 1 mile threshold"
    pct_lowfood_nocar_1mile    = "Vehicle access, housing units without and low access at 1 mile, share"
    pct_lowfood_10mile         = "Low access, people at 10 miles, share"
    pct_lowfood_nocar_10mile   = "Vehicle access, housing units without and low access at 10 miles, share"
    pct_lowfood_20mile         = "Low access, people at 20 miles, share"
    pct_lowfood_nocar_20mile   = "Vehicle access, housing units without and low access at 20 miles, share";
  
run;                                
                                  
proc contents data=tract position;
run;