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.
Special offer for SAS Communities members
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.