I am trying to map our diagnosis data. However, some of our source data has SNOMED Problem code
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
Z992 but the actual code is
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