*-------------------------------------------------------------------*;
* IP2009.TXT                                                        *;
*                                                                   *;
* SAS INPUT STATEMENTS FOR MAX 2009 IP FILE - ALL VARIABLES         *;
*                 AND BETA-MAX 2010 IP FILE - ALL VARIABLES         *;
*                                                                   *;
* NOTE: THE ICNO AND ICNA ARE NOT INCLUDED IN THIS FILE             *;
*                                                                   *;
* LRECL = 807                                                       *;
*-------------------------------------------------------------------*;
    INPUT			
        @1     MSIS_ID                      $CHAR20.            
        @21    STATE_CD                     $CHAR02.
        @23    EL_SSN                       $CHAR09.
        @32    MDCD_HIC_NUM                 $CHAR12.
        @44    EL_DOB                            08.
        @52    EL_SEX_CD                    $CHAR01.
        @53    EL_RACE_ETHNCY_CD            $CHAR01.
        @54    RACE_CODE_1                  $CHAR01.
        @55    RACE_CODE_2                  $CHAR01.
        @56    RACE_CODE_3                  $CHAR01.
        @57    RACE_CODE_4                  $CHAR01.
        @58    RACE_CODE_5                  $CHAR01.
        @59    ETHNICITY_CODE               $CHAR01.
        @60    EL_SS_ELGBLTY_CD_LTST        $CHAR06.
        @66    EL_SS_ELGBLTY_CD_MO          $CHAR06.
        @72    EL_MAX_ELGBLTY_CD_LTST       $CHAR02.
        @74    EL_MAX_ELGBLTY_CD_MO         $CHAR02.
        @76    MSNG_ELG_DATA                $CHAR01.
        @77    EL_MDCR_XOVR_CLM_BSD_CD           01.
        @78    EL_MDCR_DUAL_ANN             $CHAR02.
        @80    MSIS_TOS                          02.
        @82    MSIS_TOP                          01.
        @83    MAX_TOS                           02.
        @85    PRVDR_ID_NMBR                $CHAR12.
        @97    NPI                          $CHAR12.
        @109   TAXONOMY                     $CHAR12.
        @121   TYPE_CLM_CD                  $CHAR01.
        @122   ADJUST_CD                         01.
        @123   PHP_TYPE                          02.
        @125   PHP_ID                       $CHAR12.
        @137   MDCD_PYMT_AMT                   ZD08.
        @145   TP_PYMT_AMT                     ZD08.
        @153   PYMT_DT                           08.
        @161   CHRG_AMT                        ZD08.
        @169   PHP_VAL                         ZD08.
        @177   MDCR_COINSUR_PYMT_AMT           ZD08.
        @185   MDCR_DED_PYMT_AMT               ZD08.
        @193   ADMSN_DT                          08.
        @201   SRVC_BGN_DT                       08.
        @209   SRVC_END_DT                       08.
        @217   DIAG_CD_1                    $CHAR08.
        @225   DIAG_CD_2                    $CHAR08.
        @233   DIAG_CD_3                    $CHAR08.
        @241   DIAG_CD_4                    $CHAR08.
        @249   DIAG_CD_5                    $CHAR08.
        @257   DIAG_CD_6                    $CHAR08.
        @265   DIAG_CD_7                    $CHAR08.
        @273   DIAG_CD_8                    $CHAR08.
        @281   DIAG_CD_9                    $CHAR08.
        @289   PRNCPL_PRCDR_DT                   08.
        @297   PRCDR_CD_SYS_1               $CHAR02.
        @299   PRCDR_CD_1                   $CHAR08.
        @307   PRCDR_CD_SYS_2               $CHAR02.
        @309   PRCDR_CD_2                   $CHAR08.
        @317   PRCDR_CD_SYS_3               $CHAR02.
        @319   PRCDR_CD_3                   $CHAR08.
        @327   PRCDR_CD_SYS_4               $CHAR02.
        @329   PRCDR_CD_4                   $CHAR08.
        @337   PRCDR_CD_SYS_5               $CHAR02.
        @339   PRCDR_CD_5                   $CHAR08.
        @347   PRCDR_CD_SYS_6               $CHAR02.
        @349   PRCDR_CD_6                   $CHAR08.
        @357   RCPNT_DLVRY_CD                    01.
        @358   MDCD_CVRD_IP_DAYS               ZD03.
        @361   PATIENT_STATUS_CD                 02.
        @363   DRG_REL_GROUP_IND            $CHAR04.
        @367   DRG_REL_GROUP                     04.
        @371   UB_92_REV_CD_GP_1                 04.
        @375   UB_92_REV_CD_CHGS_1             ZD08.
        @383   UB_92_REV_CD_UNITS_1              07.
        @390   UB_92_REV_CD_GP_2                 04.
        @394   UB_92_REV_CD_CHGS_2             ZD08.
        @402   UB_92_REV_CD_UNITS_2              07.
        @409   UB_92_REV_CD_GP_3                 04.
        @413   UB_92_REV_CD_CHGS_3             ZD08.
        @421   UB_92_REV_CD_UNITS_3              07.
        @428   UB_92_REV_CD_GP_4                 04.
        @432   UB_92_REV_CD_CHGS_4             ZD08.
        @440   UB_92_REV_CD_UNITS_4              07.
        @447   UB_92_REV_CD_GP_5                 04.
        @451   UB_92_REV_CD_CHGS_5             ZD08.
        @459   UB_92_REV_CD_UNITS_5              07.
        @466   UB_92_REV_CD_GP_6                 04.
        @470   UB_92_REV_CD_CHGS_6             ZD08.
        @478   UB_92_REV_CD_UNITS_6              07.
        @485   UB_92_REV_CD_GP_7                 04.
        @489   UB_92_REV_CD_CHGS_7             ZD08.
        @497   UB_92_REV_CD_UNITS_7              07.
        @504   UB_92_REV_CD_GP_8                 04.
        @508   UB_92_REV_CD_CHGS_8             ZD08.
        @516   UB_92_REV_CD_UNITS_8              07.
        @523   UB_92_REV_CD_GP_9                 04.
        @527   UB_92_REV_CD_CHGS_9             ZD08.
        @535   UB_92_REV_CD_UNITS_9              07.
        @542   UB_92_REV_CD_GP_10                04.
        @546   UB_92_REV_CD_CHGS_10            ZD08.
        @554   UB_92_REV_CD_UNITS_10             07.
        @561   UB_92_REV_CD_GP_11                04.
        @565   UB_92_REV_CD_CHGS_11            ZD08.
        @573   UB_92_REV_CD_UNITS_11             07.
        @580   UB_92_REV_CD_GP_12                04.
        @584   UB_92_REV_CD_CHGS_12            ZD08.
        @592   UB_92_REV_CD_UNITS_12             07.
        @599   UB_92_REV_CD_GP_13                04.
        @603   UB_92_REV_CD_CHGS_13            ZD08.
        @611   UB_92_REV_CD_UNITS_13             07.
        @618   UB_92_REV_CD_GP_14                04.
        @622   UB_92_REV_CD_CHGS_14            ZD08.
        @630   UB_92_REV_CD_UNITS_14             07.
        @637   UB_92_REV_CD_GP_15                04.
        @641   UB_92_REV_CD_CHGS_15            ZD08.
        @649   UB_92_REV_CD_UNITS_15             07.
        @656   UB_92_REV_CD_GP_16                04.
        @660   UB_92_REV_CD_CHGS_16            ZD08.
        @668   UB_92_REV_CD_UNITS_16             07.
        @675   UB_92_REV_CD_GP_17                04.
        @679   UB_92_REV_CD_CHGS_17            ZD08.
        @687   UB_92_REV_CD_UNITS_17             07.
        @694   UB_92_REV_CD_GP_18                04.
        @698   UB_92_REV_CD_CHGS_18            ZD08.
        @706   UB_92_REV_CD_UNITS_18             07.
        @713   UB_92_REV_CD_GP_19                04.
        @717   UB_92_REV_CD_CHGS_19            ZD08.
        @725   UB_92_REV_CD_UNITS_19             07.
        @732   UB_92_REV_CD_GP_20                04.
        @736   UB_92_REV_CD_CHGS_20            ZD08.
        @744   UB_92_REV_CD_UNITS_20             07.
        @751   UB_92_REV_CD_GP_21                04.
        @755   UB_92_REV_CD_CHGS_21            ZD08.
        @763   UB_92_REV_CD_UNITS_21             07.
        @770   UB_92_REV_CD_GP_22                04.
        @774   UB_92_REV_CD_CHGS_22            ZD08.
        @782   UB_92_REV_CD_UNITS_22             07.
        @789   UB_92_REV_CD_GP_23                04.
        @793   UB_92_REV_CD_CHGS_23            ZD08.
        @801   UB_92_REV_CD_UNITS_23             07.
        ;
                              
