Non-cancer illness code match

Yuanyue Zhu

I am working with the variable p20002_i0, which is a collection of multiple non-cancer illnesses. However, I have noticed that the values from p20002_i0_a1 to p20002_i0_a33 do not correspond directly to the mapping table available at https://biobank.ctsu.ox.ac.uk/crystal/coding.cgi?id=6. For example, values like 1065 and 1075 are not valid numbers according to the mapping table. 

Could anyone provide guidance on how to convert these values into their corresponding diseases accurately?Thank you very much for your help.

Comments

1 comment

Date Votes
  • Comment author
    Lazaros Belbasis

    You can map the values in the variables p20002_i0_a1 to p20002_i0_a33 directly to the codes listed here: 

    https://biobank.ctsu.ox.ac.uk/crystal/coding.cgi?id=6

    For the mapping process, you use the number that is available in the column “Coding”. A simple way to do this is by downloading the coding table and uploading it to RAP, so you can merge the values automatically with R or Python. 

    Regarding the examples you mentioned, both codes existing in the mapping table: 1065 corresponds to hypertension, and 1075 corresponds to heart attack/myocardial infarction.

    2

Please sign in to leave a comment.