APHEO - 10 Recommended ICD-10-CA Codes for Injury Indicators

To advance and promote the discipline and professional practice of epidemiology in Ontario public health units

Please click here to visit our new website

10 Recommended ICD-10-CA Codes for Injury Indicators - Stata Syntax

*Syntax for Use with the "Recommended ICD-10-CA Codes for Injury Indicators" *

*Created Jan 30, 2013. Updated July 24, 2013*.
*Authors: Suzanne Fegan (KFL&A Public Health), adapted from code written by Katherine Russell (Ottawa Public Health)

*This document is intended for use with "Recommended ICD-10-CA Codes for Injury Indicators"
*that can be found in the Core Indicators Resource section of the APHEO website at www.apheo.ca

*Users may download injury data (from pre-defined reports in IntelliHEALTH) for your chosen
*Injury Core Indicator. Then, you may use this syntax to get desired injury categories
*as defined in the "Recommended ICD-10-CA Codes for Injury Indicators"

***************************Syntax to run to get your database set up to analyze***********
******************************************************************************************

**The following are general steps that you need to complete after you've finished
*downloading your linelist of injury data from IntelliHEALTH.

*****Step 1.*****
*You need to rename ICD10 code variable
*The original name of the code variable will differ depending on the data source

*Emergency Visit and Hospitalization data
rename icd10_all_prob_dx_code ICD10extcause

*Mortality data (Note: mortality codes are based on ICD-10 codes,
*not ICD10-CA -so there are never any 5 digit codes)
*Note: if your ICD10 code variable name is different than the one shown below, please replace it with
*the correct name.
rename icd10_all_prob_dx_code ICD10extcause

*****Step 2. *****
*rename some of the imported variable names into shorter ones
*run whatever renames below are relevant to your data.
*if your original varnames are different than shown below, update them before running the code
*these codes names will be used throughout this document.

rename cyear year
rename age_grp_desc ageg
rename place_of_occurrence_code place

*For the place of occurrence, use the following code if you would like word descriptions instead of the number code
replace place="Home" if place=="U980"
replace place="Residential Institution" if place=="U981"
replace place="Schools, etc" if place=="U982"
replace place="Sports and Athletic area" if place=="U983"
replace place="Street and Highway" if place=="U984"
replace place="Trade and Service area" if place=="U985"
replace place="Industrial and Construction area" if place=="U986"
replace place="Farm" if place=="U987"
replace place="Other specified place" if place=="U988"
replace place="Unspecified" if place=="U989"

*******************Distinct Counts*****************************************

*For whatever catgeory you are looking at, you need the correct denominator, which is where distinct counts come in.
*If someone has two fall external cause codes for the same visit, you only wish to count them once.
*If someone has a fall code and a MVC code and you are looking at falls, you wish to count them.

*Please use the following syntax to get the correct denominator. Please change the variable 'fall' and replace it
*whatever category you are looking at. Also, rename your distinct_fall variable, again with whatever variable you
*are analyzing.

*example if you are looking to get the distinct number of people with at least one fall code
bysort fall NACRS_Key : gen distinct_fall = _n == 1 if fall==1
count if distinct_fall ==1

*example if you are looking to get the distinct number of people with at least one MVC code (variable name=collision)
bysort collision NACRS_Key : gen distinct_collision = _n == 1 if collision==1
count if distinct_collision ==1

*******************************************************************************************
*********************Table 1 in "Recommended ICD-10-CA Codes for Injury Indicators" *******
*******************************************************************************************

**Note: The ambulatory database as of calender year 2003 (or fiscal year 2002-2003), uses ICD-10-CA codes

**All Unintentional Injuries
gen unintent=0
replace unintent=1 if ((ICD10extcause>="V00" & ICD10extcause<="V9999") | ///
(ICD10extcause>="W00" & ICD10extcause<="W9999") | ///
(ICD10extcause>="X00" & ICD10extcause<="X5999") | ///
(ICD10extcause>="Y850" & ICD10extcause<="Y869"))

**Cut/pierce
gen cut=0
replace cut=1 if ///
(ICD10extcause>="W25" & ICD10extcause<="W2999") | ///
(ICD10extcause>="W45" & ICD10extcause<="W4699")

