Is this an appropriate way to get all of the Sexually Transmitted Infectious Diseases (STIs) in ICD9CM that map to the SNOMED categorization of STI?

Implementers
1

I have a data set that uses ICD9CM codes to encode condition/diagnosis. I would like to use the SNOMED-CD category for “Sexually transmitted infectious disease” (concept_id = 8098009) using the OHDSI/OMOP/Athena concept tables.

Details on how I’m doing it are here:
https://stackoverflow.com/questions/73200958/is-this-an-appropriate-way-to-get-all-of-the-stis-in-icd9cm-that-map-to-the-snom

Is this a (the) correct way to do this?

What might be a better way to do this?

Thanks,
John