Exporting ICD9CM mapping from Athena

[lychenus]

Hello guys, I guess I needed another thread for some newer attention.

I have a bunch of codes in ICD9CM concept code (e.g. 427.41) and I need it to OMOP.

There is a (next-to-)perfect map on Athena. However, it is very hard for me to convert my codes from one map to another and then back to OMOP. There are too much information loss over multiple mapping.

Is there a way to export the below webpage data into a big file of .csv?

The items in the red circles are exactly the data I need.

Thanks

[rookie_crewkie]

Hello @lychenus,

@lychenus

However, it is very hard for me to convert my codes from one map to another and then back to OMOP. There are too much information loss over multiple mapping.

Could you please elaborate on what you’re trying to do? Are you finding ICD9 codes mapping manually using website and then mapping records one by one (“back to OMOP”)? What’s the reason behind “information loss” if “There is a (next-to-)perfect map on Athena”?

@lychenus

Is there a way to export the below webpage data into a big file of .csv?

Your similar question in another thread has been answered. Have you tried following the steps?

[lychenus]

@rookie_crewkie

Your similar question in another thread has been answered . Have you tried following the steps?

Yes I followed the steps. I realize something is still missing. As my source_to_concept_map is still empty.

Could you please elaborate on what you’re trying to do?

I saw the suggested map on Athena and I just wanted to take the suggested map as stated on there like

162.3 → 261236 Primary malignant neoplasm of upper lobe, bronchus or lung

And there was a thread like just now. I do not think it is a very idea to keep going on that as it gets convoluted.

I tried to download the ICD9CM vocabulary from Athena again. I looked at at CONCEPT_RELATIONSHIP.csv again,

something like

41881366 41881366 Maps to 20190221 20991231

There are some “Maps to”, but can never find where is the “Non-standard to Standard map (OMOP)” as on Athena

tried the SQL query, but has no idea how that would be helpful too.

[MPhilofsky (Melanie Philofsky)]

On Athena the verbiage =

@lychenus

“Non-standard to Standard map (OMOP)”

In the Concept relationship table the verbiage =

@lychenus

“Maps to”,

These are the same. Athena has a more friendly user interface term.

As Maxim suggested, you will find the EHDEN Academy on the OMOP CDM and on the OMOP vocabularies very helpful!

[lychenus]

Ah I realize why something is missing. If I only download ICD9 or SNOMED seperately, the “maps to” relationship gets filtered out.

If I download the two vocab list selected together

44828793 201820 Maps to 20190228 20991231

shows up;.

eh.

Sorry for the mess and thanks for the help. Please have a nice weekend and so am i.