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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: