(Urgent!) How to transpose cells like this

[Jonathanzz]

How can I change the dataset

like this

x1 y1 5

x2 y1 2

x1 y2 4

x2 y2 3

into this

      y1 y2

x1  5   4

x2  2   3

It will be graceful if someone can help me out!

[Jonathanzz]

Actually, my data has over 1000 x and y variables. Can I do it with array?

[PaigeMiller · Accepted solution]

proc sort data=have;
    by x;
run;
proc transpose data=have out=want;
    by x;
    id y;
    var column3;
run;

Since you didn't provide variable names, I chose my own variable names. I hope you can figure out which name corresponds to which variable.

In the future, please provide variable names.

In the future, please provide (a portion of) your data as a SAS data step, as explained here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

[Jonathanzz]

Thanks a lot! You are my hero!