**Burns - all
gen burns=0
replace burns=1 if ICD10extcause>="X00" & ICD10extcause<="X19999"

**Burns - Exposure to smoke fire/flames
gen burnsfire=0
replace burnsfire=1 if ICD10extcause>="X00" & ICD10extcause<="X0999"

**Burns - Hot Objects/substances
gen burnshotsub=0
replace burnshotsub=1 if ICD10extcause>="X10" & ICD10extcause<="X1999"

**Near Drowning/Submersion
gen drowning=0
replace drowning=1 if (ICD10extcause>="W65" & ICD10extcause<="W7499") | ///
(ICD10extcause>="V90" & ICD10extcause<="V9099") | ///
(ICD10extcause>="V92" & ICD10extcause<="V9299")

**Near Drowning/submersion - Bathtub**
gen bathtub=0
replace bathtub=1 if ICD10extcause>="W65" & ICD10extcause<="W6699"

**Near Drowning/submersion - Swimming pool**
gen swimmingpool=0
replace swimmingpool=1 if ICD10extcause>="W67" & ICD10extcause<="W6899"

**Near Drowning/submersion - Natural water**
gen naturalwater=0
replace naturalwater=1 if ICD10extcause>="W69" & ICD10extcause<="W7099"

**Near Drowning/submersion - Involving watercraft**
gen watercraft=0.
replace watercraft=1 if (ICD10extcause>="V90" & ICD10extcause<="V9099") | ///
(ICD10extcause>="V92" & ICD10extcause<="V9299")

**Falls**.
gen fall=0.
replace fall=1 if ICD10extcause>="W00" & ICD10extcause<="W1999"

**Unintentional Poisoning**.
gen poisoning=0.
replace poisoning=1 if ICD10extcause>="X40" & ICD10extcause<="X4999"

**Suffocation**.
gen suffocation=0.
replace suffocation=1 if ICD10extcause>="W75" & ICD10extcause<="W8499"

**Overexertion**
gen overexertion=0.
replace overexertion=1 if ICD10extcause=="X50"

**Natural Environment**
gen naturalenviron=0.
replace naturalenviron=1 if ICD10extcause=="W42" | ICD10extcause=="W43" | ///
ICD10extcause>="W53" & ICD10extcause<="W64" | ///
ICD10extcause>="W92" & ICD10extcause<="W99" | ///
ICD10extcause>="X20" & ICD10extcause<="X3999" | ///
ICD10extcause>="X51" & ICD10extcause<="X57"

**Struck by or Against**
gen struck=0.
replace struck=1 if (ICD10extcause>="W20" & ICD10extcause<="W2299") | ///
(ICD10extcause>="W50" & ICD10extcause<="W5299")

**Motor Vehicle Traffic Collisions**.
gen collision=0.
replace collision=1 if ///
(ICD10extcause>="V02" & ICD10extcause<="V0499") | ///
(ICD10extcause=="V090")| ///
(ICD10extcause=="V092") | ///
(ICD10extcause>="V12" & ICD10extcause<="V1499") | ///
(ICD10extcause>="V190" & ICD10extcause<="V1929") | ///
(ICD10extcause>="V194" & ICD10extcause<="V1949") | ///
(ICD10extcause>="V196" & ICD10extcause<="V1969") | ///
(ICD10extcause>="V20" & ICD10extcause<="V7999") | ///
(ICD10extcause>="V803" & ICD10extcause<="V8059") | ///
(ICD10extcause=="V809") | ///
(ICD10extcause>="V810" & ICD10extcause<="V8119") | ///
(ICD10extcause>="V820" & ICD10extcause<="V8219") | ///
(ICD10extcause=="V828" )| ///
(ICD10extcause>="V83" & ICD10extcause<="V8699") | ///
(ICD10extcause>="V870" & ICD10extcause<="V8789") | ///
(ICD10extcause>="V880" & ICD10extcause<="V8889") | ///
(ICD10extcause=="V890") | ///
(ICD10extcause=="V892")

