/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for the Census Tract File Mobility      */
/*Bucket for the Home Mortgage Disclosure Act Subfile                 */
/*Match this file to the census tract codes in the SEER File          */
/*to obtain the HMDA Data                                             */
/*                                                                    */
/**********************************************************************/

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

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=34 missover pad;
  input @001 ct_version                    $char2.
        @003 timeperiod_hdma               $char2.
        @005 state                         $char2.
        @007 county                        $char3.
        @010 tract_num                     $char6.
        @016 odds_locationbias             6.4 
        @022 odds_mortgagedeny_black       6.4
        @028 odds_mortgagedeny_hisp        6.4; 
      
  label
    ct_version                 = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_hdma            = "Time Period - HDMA Data"                                                                                                                                                                                                                             
    state                      = "State"                                                                                                                                                                                                                                                                      
    county                     = "County"                                                                                                                                                                                                                                                                     
    tract_num                  = "Tract Number"                                                                                                                                                                                                                                                               
    odds_locationbias          = "Mortgage Denial: Location Bias"   
    odds_mortgagedeny_black    = "Mortgage Denial: Racial Bias"  
    odds_mortgagedeny_hisp     = "Mortgage Denial: Ethnic Bias";
  
run;                                
                                  
proc contents data=tract position;
run;