We don't have your sample data so won't be able to answer these questions.
If you're after some feed-back then may-be best provide your answers and explain how you got there/how you've approached the questions and what code you've used (post the code using the running man icon).
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.