**Pedestrian - all**.
gen pedestrian=0.
replace pedestrian=1 if ///
(ICD10extcause>="V01" & ICD10extcause<="V06999") | (ICD10extcause>="V09" & ICD10extcause<="V09999")

**Pedestrian - motor-vehicle nontraffic **.
gen pedestriannontraffic=0.
replace pedestriannontraffic=1 if ///
(ICD10extcause=="V020") | (ICD10extcause=="V030") | ///
(ICD10extcause=="V040") | (ICD10extcause=="V090")

**Pedestrian - other**.
gen pedestrianother=0.
replace pedestrianother=1 if ///
(ICD10extcause>="V010" & ICD10extcause<="V019") | ///
(ICD10extcause>="V050" & ICD10extcause<="V059") | ///
(ICD10extcause>="V060" & ICD10extcause<="V069") | ///
(ICD10extcause=="V091") | (ICD10extcause=="V093") | (ICD10extcause=="V099")

**Pedal Cycle***.
gen pedal=0
replace pedal=1 if ICD10extcause>="V10" & ICD10extcause<="V199999"

**Pedal Cycle - motor-vehicle traffic only***.
gen pedaltraffic=0.
replace pedaltraffic=1 if ///
(ICD10extcause>="V123" & ICD10extcause<="V1299") | ///
(ICD10extcause>="V133" & ICD10extcause<="V1399") | ///
(ICD10extcause>="V143" & ICD10extcause<="V1499") | ///
(ICD10extcause>="V194" & ICD10extcause<="V1969")

**Pedal Cycle - motor-vehicle non-traffic only***.
gen pedalnontraffic=0.
replace pedalnontraffic=1 if ///
(ICD10extcause>="V120" & ICD10extcause<="V1229") | ///
(ICD10extcause>="V130" & ICD10extcause<="V1329") | ///
(ICD10extcause>="V140" & ICD10extcause<="V1429") | ///
(ICD10extcause>="V190" & ICD10extcause<="V1929")

**Pedal-other**.
gen pedalother=0.
replace pedalother=1 if ///
(ICD10extcause>="V100" & ICD10extcause<="V1099") | ///
(ICD10extcause>="V110" & ICD10extcause<="V1199") | ///
(ICD10extcause>="V150" & ICD10extcause<="V1899") | ///
(ICD10extcause=="V193") | (ICD10extcause=="V198") | (ICD10extcause=="V199")

**Public Transportation**
gen publictrans=0.
replace publictrans=1 if ///
(ICD10extcause>="V050" & ICD10extcause<="V0599") | ///
(ICD10extcause>="V150" & ICD10extcause<="V1599") | ///
(ICD10extcause>="V250" & ICD10extcause<="V2599") | ///
(ICD10extcause>="V350" & ICD10extcause<="V3599") | ///
(ICD10extcause>="V450" & ICD10extcause<="V4599") | ///
(ICD10extcause>="V550" & ICD10extcause<="V5599") | ///
(ICD10extcause>="V650" & ICD10extcause<="V6599") | ///
(ICD10extcause>="V700" & ICD10extcause<="V7999") | ///
(ICD10extcause>="V810" & ICD10extcause<="V8199") | ///
(ICD10extcause>="V820" & ICD10extcause<="V8299")

**Bus Occupant**
gen busoccupant=0.
replace busoccupant=1 if (ICD10extcause>="V700" & ICD10extcause<="V79999")

**All railway train or railway vehicle transport collisions**
**please note, not all the people involved in a railway collisions are railway occupants, could be a
*bus occupant hit by a train
gen railway=0.
replace railway=1 if ///
(ICD10extcause>="V050" & ICD10extcause<="V0599") | ///
(ICD10extcause>="V150" & ICD10extcause<="V1599") | ///
(ICD10extcause>="V250" & ICD10extcause<="V2599") | ///
(ICD10extcause>="V350" & ICD10extcause<="V3599") | ///
(ICD10extcause>="V450" & ICD10extcause<="V4599") | ///
(ICD10extcause>="V550" & ICD10extcause<="V5599") | ///
(ICD10extcause>="V650" & ICD10extcause<="V6599") | ///
(ICD10extcause>="V750" & ICD10extcause<="V7599") | ///
(ICD10extcause>="V810" & ICD10extcause<="V8199")

