You will need to post test data (as a datastep), with required output and a more thorough explanation of what needs to be "reduced". The information given is not sufficient to provide any help I am afraid.
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.