Hello Everyone,
I am trying to map our diagnosis data. However, some of our source data has SNOMED Problem code
Example:
SNOMED problem code - 1786560016 (source data)
Putting this problem code in the concept code of the concept table gives 0 records
Putting this problem code in the SNOMED browser gives SCTID = 398760006 as shown here
Putting this SCTID in the concept code of the concept table gives 381572
Has anyone here tried this before?
Is there any automated way or database querying approach to get the corresponding SCTID for all my problem codes that I have in my source data? I can automate it but before I do it, would like to check with the community on whether anyone has already tried it or is there any other way to do this?
q2) Our source data has ICD code data as well. However, the code is missing the dot
in between. For ex: I have a code which is E1472
, Z992
but the actual code is E14.72
and Z99.2
. Is there any specific guideline on where the dot should be? how can I know where the dot should be put to be able to use them to map it OMOP concept Id? In this case, should we just rely on textual description of the diagnosis to map to OMOP concept ID?
How can these issues be fixed? Any advice on how did you handle such issues would really be helpful