**Street car Occupant**
gen streetcar=0.
replace streetcar=1 if (ICD10extcause=="V82")

**Off-road incidents - all**
gen offroad=0.
replace offroad=1 if (ICD10extcause>="V860" & ICD10extcause<="V8699")

*******************************************************************************************
*********************Table 2 in "Recommended ICD-10-CA Codes for Injury Indicators" *******
*******************************************************************************************

**All Intentional Injuries
gen intent=0
replace intent=1 if ((ICD10extcause>="X60" & ICD10extcause<="X9999") | ///
(ICD10extcause=="Y870") | (ICD10extcause=="Y871") | ///
(ICD10extcause>="Y00" & ICD10extcause<="Y099"))

**Self-harm injuries
gen selfharm=0
replace selfharm=1 if (ICD10extcause>="X60" & ICD10extcause<="X8499") | ///
(ICD10extcause=="Y870")

**Assault
gen assault=0
replace assault=1 if (ICD10extcause>="X85" & ICD10extcause<="Y0999") | ///
(ICD10extcause=="Y871")

*******************************************************************************************
*********************Table 3 in "Recommended ICD-10-CA Codes for Injury Indicators" *******
*******************************************************************************************

**Note: The mortality database as of calender year 2000, uses ICD10 codes (not ICD10-CA codes)

**Falls**.
gen fall=0.
replace fall=1 if ICD10extcause>="W00" & ICD10extcause<="W1999"

**Land transport**.
gen landtransport=0.
replace landtransport=1 if ICD10extcause>="V01" & ICD10extcause<="V8999"

**Unintentional Poisoning**.
gen poisoning=0.
replace poisoning=1 if ICD10extcause>="X40" & ICD10extcause<="X4999"

**Suffocation and foreign body**.
gen suffocationfb=0.
replace suffocationfb=1 if ICD10extcause=="W44" | ICD10extcause=="W45" | ///
(ICD10extcause>="W75" & ICD10extcause<="W8499")

**Unintentional firearm discharge
gen unintentfirearm=0.
replace unintentfirearm=1 if ICD10extcause=="W32" | ICD10extcause=="W33" | ///
(ICD10extcause>="W34" & ICD10extcause<="W3499")

**Self-harm injuries
gen selfharm=0
replace selfharm=1 if (ICD10extcause>="X60" & ICD10extcause<="X8499") | ///
(ICD10extcause=="Y870")

**Assault
gen assault=0
replace assault=1 if (ICD10extcause>="X85" & ICD10extcause<="Y0999") | ///
(ICD10extcause=="Y871")

**Other unintentional injuries
gen otherunintent=0
replace otherunintent=1 if (ICD10extcause>="V910" & ICD10extcause<="V919") | ///
(ICD10extcause>="V930" & ICD10extcause<="V999") |(ICD10extcause>="W20" & ICD10extcause<="W43") | ///
(ICD10extcause>="W46" & ICD10extcause<="W64") |(ICD10extcause>="W85" & ICD10extcause<="W99") | ///
(ICD10extcause>="X00" & ICD10extcause<="X39") |(ICD10extcause>="X50" & ICD10extcause<="X599") | ///
(ICD10extcause>="Y85" & ICD10extcause<="Y869")

*******************************************************************************************
*********************Table 4 in "Recommended ICD-10-CA Codes for Injury Indicators" *******
*******************************************************************************************

**Note: The ambulatory database as of calender year 2003 (or fiscal year 2002-2003), uses ICD-10-CA codes

**Falls**.
gen fall=0.
replace fall=1 if ICD10extcause>="W00" & ICD10extcause<="W1999"

**Other land transport collisions**.
gen otherland=0.
replace otherland=1 if ///
(ICD10extcause>="V00" & ICD10extcause<="V899") & collision!=1

**Unintentional Poisoning**.
gen poisoning=0.
replace poisoning=1 if ICD10extcause>="X40" & ICD10extcause<="X4999"

