/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for ACS data for the Census Tract File  */
/*Mobility Bucket                                                     */
/*Match this file to the census tract codes in the SEER File          */
/*to obtain the 2008-2012 and 2013-2017 ACS data for each             */
/*Census Tract.                                                       */
/*                                                                    */
/**********************************************************************/

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

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=356 missover pad;
  input @001 ct_version                      $char2.
        @003 timeperiod_acs                  $char2.
        @005 state                           $char2.
        @007 county                          $char3.
        @010 tract_num                       $char6.
        @016 ct_poptot                       10.
        @026 ct_householdtot                 10.
        @036 ct_popdensity                   8.2
        @044 pct_nomove                      6.2 
        @050 pct_localmove                   6.2
        @056 pct_xstatemove                  6.2
        @062 pct_moved2US                    6.2
        @068 pct_limEng5yrs                  6.2
        @074 pct_limEng65yrs                 6.2
        @080 pct_HH_limEng                   6.2
        @086 pct_nonUSborn                   6.2
        @092 pct_commute_gte30mins           6.2
        @098 pct_commute_pubtrans            6.2
        @104 pct_workers_novehic             6.2
        @110 pct_HH_nophone                  6.2
        @116 pct_HH_nointernet               6.2
        @122 pct_HH_broadband                6.2
        @128 pct_HH_nocomputer               6.2
        @134 pct_HH_havecomputer             6.2
        @140 pct_rented                      6.2
        @146 med_gross_rent                  10.
        @156 pct_renters_rentgte30pct        6.2
        @162 pct_gte1occupant                6.2
        @168 med_home_val                    10.
        @178 med_monthly_housingcost         10.
        @188 pct_HH_multifam                 6.2
        @194 pct_HH_mobile                   6.2
        @200 pct_unoccupied                  6.2
        @206 LQ_White_Alone                  10.8 
        @216 LQ_Black_Alone                  10.8
        @226 LQ_API_Alone                    10.8
        @236 LQ_Hispanic                     10.8
        @246 Lex_Is_Black_Alone_White_Alone  10.8
        @256 Lex_Is_API_Alone_White_Alone    10.8
        @266 Lex_Is_Hispanic_NH_White_Alone  10.8
        @276 ICE_Black_Alone_White_Alone     10.8
        @286 ICE_API_Alone_White_Alone       10.8
        @296 ICE_Hispanic_NH_White_Alone     10.8
        @306 LIS_White_Alone                 10.8
        @316 LIS_Black_Alone                 10.8
        @326 LIS_API_Alone                   10.8
        @336 LIS_Hispanic                    10.8
        @346 LIS_NH_White_Alone              10.8; 
      
  label
    ct_version                      = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_acs                  = "Time Period, ACS Data"                                                                                                                                                                                                                             
    state                           = "State"                                                                                                                                                                                                                                                                      
    county                          = "County"                                                                                                                                                                                                                                                                     
    tract_num                       = "Tract Number"                                                                                                                                                                                                                                                               
    ct_poptot                       = "Total Population"                 
    ct_householdtot                 = "Total Households"
    ct_popdensity                   = "Population Density"
    pct_nomove                      = "Pct did not Move in the Past Year: Total Population"
    pct_localmove                   = "Pct moved within the Same County or State: Total Population"
    pct_xstatemove                  = "Pct moved from a Different State: Total Population"
    pct_moved2US                    = "Pct moved from Abroad: Total Population"
    pct_limEng5yrs                  = "Pct not speaking English well or not at all: Population 5+"
    pct_limEng65yrs                 = "Pct not speaking English well or not at all: Population 65+"
    pct_HH_limEng                   = "Pct Limited English Speaking: Total Households"
    pct_nonUSborn                   = "Pct born outside of the U.S.: Total Population"
    pct_commute_gte30mins           = "Pct Travel to work time >=30 minutes: Commuters 16+"
    pct_commute_pubtrans            = "Pct using public transportation to travel to work: Commuters 16+"
    pct_workers_novehic             = "Pct with no vehicle: Population of workers 16+"
    pct_HH_nophone                  = "Pct with no telephone service: Total Households"
    pct_HH_nointernet               = "Pct with no internet access: Total Households"
    pct_HH_broadband                = "Pct with Broadband: Total Households"
    pct_HH_nocomputer               = "Pct with no computer: Total Households"
    pct_HH_havecomputer             = "Pct with computer: Total Households"
    pct_rented                      = "Pct of occupied units rented: Total Occupied Housing Units"
    med_gross_rent                  = "Median Gross Rent: Renter occupied households"
    pct_renters_rentgte30pct        = "Pct with gross rent > 30% of household income: Renter Occupied Housing Units"
    pct_gte1occupant                = "Pct with >1 Occupant per room, Total Occupied Housing Units"
    med_home_val                    = "Median Home Value"
    med_monthly_housingcost         = "Median Monthly Housing Costs"
    pct_HH_multifam                 = "Pct in buildings with 10+  units: Total households"
    pct_HH_mobile                   = "Pct mobile home: Total Households"
    pct_unoccupied                  = "Pct of Housing Units not occupied: Total Housing Units"
    LQ_White_Alone                  = "Location Quotient (LQ): White alone"
    LQ_Black_Alone                  = "Location Quotient (LQ): Black alone"
    LQ_API_Alone                    = "Location Quotient (LQ): Asian or Pacific Islander alone"
    LQ_Hispanic                     = "Location Quotient (LQ): Hispanic alone"
    Lex_Is_Black_Alone_White_Alone  = "Local Exposure and Isolation (Lex/IS): Black or African American Alone/White Alone"
    Lex_Is_API_Alone_White_Alone    = "Local Exposure and Isolation (Lex/IS): Asian or Pacific Islander Alone/White Alone"
    Lex_Is_Hispanic_NH_White_Alone  = "Local Exposure and Isolation (Lex/IS): Hispanic/White Alone, Non-Hispanic"
    ICE_Black_Alone_White_Alone     = "Index of Concentration at Extremes (ICE): Black or African American Alone/White Alone"
    ICE_API_Alone_White_Alone       = "Index of Concentration at Extremes (ICE): Asian or Pacific Islander Alone/White Alone"
    ICE_Hispanic_NH_White_Alone     = "Index of Concentration at Extremes (ICE): Hispanic/White Alone, Non-Hispanic"
    LIS_White_Alone                 = "Local Isolation Score:  White alone"
    LIS_Black_Alone                 = "Local Isolation Score:  Black alone"
    LIS_API_Alone                   = "Local Isolation Score:  Asian or Pacific Islander alone"
    LIS_Hispanic                    = "Local Isolation Score:  Hispanic"
    LIS_NH_White_Alone              = "Local Isolation Score:  NH_White Alone";
  
run;                                
                                  
proc contents data=tract position;
run;