your description of the problem talks about ID called "memberNo" but there is no such thing in your code. So I can't even begin to offer a reasonable alternative.
-- Paige Miller
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.