I have a dataset that includes multiple diagnosis codes in one ";" delimited variable sorted by patient and year. For example. Patient Year Codes 1 18 0123;4444;2346;0912 2. 17 1234;4444 3 17 0912 4 16 0123;2346;0912 5 15 4444 I would like to know the frequency of the individual codes grouped by year without having to manually enter all of the codes. Example output 2015 2016 2017 2018 Total 0123 n n n n n 4444 2346 0912 I have tried with proc freq but it will not look within the strings. Proc tabulate will work but only if I manually enter each code. Any help with a more efficient way of doing this? Any help would be appreciated. Simon
... View more