Hi there, I don't know the maximum number of codes that will ever be encountered, so that possibility is dynamic. Is there a way to declare a large size for the variable combo to try and reduce the possibility of the variable combo of exceeding the variable size? The resulting data that I'm trying to get at with the "Combo" variable won't be utilized in SAS for any further analysis operations, so I'm not worried about creating a variable I can't utilize in SAS after I create it. The combo variable is part of an Excel report for my customers and they want all of the codes in one column when the person/provider/date is the same. I used your provide steps and was able to get the final output I was after, thank you!
... View more