search

tuva-health / desynpuf

0 stars 0 forks source link

refactor icd9-to-icd10 conversion #2

Open aneiderhiser opened 2 years ago

aneiderhiser commented 2 years ago

Currently the conversion is a left join to a lookup table (one table for diagnoses and one for procedures). However these lookup tables have multiple mappings for each diagnosis and the logic likely needs to be updated to "choose" which mapping to use.

The mapping files came from here: https://www.nber.org/research/data/icd-9-cm-and-icd-10-cm-and-icd-10-pcs-crosswalk-or-general-equivalence-mappings

There are write-ups / examples on the website for how to do the lookups.

aneiderhiser commented 2 years ago

Both diagnoses and procedures need work, but procedures in particular look pretty messed up.