/*Published: 08/01/2025*/
/**********************************************************************/
/*This is the input statement for SVI data for the Zip Code File      */
/*Demographic Bucket                                                  */
/*Match this file to the zip codes in the claims Files                */
/*to obtain the 2010 and 2016 CDC SVI data for each                   */
/*Zip Code.                                                           */
/**********************************************************************/

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

options nocenter validvarname=upcase;

data zipcode;
  infile zipcode lrecl=68 missover pad;
  input @001 timeperiod_svi                $char2.
        @003 zip5                          $char5.
        @008 pctl_SVI_socioec              6.4
        @014 pctl_SVI_HHcomp               6.4
        @020 pctl_SVI_minoritystat         6.4
        @026 pctl_SVI_transp               6.4
        @032 pctl_SVI_overall              6.4
        @038 flagsum_SVI_socioec           6.
        @044 flagsum_SVI_HHcomp            6.
        @050 flagsum_SVI_minoritystat      6.
        @056 flagsum_SVI_transp            6.
        @062 flagsum_SVI_all               6.; 
      
  label
    timeperiod_svi               = "Time Period, SVI"                                                                                                                                                                                                                             
    zip5                         = "Zip Code"                                                                                                                                                                                                                                                               
    pctl_SVI_socioec             = "CDC SVI: Percentile Ranking for Socioeconomic theme summary"      
    pctl_SVI_HHcomp              = "CDC SVI: Percentile Ranking for household composition theme summary"
    pctl_SVI_minoritystat        = "CDC SVI: Percentile Ranking for minority status/language theme summary"
    pctl_SVI_transp              = "CDC SVI: Percentile Ranking for Housing/Transportation theme summary"
    pctl_SVI_overall             = "CDC SVI: Overall percentile ranking"
    flagsum_SVI_socioec          = "CDC SVI: Sum of flags for Socioeconomic theme summary"
    flagsum_SVI_HHcomp           = "CDC SVI: Sum of flags for household composition theme summary"
    flagsum_SVI_minoritystat     = "CDC SVI: Sum of flags for minority status/language theme summary"
    flagsum_SVI_transp           = "CDC SVI: Sum of flags for Housing/Transportation theme summary"
    flagsum_SVI_all              = "CDC SVI: Sum of flags for the four themes";
  
run;                                
                                  
proc contents data=zipcode position;
run;