The macro is available to download here: charlson. #SPSS CODE ELIXHAUSER COMORBID INDEX DOWNLOAD# Regardless of which Medicare files an investigator decides to use as input, the files should be subset to include a limited number of variables as described below. All ICD-9-CM diagnosis codes on these records should be 5 characters long and ICD-9-CM procedure codes should be 4 characters long. MEDPAR - keep Patient_ID, admission date (ADM_M, ADM_D, ADM_Y), admitting diagnosis code (ADMDXCDE), diagnosis codes 1-25 (DGN_CD1-DGN_CD25), surgery codes 1-25 (SRGCDE1-SRGCDE25), and length of stay (LOS).īefore invoking the SAS macro, decimal points or blanks occurring within the number should be removed from the code (ex.#SPSS CODE ELIXHAUSER COMORBID INDEX CODE# NCH - keep Patient_ID, claim from date (from_dtm, from_dtd, from_dty), 14 diagnosis codes (pdgns_cd, dgn_cd1-dgn_cd12, linediag).The carrier data can have more than one claim for the same date of service and all claims for each date should be included. OUTPAT - keep Patient_ID, claim from date (from_dtm, from_dtd, from_dty), diagnosis codes 1-25 (dgn_cd1-dgn_cd25), ICD procedure codes 1-13 (prcdr_cd1-prcdr_cd13).The final SAS file which combines data from any of the above sources must include the variables used in the Macro call. If the comorbidity score for the 12 months prior to diagnosis is to be calculated, then only records with claim dates falling within that window should be kept. These variables are needed for the macro: However, if the rule-out algorithm is invoked, claims for 30 days before and after the window of analysis should also be kept.Īn example SAS program to build an input file is available here. PATID - Variable name: Unique ID for each patient. STARTDATE - Variable name: Date the comorbidity window starts, in SAS date format.ĮNDDATE - Variable name: Date the comorbidity window ends, in SAS date format.ĬLAIMDATE - Variable name: Date of the claim found on the claim file, in SAS date format. This can be created by using the MDY() function.ĬLAIMTYPE - Variable name: the source of the claim record ('M'=MEDPAR, 'O'=OUTPAT, 'N'=NCH). #SPSS CODE ELIXHAUSER COMORBID INDEX DOWNLOAD#.#SPSS CODE ELIXHAUSER COMORBID INDEX CODE#.
0 kommentar(er)
