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).
Catch up on SAS Innovate 2026
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.