**Suffocation**.
gen suffocation=0.
replace suffocation=1 if ICD10extcause>="W75" & ICD10extcause<="W8499"

**Burns - all
gen burns=0
replace burns=1 if ICD10extcause>="X00" & ICD10extcause<="X19999"

**Overexertion
gen overexertion=0
replace overexertion=1 if ICD10extcause=="X50"

**Cut/pierce
gen cut=0
replace cut=1 if ///
(ICD10extcause>="W25" & ICD10extcause<="W2999") | ///
(ICD10extcause>="W45" & ICD10extcause<="W4699")

**Struck by or Against**
gen struck=0.
replace struck=1 if (ICD10extcause>="W20" & ICD10extcause<="W2299") | ///
(ICD10extcause>="W50" & ICD10extcause<="W5299")

**Caught or crushed between objects**
gen crushed=0
replace crushed=1 if ICD10extcause=="W23"

**Bitten by dog or other mammal**
gen bittendog=0
replace bittendog=1 if ICD10extcause=="W54" | ICD10extcause=="W55"

**Foreign body in eye or orifice
gen foreignbody=0
replace foreignbody=1 if ICD10extcause=="W44"

**Nonvenomous insect bites
gen bitteninsect=0
replace bitteninsect=1 if ICD10extcause=="W57"

**Self-harm injuries
gen selfharm=0
replace selfharm=1 if (ICD10extcause>="X60" & ICD10extcause<="X8499") | ///
(ICD10extcause=="Y870")

**Assault
gen assault=0
replace assault=1 if (ICD10extcause>="X85" & ICD10extcause<="Y0999") | ///
(ICD10extcause=="Y871")

**Other unintentional injuries
gen otherunintent=0
replace otherunintent=1 if (ICD10extcause>="V910" & ICD10extcause<="V919") | ///
(ICD10extcause>="V930" & ICD10extcause<="V999")|(ICD10extcause=="W24") | ///
(ICD10extcause>="W30" & ICD10extcause<="W43") | (ICD10extcause>="W47" & ICD10extcause<="W499") | ///
(ICD10extcause=="W53") | (ICD10extcause=="W56") | (ICD10extcause>="W58" & ICD10extcause<="W64") | ///
(ICD10extcause>="W85" & ICD10extcause<="W999") | (ICD10extcause>="X20" & ICD10extcause<="X399") | ///
(ICD10extcause>="X51" & ICD10extcause<="X599") | (ICD10extcause>="Y85" & ICD10extcause<="Y869")

*******************************************************************************************
*********************Table 5 in "Recommended ICD-10-CA Codes for Injury Indicators" *******
*******************************************************************************************

**All Sports and recreational injuries**.
gen sportandrec=0.
replace sportandrec=1 if (ICD10extcause>="V10" & ICD10extcause<="V19999") | ///
(ICD10extcause>="W0200" & ICD10extcause<="W0208") | ///
(ICD10extcause>="W2100" & ICD10extcause<="W2109") | ///
(ICD10extcause>="W2200" & ICD10extcause<="W2207") | ///
(ICD10extcause>="W5100" & ICD10extcause<="W5107") | ///
(ICD10extcause>="W09" & ICD10extcause<="W09999") | ///
(ICD10extcause>="W16" & ICD10extcause<="W16999") | ///
(ICD10extcause>="V86" & ICD10extcause<="V86999") | ///
(ICD10extcause>="W67" & ICD10extcause<="W74999") | ///
(ICD10extcause>="V902" & ICD10extcause<="V90899") | ///
(ICD10extcause>="V912" & ICD10extcause<="V91899") | ///
(ICD10extcause>="V922" & ICD10extcause<="V92899") | ///
(ICD10extcause>="V932" & ICD10extcause<="V93899") | ///
(ICD10extcause>="V942" & ICD10extcause<="V94899")
#delimit cr

**Sports and recreational injuries - Baseball**.
gen baseball=0.
replace baseball=1 if ICD10extcause=="W2205" | ICD10extcause=="W5105"

**Sports and recreational injuries - Hit by Ball**.
gen hitbyball=0.
replace hitbyball=1 if ICD10extcause=="W2100"