LABEL
 MSIS_ID                   = "MSIS identification number"
 STATE_CD                  = "State"
 EL_SSN                    = "Social Security Number (SSN)"
 MDCD_HIC_NUM              = "Medicare HIC number"
 EL_DOB                    = "Birth date"
 EL_SEX_CD                 = "Sex"
 EL_RACE_ETHNCY_CD         = "Race/ethnicity (from MSIS)"
 RACE_CODE_1               = "Race - White (from MSIS)"
 RACE_CODE_2               = "Race - Black (from MSIS)"
 RACE_CODE_3               = "Race - Am Indian/Alaskan (from MSIS)"
 RACE_CODE_4               = "Race - Asian (from MSIS)"
 RACE_CODE_5               = "Race - Hawaiian/Pac) Islands (from MSIS)"
 ETHNICITY_CODE            = "Ethnicity - Hispanic (from MSIS)"
 EL_SS_ELGBLTY_CD_LTST     = "State specific eligiblity - most recent"
 EL_SS_ELGBLTY_CD_MO       = "State specific eligiblity - mo of svc"
 EL_MAX_ELGBLTY_CD_LTST    = "MAX eligibility - most recent"
 EL_MAX_ELGBLTY_CD_MO      = "MAX eligibility - mo of svc"
 MSNG_ELG_DATA             = "Missing eligibility data"
 EL_MDCR_XOVR_CLM_BSD_CD   = "Crossover code (from claims only)"
 EL_MDCR_DUAL_ANN          = "Medicare dual code (Annual)"
 MSIS_TOS                  = "MSIS Type of Service (TOS)"
 MSIS_TOP                  = "MSIS Type of Program (TOP)"
 MAX_TOS                   = "MAX Type of Service (TOS)"
 PRVDR_ID_NMBR             = "Billing provider identification number"
 NPI                       = "National Provider Identifier"
 TAXONOMY                  = "Provider Taxonomy"
 TYPE_CLM_CD               = "Type of claim"
 ADJUST_CD                 = "Adjustment code"
 PHP_TYPE                  = "Managed care type of plan code"
 PHP_ID                    = "Managed care plan identification code"
 MDCD_PYMT_AMT             = "Medicaid payment amount"
 TP_PYMT_AMT               = "Third party payment amount"
 PYMT_DT                   = "Payment/adjudication date"
 CHRG_AMT                  = "Charge amount"
 PHP_VAL                   = "Prepaid plan value"
 MDCR_COINSUR_PYMT_AMT     = "Medicare coinsurance payment amount"
 MDCR_DED_PYMT_AMT         = "Medicare deductible payment amount"
 ADMSN_DT                  = "Admission date"
 SRVC_BGN_DT               = "Beginning date of service"
 SRVC_END_DT               = "Ending date of service"
 DIAG_CD_1                 = "Principle Diagnosis code"
 DIAG_CD_2                 = "Diagnosis codes (2nd diagnosis)"
 DIAG_CD_3                 = "Diagnosis codes (3rd diagnosis)"
 DIAG_CD_4                 = "Diagnosis codes (4th diagnosis)"
 DIAG_CD_5                 = "Diagnosis codes (5th diagnosis)"
 DIAG_CD_6                 = "Diagnosis codes (6th diagnosis)"
 DIAG_CD_7                 = "Diagnosis codes (7th diagnosis)"
 DIAG_CD_8                 = "Diagnosis codes (8th diagnosis)"
 DIAG_CD_9                 = "Diagnosis codes (9th diagnosis)"
 PRNCPL_PRCDR_DT           = "Principle procedure date"
 PRCDR_CD_SYS_1            = "Procedure code system- principal"
 PRCDR_CD_1                = "Principle procedure code"
 PRCDR_CD_SYS_2            = "Procedure code system (2nd procedure)"
 PRCDR_CD_2                = "Procedure code (2nd procedure)"
 PRCDR_CD_SYS_3            = "Procedure code system (3rd procedure)"
 PRCDR_CD_3                = "Procedure code (3rd procedure)"
 PRCDR_CD_SYS_4            = "Procedure code system (4th procedure)"
 PRCDR_CD_4                = "Procedure code (4th procedure)"
 PRCDR_CD_SYS_5            = "Procedure code system (5th procedure)"
 PRCDR_CD_5                = "Procedure code (5th procedure)"
 PRCDR_CD_SYS_6            = "Procedure code system (6th procedure)"
 PRCDR_CD_6                = "Procedure code (6th procedure)"
 RCPNT_DLVRY_CD            = "Delivery code"
 MDCD_CVRD_IP_DAYS         = "Medicaid covered inpatient days"
 PATIENT_STATUS_CD         = "Patient status"
 DRG_REL_GROUP_IND         = "Diagnosis Related Group (DRG) indicator"
 DRG_REL_GROUP             = "Diagnosis Related Group (DRG)"
 UB_92_REV_CD_GP_1         = "UB-92 revenue code (1st)"
 UB_92_REV_CD_CHGS_1       = "UB-92 revenue code charge (1st)"
 UB_92_REV_CD_UNITS_1      = "UB-92 revenue code units (1st)"
 UB_92_REV_CD_GP_2         = "UB-92 revenue code (2nd)"
 UB_92_REV_CD_CHGS_2       = "UB-92 revenue code charge (2nd)"
 UB_92_REV_CD_UNITS_2      = "UB-92 revenue code units (2nd)"
 UB_92_REV_CD_GP_3         = "UB-92 revenue code (3rd)"
 UB_92_REV_CD_CHGS_3       = "UB-92 revenue code charge (3rd)"
 UB_92_REV_CD_UNITS_3      = "UB-92 revenue code units (3rd)"
 UB_92_REV_CD_GP_4         = "UB-92 revenue code (4th)"
 UB_92_REV_CD_CHGS_4       = "UB-92 revenue code charge (4th)"
 UB_92_REV_CD_UNITS_4      = "UB-92 revenue code units (4th)"
 UB_92_REV_CD_GP_5         = "UB-92 revenue code (5th)"
 UB_92_REV_CD_CHGS_5       = "UB-92 revenue code charge (5th)"
 UB_92_REV_CD_UNITS_5      = "UB-92 revenue code units (5th)"
 UB_92_REV_CD_GP_6         = "UB-92 revenue code (6th)"
 UB_92_REV_CD_CHGS_6       = "UB-92 revenue code charge (6th)"
 UB_92_REV_CD_UNITS_6      = "UB-92 revenue code units (6th)"
 UB_92_REV_CD_GP_7         = "UB-92 revenue code (7th)"
 UB_92_REV_CD_CHGS_7       = "UB-92 revenue code charge (7th)"
 UB_92_REV_CD_UNITS_7      = "UB-92 revenue code units (7th)"
 UB_92_REV_CD_GP_8         = "UB-92 revenue code (8th)"
 UB_92_REV_CD_CHGS_8       = "UB-92 revenue code charge (8th)"
 UB_92_REV_CD_UNITS_8      = "UB-92 revenue code units (8th)"
 UB_92_REV_CD_GP_9         = "UB-92 revenue code (9th)"
 UB_92_REV_CD_CHGS_9       = "UB-92 revenue code charge (9th)"
 UB_92_REV_CD_UNITS_9      = "UB-92 revenue code units (9th)"
 UB_92_REV_CD_GP_10        = "UB-92 revenue code (10th)"
 UB_92_REV_CD_CHGS_10      = "UB-92 revenue code charge (10th)"
 UB_92_REV_CD_UNITS_10     = "UB-92 revenue code units (10th)"
 UB_92_REV_CD_GP_11        = "UB-92 revenue code (11th)"
 UB_92_REV_CD_CHGS_11      = "UB-92 revenue code charge (11th)"
 UB_92_REV_CD_UNITS_11     = "UB-92 revenue code units (11th)"
 UB_92_REV_CD_GP_12        = "UB-92 revenue code (12th)"
 UB_92_REV_CD_CHGS_12      = "UB-92 revenue code charge (12th)"
 UB_92_REV_CD_UNITS_12     = "UB-92 revenue code units (12th)"
 UB_92_REV_CD_GP_13        = "UB-92 revenue code (13th)"
 UB_92_REV_CD_CHGS_13      = "UB-92 revenue code charge (13th)"
 UB_92_REV_CD_UNITS_13     = "UB-92 revenue code units (13th)"
 UB_92_REV_CD_GP_14        = "UB-92 revenue code (14th)"
 UB_92_REV_CD_CHGS_14      = "UB-92 revenue code charge (14th)"
 UB_92_REV_CD_UNITS_14     = "UB-92 revenue code units (14th)"
 UB_92_REV_CD_GP_15        = "UB-92 revenue code (15th)"
 UB_92_REV_CD_CHGS_15      = "UB-92 revenue code charge (15th)"
 UB_92_REV_CD_UNITS_15     = "UB-92 revenue code units (15th)"
 UB_92_REV_CD_GP_16        = "UB-92 revenue code (16th)"
 UB_92_REV_CD_CHGS_16      = "UB-92 revenue code charge (16th)"
 UB_92_REV_CD_UNITS_16     = "UB-92 revenue code units (16th)"
 UB_92_REV_CD_GP_17        = "UB-92 revenue code (17th)"
 UB_92_REV_CD_CHGS_17      = "UB-92 revenue code charge (17th)"
 UB_92_REV_CD_UNITS_17     = "UB-92 revenue code units (17th)"
 UB_92_REV_CD_GP_18        = "UB-92 revenue code (18th)"
 UB_92_REV_CD_CHGS_18      = "UB-92 revenue code charge (18th)"
 UB_92_REV_CD_UNITS_18     = "UB-92 revenue code units (18th)"
 UB_92_REV_CD_GP_19        = "UB-92 revenue code (19th)"
 UB_92_REV_CD_CHGS_19      = "UB-92 revenue code charge (19th)"
 UB_92_REV_CD_UNITS_19     = "UB-92 revenue code units (19th)"
 UB_92_REV_CD_GP_20        = "UB-92 revenue code (20th)"
 UB_92_REV_CD_CHGS_20      = "UB-92 revenue code charge (20th)"
 UB_92_REV_CD_UNITS_20     = "UB-92 revenue code units (20th)"
 UB_92_REV_CD_GP_21        = "UB-92 revenue code (21st)"
 UB_92_REV_CD_CHGS_21      = "UB-92 revenue code charge (21st)"
 UB_92_REV_CD_UNITS_21     = "UB-92 revenue code units (21st)"
 UB_92_REV_CD_GP_22        = "UB-92 revenue code (22nd)"
 UB_92_REV_CD_CHGS_22      = "UB-92 revenue code charge (22nd)"
 UB_92_REV_CD_UNITS_22     = "UB-92 revenue code units (22nd)"
 UB_92_REV_CD_GP_23        = "UB-92 revenue code (23rd)"
 UB_92_REV_CD_CHGS_23      = "UB-92 revenue code charge (23rd)"
 UB_92_REV_CD_UNITS_23     = "UB-92 revenue code units (23rd)"
 ;
