Which stage of the process are you in at the moment?
Have you already imported your data into SAS?
Have you tried PROC TRANSPOSE and it's not working?
Most users will not download Excel files (I previewed), so it's best to post data as text directly into the post.
For your transpose, SAS does not allow variables to have the same column names so you won't be able to get exactly that. You can add a number to the groups before PROC TRANSPOSE to get A1, A2, A3 afterwards.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.