Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to define Hospital Procedure codes that are not ICD

    Hello,

    I have this dataset that deals with patients diagnosis and procedures they have done, and they are both in string format. I was able to define my "diagnosis" as they were in ICD-10 Codes, but my "procedures" are using CCI (Canadian Classification Health Intervention) code, so now, I have NO IDEA how to define it and also change it into a any format other than String so that I can work with it.

    I would GREATLY appreciate if someone can help me.

  • #2
    Elnaz:
    welcome to this forum.
    You may want to take a look at:
    -help destring-;
    -help emcode-.
    Please take a look (and act on) the FAQ to post more effectively. Thanks.
    Kind regards,
    Carlo
    (Stata 19.0)

    Comment


    • #3
      thanks for the reply, I will certainly look into it. But from what I've seen on the forum and questions usually everyone was dealing with the ICD-9 or 10 codes here, but my problem is that my codes are CCI and the STATA do not have them

      Comment


      • #4
        Elnaz:
        you may try -search CCI- and see whether such a community-contributed programme exists.
        Kind regards,
        Carlo
        (Stata 19.0)

        Comment


        • #5
          Hi Elnaz, you do not analogues of Stata's special -icd9- suite of commands to work with your codes. I've not worked with CCHI codes, but a brief mention of them on Wikipedia confirms my suspicion that they are a structured, alphanumeric code, in a similar way that ICD-9 and ICD-10 codes have a structure, and use a mix of alphanumeric characters. I would suggest that you work with them as strings directly, as trying to encode them as numbers will naturally fail, and encoding them creates an unnecessary complication.

          The dictionary of these codes should be available to your institution and probably also from their creator, the Canadian Institutes for Health Information. Presumably you have already collaborated with your colleagues to identify a list of codes of interest.

          What follows is general advice. I recommend reading "Chapter 24 Wokring with strings" from the [U] Users Guide manual, which is part of the PDF documentation that is included with your Stata installation. Stata also has several functions for operations on strings, found from -help string functions-, that you may find useful.

          Comment


          • #6
            I'm not Canadian and I've never worked with CCHI codes. However, if you go to the CIHI's website, it can be a bit hard to know what to search for. This page takes you to a downloadable list of CCI codes indexed alphabetically by the name of the actual procedure or as the codes are written. I assume you were asked to flag certain procedures. Without knowing more about the task, you would just look up the procedures in the list. It would probably be easier if there were an online database of those codes, like there is for ICD-10 or -9 codes (e.g. icd10data.com). As a general comment, if you were given a vague request, you should probably ask for more specifics, e.g. you want to get the person to work towards a specific list of all procedures related to the request.

            Just for interest's sake, I think the equivalents used in the US are the Current Procedural Terminology codes (CPT, this is intellectual property of the American Medical Association) and Healthcare Common Procedure Coding System codes (HCPCS, pronounced 'hick-picks').
            Be aware that it can be very hard to answer a question without sample data. You can use the dataex command for this. Type help dataex at the command line.

            When presenting code or results, please use the code delimiters format them. Use the # button on the formatting toolbar, between the " (double quote) and <> buttons.

            Comment

            Working...
            X