/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for ACS data for the Zip Code File      */
/*Mobility Bucket                                                     */
/*Match this file to the zip codes in the claims files                */
/*to obtain the 2008-2012, 2013-2017, and 2018-2022 ACS data for each */
/*Zip Code.                                                           */
/*                                                                    */
/**********************************************************************/

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

options nocenter validvarname=upcase;

data zipcode;
  infile zipcode lrecl=198 missover pad;
  input @001 timeperiod_acs                  $char2.
        @003 zip5                            $char5.
        @008 zp_poptot                       10.
        @018 zp_householdtot                 10.
        @028 zp_popdensity                   8.2
        @036 pct_nomove                      6.2 
        @042 pct_localmove                   6.2
        @048 pct_xstatemove                  6.2
        @054 pct_moved2US                    6.2
        @060 pct_limEng5yrs                  6.2
        @066 pct_limEng65yrs                 6.2
        @072 pct_HH_limEng                   6.2
        @078 pct_nonUSborn                   6.2
        @084 pct_commute_gte30mins           6.2
        @090 pct_commute_pubtrans            6.2
        @096 pct_workers_novehic             6.2
        @102 pct_HH_nophone                  6.2
        @108 pct_HH_nointernet               6.2
        @114 pct_HH_broadband                6.2
        @120 pct_HH_nocomputer               6.2
        @126 pct_HH_havecomputer             6.2
        @132 pct_rented                      6.2
        @138 med_gross_rent                  10.
        @148 pct_renters_rentgte30pct        6.2
        @154 pct_gte1occupant                6.2
        @160 med_home_val                    10.
        @170 med_monthly_housingcost         10.
        @180 pct_HH_multifam                 6.2
        @186 pct_HH_mobile                   6.2
        @192 pct_unoccupied                  6.2; 
      
  label
    timeperiod_acs                  = "Time Period, ACS"                                                                                                                                                                                                                             
    zip5                            = "Zip Code"                                                                                                                                                                                                                                                               
    zp_poptot                       = "Total Population"                 
    zp_householdtot                 = "Total Households"
    zp_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";
  
run;                                
                                  
proc contents data=zipcode position;
run;