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.
SAS Innovate 2025: Save the Date
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!