I have the following dataset:
| ID | X1 | X2 | Xn | Y1 | Y2 | Yn |
| IC 01 | 2 | 4 | 5 | 5 | 9 | 8 |
| IC 02 | 1 | 5 | 8 | 3 | 4 | 7 |
And i would like to have the following:
| ID | X1 | Y1 | X2 | Y2 | Xn | Yn |
| IC 01 | 2 | 5 | 4 | 9 | 5 | 8 |
| IC 02 | 1 | 3 | 5 | 4 | 8 | 7 |
I used the transpose function in SAS EG but I could not find the right way to order my columns alphabetically
-> X1 – Y1 – X2 – Y2 – X3 – Y3 – … – Xn – Yn
Andy De Vos is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.