/* Published: 04/01/2023 */

/**************************   COMMENTS   *******************************/
/* THIS INPUT STATMENT IS FOR THE 2022 SEER-MEDICAID LINKAGE.          */
/* IF YOU RECEIVED MEDICAID FILES BEFORE MAY 2023 THEN YOU WILL        */
/* NEED A DIFFERENT INPUT STATEMENT. PLEASE CONTACT IMS VIA E-MAIL AT  */
/* SEER-MEDICARE@IMSWEB.COM AND AN INPUT STATEMENT WILL BE SENT TO YOU */
/***********************************************************************/

/***************   IMPORTANT PROGRAMING NOTES   ************************/
/* If you are using PC SAS to read in these files you will have to     */
/* un-zip the files first and use the un-zipped filename statement,    */
/* rather than using the zipped files and statement.                   */
/***********************************************************************/

*filename tafdates '/directory/taf.demog.dates.2019.txt';                    /* reading in an un-zipped file* /
*filename tafdates pipe 'gunzip -c /directory/taf.demog.dates.2019.txt.gz';  /* reading in a zipped file */
*filename tafdates pipe 'gunzip -c /directory/taf.demog.dates.*.txt.gz';     /* using wildcard to match multiple files */

options nocenter validvarname=upcase;

data taf_dates;
  length Patient_ID                       $15
         MSIS_ID                          $32
         ;


  infile tafdates lrecl=72 missover;

  input @00001 Patient_ID                       $CHAR15.
        @00016 MSIS_ID                          $CHAR32.  /*encrypted*/
        @00048 STATE_CD                         $CHAR2.
        @00050 SUBMTG_STATE_CD                  $CHAR2.
        @00052 ENRLMT_TYPE_CD                   $CHAR1.
        @00053 ENRLMT_START_DT                  $CHAR8.   /*YYMMDD8*/
        @00061 ENRLMT_END_DT                    $CHAR8.   /*YYMMDD8*/
        @00069 RFRNC_YR                         $CHAR4.
        ;


  label Patient_ID                       = "Encrypted CCW Beneficiary Identifier"
        MSIS_ID                          = "Encrypted State Assigned Beneficiary Unique Identifier"
        STATE_CD                         = "Submitting State Alpha Abbreviation"
        SUBMTG_STATE_CD                  = "Submitting State Entity Code"
        ENRLMT_TYPE_CD                   = "Enrollment Type Code - Medicaid or CHIP"
        ENRLMT_START_DT                  = "Enrollment Start Date (Within Calendar Yr)"
        ENRLMT_END_DT                    = "Enrollment End Date (Within Calendar Yr)"
        RFRNC_YR                         = "Reference Yr"
	;
run;

title 'T-MSIS ANALYTIC FILE DEMOG/ELIG DATES SAS Data Set for Researcher';
proc contents data=taf_dates position;
run;


* End of Program *;