*-------------------------------------------------------------------*;
* IP2008.TXT                                                        *;
*                                                                   *;
* SAS INPUT STATEMENTS FOR MAX 2008 IP FILE - ALL VARIABLES         *;
*                                                                   *;
* LRECL = 807                                                       *;
*                                                                   *;
* MODIFICATIONS:                                                    *;
* -------------                                                     *;
*-------------------------------------------------------------------*;
    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                       01.
        @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)"
 ;
