/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for ACS data for the Census Tract File  */
/*Insurance 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.insurance.txt.gz';                /*reading in an un-zipped file*/
filename tract pipe 'gunzip -c /directory/tract.encr.acs.insurance.txt.gz';   /*reading in a zipped file*/

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=254 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_unins_white               6.2  
        @050 pct_unins_black               6.2 
        @056 pct_unins_Asian               6.2 
        @062 pct_unins_NHPI                6.2 
        @068 pct_unins_AIAN                6.2 
        @074 pct_unins_Hispanic            6.2 
        @080 pct_unins_nonHispanic         6.2 
        @086 pct_unins_lt138pctpov         6.2 
        @092 pct_unins_agelt18             6.2 
        @098 pct_unins_agelt19             6.2
        @104 pct_unins_age1864             6.2 
        @110 pct_unins_age1964             6.2 
        @116 pct_Mcaid                     6.2 
        @122 pct_Mcaid_agelt18             6.2 
        @128 pct_Mcaid_agelt19             6.2 
        @134 pct_Mcaid_age1864             6.2 
        @140 pct_Mcaid_age1964             6.2 
        @146 pct_Mcaid_agegte65            6.2 
        @152 pct_ESI_agelt18               6.2 
        @158 pct_ESI_agelt19               6.2 
        @164 pct_ESI_age1864               6.2 
        @170 pct_ESI_age1964               6.2 
        @176 pct_ESI_agegte65              6.2 
        @182 pct_othpriv_1864              6.2 
        @188 pct_othpriv_1964              6.2 
        @194 pct_othpriv_agegte65          6.2 
        @200 pct_Medicare_age1864          6.2 
        @206 pct_Medicare_age1964          6.2 
        @212 pct_VAcare_age1864            6.2 
        @218 pct_VAcare_age1964            6.2 
        @224 pct_VAcare_agegte65           6.2 
        @230 pct_HH_SSI                    6.2 
        @236 pct_HH_TANFoth                6.2 
        @242 pct_HH_SNAP                   6.2 
        @248 pct_HH_TANFSNAP               6.2  
        ; 
      
  label
    ct_version                   = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_acs               = "Time Period for ACS Data"                                                                                                                                                                                                                             
    state                        = "State"                                                                                                                                                                                                                                                                      
    county                       = "County"                                                                                                                                                                                                                                                                     
    tract_num                    = "Tract Number"                                                                                                                                                                                                                                                                      
    ct_poptot                    = "Total Population"                                                                                                                                                                                                                                                           
    ct_householdtot              = "Total Households"                                                                                                                                                                                                                                                           
    ct_popdensity                = "Population Density"                                                                                                                                                                                                                                                         
    pct_unins_white              = "Pct uninsured: pop'n identified as white"                                                                                                                                                                                                                                   
    pct_unins_black              = "Pct uninsured: pop'n identified as black"                                                                                                                                                                                                                                   
    pct_unins_Asian              = "Pct uninsured: pop'n identified as Asian"                                                                                                                                                                                                                                   
    pct_unins_NHPI               = "Pct uninsured: pop'n identified as NH/PI"                                                                                                                                                                                                                                   
    pct_unins_AIAN               = "Pct uninsured: pop'n identified as AI/AN"                                                                                                                                                                                                                                   
    pct_unins_Hispanic           = "Pct uninsured: pop'n identified as Hispanic"                                                                                                                                                                                                                                
    pct_unins_nonHispanic        = "Pct uninsured: pop'n identified non-Hispanic"                                                                                                                                                                                                                               
    pct_unins_lt138pctpov        = "Pct uninsured: pop'n w/ income < 138% FPL"                                                                                                                                                                                                                                  
    pct_unins_agelt18            = "Pct uninsured: pop'n age < 18"                                                                                                                                                                                                                                              
    pct_unins_agelt19            = "Pct uninsured: pop'n age < 19"                                                                                                                                                                                                                                              
    pct_unins_age1864            = "Pct uninsured: pop'n age 18-64"                                                                                                                                                                                                                                             
    pct_unins_age1964            = "Pct uninsured: pop'n age 19-64"                                                                                                                                                                                                                                             
    pct_Mcaid                    = "Pct Medicaid/means-tested public coverage: total population"                                                                                                                                                                                                                
    pct_Mcaid_agelt18            = "Pct Medicaid/means-tested public coverage: pop'n age < 18 years"                                                                                                                                                                                                            
    pct_Mcaid_agelt19            = "Pct Medicaid/means-tested public coverage: pop'n age < 19 years"                                                                                                                                                                                                            
    pct_Mcaid_age1864            = "Pct with Medicaid/means-tested public coverage: pop'n age 18-64"                                                                                                                                                                                                            
    pct_Mcaid_age1964            = "Pct with Medicaid/means-tested public coverage: pop'n age 19-64"                                                                                                                                                                                                            
    pct_Mcaid_agegte65           = "Pct with Medicaid/means-tested public coverage: pop'n age >= 65 years"                                                                                                                                                                                                      
    pct_ESI_agelt18              = "Pct with employer-sponsored insurance: pop'n age < 18 years"                                                                                                                                                                                                                
    pct_ESI_agelt19              = "Pct with employer-sponsored insurance: pop'n age < 19 years"                                                                                                                                                                                                                
    pct_ESI_age1864              = "Pct with employer-sponsored insurance: pop'n age 18-64 years"                                                                                                                                                                                                               
    pct_ESI_age1964              = "Pct with employer-sponsored insurance: pop'n age 19-64 years"                                                                                                                                                                                                               
    pct_ESI_agegte65             = "Pct with employer-sponsored insurance: pop'n age >= 65 years"                                                                                                                                                                                                               
    pct_othpriv_1864             = "Pct with direct purchase insurance: pop'n age 18-64 years"                                                                                                                                                                                                                  
    pct_othpriv_1964             = "Pct with direct purchase insurance: pop'n age 19-64 years"                                                                                                                                                                                                                  
    pct_othpriv_agegte65         = "Pct with direct purchase insurance: pop'n age >= 65 years"                                                                                                                                                                                                                  
    pct_Medicare_age1864         = "Pct with Medicare: pop'n age 18-64 years"                                                                                                                                                                                                                                   
    pct_Medicare_age1964         = "Pct with Medicare: pop'n age 19-64 years"                                                                                                                                                                                                                                   
    pct_VAcare_age1864           = "Pct receiving VA care: pop'n age 18-64 years"                                                                                                                                                                                                                               
    pct_VAcare_age1964           = "Pct receiving VA care: pop'n age 19-64 years"                                                                                                                                                                                                                               
    pct_VAcare_agegte65          = "Pct receiving VA care: pop'n age >= 65 years"                                                                                                                                                                                                                               
    pct_HH_SSI                   = "Pct receiving SSI: Total households"                                                                                                                                                                                                                                        
    pct_HH_TANFoth               = "Pct receiving public cash assistance: Total households"                                                                                                                                                                                                                     
    pct_HH_SNAP                  = "Pct receiving food stamps/SNAP: Total households"                                                                                                                                                                                                                           
    pct_HH_TANFSNAP              = "Pct receiving public cash assistance or food stamps/SNAP: Total households"                                                                                                                                                                                                 
    ;
  
run;                                
                                  
proc contents data=tract position;
run;