If I understand your request correctly, you you want to do this:
Anytime status is active you dont do anything.
Anytime status is deactivated you want to alphabetically increase name, so that Aa becomes Bb and so on.
Am I correct?
Is there a rule for how the "active" person for a given inactive person is determined? Next in order, least used, ...?
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.