/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for SVI data for the Census Tract File  */
/*Demographic Bucket                                                  */
/*Match this file to the census tract codes in the SEER File          */
/*to obtain the 2010 and 2016 CDC SVI data for each                   */
/*Census Tract.                                                       */
/**********************************************************************/

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

options nocenter validvarname=upcase;

data tract;
  infile tract lrecl=76 missover pad;
  input @001 ct_version                    $char2.
        @003 timeperiod_svi                $char2.
        @005 state                         $char2.
        @007 county                        $char3.
        @010 tract_num                     $char6.
        @016 pctl_SVI_socioec              6.4
        @022 pctl_SVI_HHcomp               6.4
        @028 pctl_SVI_minoritystat         6.4
        @034 pctl_SVI_transp               6.4
        @040 pctl_SVI_overall              6.4
        @046 flagsum_SVI_socioec           6.
        @052 flagsum_SVI_HHcomp            6.
        @058 flagsum_SVI_minoritystat      6.
        @064 flagsum_SVI_transp            6.
        @070 flagsum_SVI_all               6.; 
      
  label
    ct_version                   = "Census tract assignment version (2010 vs 2020)"                                                                                                                                                                                                                            
    timeperiod_svi               = "Time Period - SVI Data Files"
    state                        = "State"                                                                                                                                                                                                                                                                      
    county                       = "County"                                                                                                                                                                                                                                                                     
    tract_num                    = "Tract Number"                                                                                                                                                                                                                                                               
    pctl_SVI_socioec             = "Percentile Ranking for Socioeconomic theme summary"      
    pctl_SVI_HHcomp              = "Percentile Ranking for household composition theme summary"
    pctl_SVI_minoritystat        = "Percentile Ranking for minority status/language theme summary"
    pctl_SVI_transp              = "Percentile Ranking for Housing/Transportation theme summary"
    pctl_SVI_overall             = "Overall percentile ranking"
    flagsum_SVI_socioec          = "Sum of flags for Socioeconomic theme summary"
    flagsum_SVI_HHcomp           = "Sum of flags for household composition theme summary"
    flagsum_SVI_minoritystat     = "Sum of flags for minority status/language theme summary"
    flagsum_SVI_transp           = "Sum of flags for Housing/Transportation theme summary"
    flagsum_SVI_all              = "Sum of flags for the four themes";
  
run;                                
                                  
proc contents data=tract position;
run;