Most of us will not download Microsoft Office documents as they can be a security threat. Better you should provide data as text in your message, following these instructions and examples. This should not be something we have to request repeatedly, you have been asked for data in the proper form before.
In the meantime, perhaps the PROC TRANSPOSE documentation and examples will be helpful.
You need to very clearly show what your current data set looks like.
Then show and describe the result.
I am afraid that a single sheet from a spreadsheet doesn't tell us much about what you have and which the result.
Plus we can't tell SAS variable types or variable names.
And anytime reshaping comes up, it often is helpful to answer are your sure you need a data set? Often reports are easier to create than data sets.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.