All, I'm currently working with some data that runs through various different codes, each of which may append a new value to some flag field. At the end of it all, we want to set a hierarchy of the flags already applied. At the moment I'm doing so by using a bunch of if find(flag, '*') gt 0 then ... statements, but I'm wondering if there's an easier way. My thought is if I can sort Flag in order of my hierarchy then I can basically just grab the left-most character and use that. I found this post to get me started on how I could sort the Flag field alphabetically, but I'm wondering if there's some way to expand that beyond just alphabetical? Data and hierarchy logic I have Flag Hierarchy QVRS R BEWC C RT R QTS T if find(flag, 'R') gt 0 then Hierarchy = 'R';
else if find(flag, 'C') gt 0 then Hierarchy = 'C';
else if find(flag, 'W') gt 0 then Hierarchy = 'W';
else if find(flag, 'T') gt 0 then Hierarchy = 'T';
else ... Data and hierarchy logic I want Flag Hierarchy RQVS R CEBW C RT R TQS T Hierarchy = substr(flag, 1, 1); Also, in case it matters, I'm using SAS 9.4.
... View more