Can anyone help me identify the problem in code below? I think it might be the first set of if statements creating _ct (count) variables. Those values are very off though in general the code runs and even the final indicators will likely be correct once I can get appropriate values for the _ct variables.    Thank you for your suggestions.      ... View more

Hi all, I'm trying to complete a mapping of ICD10 codes to conditions by filling in missing values for variable "condition". I've created a variable icd10_grp that will identify groups of codes (by their first three digits). Within these groups I want to fill in the missing condition value with one of the present values (for condition) in the same group but ONLY when all the values in the group are the same. I've tried to use the update statement and that works when the missing value is not the first one (but doesn't discern if all values in group are the same). I've also tried coalesce function and it runs without error but the new column is still blank (and it doesn't discern if all values in group are the same either). How can I adjust the programming to identify all same values of condition within a group and then use that value to replace the missing one? Thank you.     icd10 mapping to conditions   Product: Base SAS via Enterprise Guide 8.2 Release: 9.04.01 M6P110718 OS: Linux ... View more