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).
2025 SAS Hackathon: There is still time!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!