How to deal with values that include numbers and letters

Hello! I have a dataset that includes ICD10 codes, which include both numbers and letters (as seen in my dataex example below). I have 10 columns of diagnoses (included below) labeled dx1, dx1_1, dx1_2,, dx1_3, dx2, dx2_1, dx2_2, dx3, dx3_1 and dx3_2. I would like to create a binary variable that indicates if ANY of these 10 diagnoses includes this group of diagnoses: E10.*, E11.*, E08.*, E09.*, E13.* I am having trouble doing this since the letters/numbers being a string. Can anyone help?

Thank you!

Sarah

----------------------- copy starting from the next line -----------------------

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str8(dx1 dx1_1) str6 dx1_2 str5 dx1_3 str8(dx2 dx2_1) str6 dx2_2 str8 dx3 str6(dx3_1 dx3_2)
"E11.22"   "E11.65" "N18.3"  "Z79.4" ""         ""       ""       ""         ""      ""
"E11.29"   "E11.65" "R80.9"  "Z79.4" ""         ""       ""       ""         ""      ""
"E11.8"    ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.40"   "Z79.4"  "E11.65" ""      ""         ""       ""       ""         ""      ""
"E11.21"   "E11.65" ""       ""      "E11.65"   ""       ""       "I10"      ""      ""
"E11.21"   "E11.65" ""       ""      "E78.2"    ""       ""       "I10"      ""      ""
"E11.22"   "E11.65" "N18.4"  "Z79.4" "M81.8"    ""       ""       "E21.3"    ""      ""
"E11.40"   "Z79.4"  "E11.65" ""      "Z96.41"   ""       ""       ""         ""      ""
"E11.40"   "E11.65" ""       ""      ""         ""       ""       ""         ""      ""
"E11.21"   "E11.65" "Z79.4"  ""      ""         ""       ""       ""         ""      ""
"E11.40"   "Z79.4"  "E11.65" ""      "Z46.81"   ""       ""       ""         ""      ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.22"   "E11.65" "Z79.4"  ""      ""         ""       ""       ""         ""      ""
"E11.65"   ""       ""       ""      "E11.22"   "N18.2"  "Z79.4"  "I10"      ""      ""
"E11.42"   "Z79.4"  ""       ""      "I10"      ""       ""       "E66.01"   ""      ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   "Z79.4"  ""       ""      "E11.9"    "Z79.4"  ""       ""         ""      ""
"E11.3519" "E11.65" ""       ""      ""         ""       ""       ""         ""      ""
"E11.3512" "Z79.4"  ""       ""      ""         ""       ""       ""         ""      ""
"E10.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   "Z79.4"  ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   "Z79.4"  ""       ""      "I10"      ""       ""       "E78.5"    ""      ""
"E11.65"   "Z79.4"  ""       ""      "I10"      ""       ""       "E78.5"    ""      ""
"E11.40"   "Z79.4"  ""       ""      "I25.10"   ""       ""       "E29.1"    ""      ""
"E11.42"   "E11.65" ""       ""      "E11.65"   ""       ""       "E03.9"    ""      ""
"E11.42"   "Z79.4"  "E11.65" ""      "I10"      ""       ""       "E03.9"    ""      ""
"E11.65"   "Z79.4"  ""       ""      "E11.42"   "Z79.4"  "E11.65" "E03.9"    ""      ""
"E11.9"    "Z79.4"  ""       ""      ""         ""       ""       ""         ""      ""
"D35.2"    ""       ""       ""      "E11.29"   "R80.9"  ""       "I10"      ""      ""
"E11.29"   "R80.9"  "Z79.4"  ""      "I10"      ""       ""       "E11.3293" "Z79.4" ""
"E11.65"   ""       ""       ""      "E06.3"    ""       ""       "E78.2"    ""      ""
"E11.65"   "Z79.4"  ""       ""      ""         ""       ""       ""         ""      ""
"E11.40"   "E11.65" ""       ""      ""         ""       ""       ""         ""      ""
"E11.8"    "Z79.4"  ""       ""      "E11.65"   ""       ""       "E08.3291" ""      ""
"E11.9"    "Z79.4"  ""       ""      "E78.2"    ""       ""       "E53.8"    ""      ""
"E89.0"    ""       ""       ""      "E78.2"    ""       ""       "I10"      ""      ""
"M81.0"    ""       ""       ""      "L84"      ""       ""       "E11.40"   ""      ""
"E11.22"   "N18.6"  "Z79.4"  "Z99.2" ""         ""       ""       ""         ""      ""
"E11.65"   "Z79.4"  ""       ""      "E11.21"   ""       ""       "E11.319"  ""      ""
"E11.42"   "Z79.4"  ""       ""      "E11.69"   "E78.5"  ""       "N52.9"    ""      ""
"E11.8"    "Z79.4"  ""       ""      "E55.9"    ""       ""       "E11.65"   ""      ""
"D35.2"    ""       ""       ""      "E22.1"    ""       ""       "E11.22"   "N18.3" ""
"E78.2"    ""       ""       ""      "I10"      ""       ""       "K31.84"   ""      ""
"E11.51"   "E11.65" ""       ""      "K31.84"   ""       ""       "E66.01"   ""      ""
"E11.40"   "Z79.4"  "E11.65" ""      ""         ""       ""       ""         ""      ""
"E10.65"   ""       ""       ""      "E10.3511" ""       ""       "E10.42"   ""      ""
"C73"      ""       ""       ""      "E11.21"   "E11.65" ""       "E78.2"    ""      ""
"R73.9"    ""       ""       ""      "E11.65"   ""       ""       ""         ""      ""
"E11.42"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E10.42"   "E10.65" ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"K31.84"   ""       ""       ""      "E03.9"    ""       ""       "E10.49"   ""      ""
"E11.22"   "N18.3"  "Z79.4"  ""      "I10"      ""       ""       "E11.69"   "E78.5" ""
"E11.9"    ""       ""       ""      "E04.1"    ""       ""       ""         ""      ""
"E11.29"   "Z79.4"  "E11.65" ""      "E11.69"   "E78.5"  ""       "I10"      ""      ""
"E11.65"   ""       ""       ""      "E11.22"   "N18.2"  ""       "E11.42"   "Z79.4" ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.22"   "Z79.4"  ""       ""      "N18.3"    ""       ""       "I10"      ""      ""
"E11.42"   "E11.65" ""       ""      "E78.49"   ""       ""       "I10"      ""      ""
"E11.65"   "Z79.4"  ""       ""      ""         ""       ""       ""         ""      ""
"E11.3293" "Z79.4"  ""       ""      "E78.2"    ""       ""       "I10"      ""      ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   ""       ""       ""      "E03.9"    ""       ""       ""         ""      ""
"E04.2"    ""       ""       ""      "E11.9"    ""       ""       "M80.80XA" ""      ""
"E11.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.65"   ""       ""       ""      "E11.41"   ""       ""       "N18.2"    ""      ""
"E11.39"   "E11.65" ""       ""      "E78.2"    ""       ""       ""         ""      ""
"E11.29"   "E11.65" "R80.9"  "Z79.4" "E03.9"    ""       ""       "I10"      ""      ""
"E11.22"   "N18.3"  ""       ""      "E11.21"   "Z79.4"  ""       ""         ""      ""
"E04.2"    ""       ""       ""      "E83.52"   ""       ""       "E11.9"    ""      ""
"E11.42"   "Z79.4"  ""       ""      "E11.22"   "N18.3"  "Z79.4"  "I10"      ""      ""
"E03.8"    ""       ""       ""      "R07.9"    ""       ""       "I10"      ""      ""
"E11.22"   "N18.3"  "E11.65" ""      "E11.3519" "Z79.4"  ""       "I10"      ""      ""
"E11.65"   ""       ""       ""      "E29.1"    ""       ""       "D35.2"    ""      ""
"E10.65"   ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.9"    "Z79.4"  ""       ""      ""         ""       ""       ""         ""      ""
"E11.51"   "E11.65" ""       ""      "E11.65"   "Z79.4"  ""       "I10"      ""      ""
"E11.9"    ""       ""       ""      ""         ""       ""       ""         ""      ""
"E11.3291" "E11.65" "Z79.4"  ""      "E55.9"    ""       ""       "I10"      ""      ""
"E11.65"   "Z79.4"  ""       ""      "D35.2"    ""       ""       "E78.2"    ""      ""
"E11.8"    "E11.65" ""       ""      ""         ""       ""       ""         ""      ""
"E11.21"   "E11.65" "Z79.4"  ""      ""         ""       ""       ""         ""      ""
"E11.21"   "E11.65" ""       ""      "E78.2"    ""       ""       "E04.2"    ""      ""
"E11.21"   "E11.65" ""       ""      "E78.5"    ""       ""       ""         ""      ""
"E11.69"   "Z79.4"  ""       ""      "E11.42"   "Z79.4"  ""       "E78.2"    ""      ""
"M81.0"    ""       ""       ""      "E11.40"   ""       ""       "E03.9"    ""      ""
"E11.21"   "E11.65" ""       ""      "E78.00"   ""       ""       "I10"      ""      ""
"Z00.00"   ""       ""       ""      "I10"      ""       ""       "E11.21"   ""      ""
"Z00.00"   ""       ""       ""      "I10"      ""       ""       "E11.21"   ""      ""
"E11.40"   ""       ""       ""      "E78.2"    ""       ""       "E55.9"    ""      ""
"E11.40"   "Z79.4"  "E11.65" ""      ""         ""       ""       ""         ""      ""
"E10.22"   "E10.65" ""       ""      ""         ""       ""       ""         ""      ""
"E10.65"   ""       ""       ""      "E03.9"    ""       ""       "E13.9"    ""      ""
"E11.65"   ""       ""       ""      "E78.2"    ""       ""       "E11.21"   "Z79.4" ""
"C73"      ""       ""       ""      "E11.40"   ""       ""       ""         ""      ""
"E11.21"   "E11.65" ""       ""      "E03.9"    ""       ""       "E78.2"    ""      ""
"C73"      ""       ""       ""      "C73"      ""       ""       "E89.0"    ""      ""
"E10.29"   "E10.65" ""       ""      "E78.2"    ""       ""       "I10"      ""      ""
end

------------------ copy up to and including the previous line ------------------

Listed 100 out of 1446 observations
Use the count() option to list more

Share on FacebookPlus on Google+