**Sports and recreational injuries - Hit by bat**.
gen hitbybat=0.
replace hitbybat=1 if ICD10extcause=="W2101"

*Sports and recreational injuries - Cycling**.
gen cycling=0.
replace cycling= 1 if ICD10extcause>="V10" & ICD10extcause<="V19999"

**Sports and recreational injuries - Fall involving rollerblade/scooter/skateboard**.
gen rollscootskboard=0.
replace rollscootskboard=1 if ICD10extcause=="W0202" | ///
ICD10extcause=="W0203" | ICD10extcause=="W0208"

**Sports and recreational injuries - Football/rugby**.
gen footballrugby=0.
replace footballrugby=1 if ICD10extcause=="W2203" | ICD10extcause=="W5103"

**Sports and Recreational Injuries - Hockey**.
gen hockey=0.
replace hockey=1 if ICD10extcause=="W2102" | ///
ICD10extcause=="W2103" | ICD10extcause=="W2202" | ICD10extcause=="W5102"

**Sports and recreational injuries - Ice skates**.
gen iceskates=0.
replace iceskates=1 if ICD10extcause=="W0200"

**Sports and recreational injuries - Playground equipment**.
gen playground=0.
replace playground=1 if ICD10extcause>="W09" & ICD10extcause<="W09999"

**Sports and recreational injuries - Pool and natural water swimming/diving/drowning**.
gen poolnaturalwater=0.
replace poolnaturalwater=1 if (ICD10extcause>="W67" & ICD10extcause<="W74999") | ICD10extcause=="W16"

**Sports and recreational injuries - Ski/snowboard**.
gen skisnowboard=0.
replace skisnowboard=1 if ICD10extcause=="W0201" | ///
ICD10extcause=="W0204" | ICD10extcause=="W5100" | ICD10extcause=="W2200"

**Sports and recreational injuries - Soccer**.
gen soccer=0.
replace soccer=1 if ICD10extcause=="W2204" | ICD10extcause=="W5104"

**Sports and recreational injuries - Toboganning**.
gen toboganning=0.
replace toboganning=1 if ICD10extcause=="W5101" | ICD10extcause=="W2201"

**Sports and recreational injuries - Recreational Boating**.
gen recboating=0.
replace recboating=1 if (ICD10extcause>="V902" & ICD10extcause<="V90899") | ///
(ICD10extcause>="V912" & ICD10extcause<="V91899") | ///
(ICD10extcause>="V922" & ICD10extcause<="V92899") | ///
(ICD10extcause>="V932" & ICD10extcause<="V93899") | ///
(ICD10extcause>="V942" & ICD10extcause<="V94899")

**Sports and recreational injuries - ATV/snowmobile**.
gen ATVsnowmobile=0.
replace ATVsnowmobile=1 if ICD10extcause>="V86" & ICD10extcause<="V86999"

*ATV only
gen ATV=0.
replace ATV=1 if ICD10extcause=="V8608"
replace ATV=1 if ICD10extcause=="V8618"
replace ATV=1 if ICD10extcause=="V862"
replace ATV=1 if ICD10extcause=="V864"
replace ATV=1 if ICD10extcause=="V865"
replace ATV=1 if ICD10extcause=="V866"
replace ATV=1 if ICD10extcause=="V867"
replace ATV=1 if ICD10extcause=="V869"
replace ATV=1 if ICD10extcause=="V8638"
replace ATV=1 if ICD10extcause=="V8658"
replace ATV=1 if ICD10extcause=="V8668"
replace ATV=1 if ICD10extcause=="V8698"

*Snowmobile only
gen snow=0.
replace snow=1 if ICD10extcause=="V8600"
replace snow=1 if ICD10extcause=="V8610"
replace snow=1 if ICD10extcause=="V8630"
replace snow=1 if ICD10extcause=="V8650"
replace snow=1 if ICD10extcause=="V8651"
replace snow=1 if ICD10extcause=="V8660"
replace snow=1 if ICD10extcause=="V8661"
replace snow=1 if ICD10extcause=="V8690"
replace snow=1 if ICD10extcause=="V8691"

Treasurer/Secretary | Admin | Members Login

BrickHost