Please provide a representative portion of the data, as SAS data steps, following these instructions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712
Please show us the desired end result.
... View more