To get an answer to your question please post:
Example test data, in the form of a datastep - copied and pasted into the text box here so we can run it to get test data. You can extract this form your data by following the post at:
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712
The post an example - directly into the text box here - of what the output should look like. Most people will not download random Excel files from the web.
Finally provide any additional information on what the process is about.
... View more