@mtr91 wrote:
It works! This is an intimidating chunk of code.. clearly I have much more to learn about SAS, but this is a great example to help me complete the task and similar future projects. Thanks for your help, I would not have been able to figure this out on my own 🙂
It is still going to be much easier to deal with this data if you transpose it to have a single DRUG variable and multiple observations when there are multiple drugs. Then your problem here becomes one of only keeping the CLASS names in the DRUG column when they are the only DRUG listed for that class.
data want;
set have ;
by id class drug;
if class = drug and not (first.class and last.class) then delete;
run;
... View more