Yes I followed the steps. I realize something is still missing. As my source_to_concept_map is still empty.
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.