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

options nocenter validvarname=upcase;

data zipcode;
  infile zipcode lrecl=246 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_unins_white               6.2  
        @042 pct_unins_black               6.2 
        @048 pct_unins_Asian               6.2 
        @054 pct_unins_NHPI                6.2 
        @060 pct_unins_AIAN                6.2 
        @066 pct_unins_Hispanic            6.2 
        @072 pct_unins_nonHispanic         6.2 
        @078 pct_unins_lt138pctpov         6.2 
        @084 pct_unins_agelt18             6.2 
        @090 pct_unins_agelt19             6.2
        @096 pct_unins_age1864             6.2 
        @102 pct_unins_age1964             6.2 
        @108 pct_Mcaid                     6.2 
        @114 pct_Mcaid_agelt18             6.2 
        @120 pct_Mcaid_agelt19             6.2 
        @126 pct_Mcaid_age1864             6.2 
        @132 pct_Mcaid_age1964             6.2 
        @138 pct_Mcaid_agegte65            6.2 
        @144 pct_ESI_agelt18               6.2 
        @150 pct_ESI_agelt19               6.2 
        @156 pct_ESI_age1864               6.2 
        @162 pct_ESI_age1964               6.2 
        @168 pct_ESI_agegte65              6.2 
        @174 pct_othpriv_1864              6.2 
        @180 pct_othpriv_1964              6.2 
        @186 pct_othpriv_agegte65          6.2 
        @192 pct_Medicare_age1864          6.2 
        @198 pct_Medicare_age1964          6.2 
        @204 pct_VAcare_age1864            6.2 
        @210 pct_VAcare_age1964            6.2 
        @216 pct_VAcare_agegte65           6.2 
        @222 pct_HH_SSI                    6.2 
        @228 pct_HH_TANFoth                6.2 
        @234 pct_HH_SNAP                   6.2 
        @240 pct_HH_TANFSNAP               6.2  
        ; 
      
  label
    timeperiod_acs               = "Time Period, ACS"                                                                                                                                                                                                                             
    zip5                         = "Zip Code"
    zp_poptot                    = "Total Population"                                                                                                                                                                                                                                                           
    zp_householdtot              = "Total Households"                                                                                                                                                                                                                                                           
    zp_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=zipcode position;
run;