topic (Urgent!) How to transpose cells like this in New SAS User

(Urgent!) How to transpose cells like this

Jonathanzz — Sun, 25 Nov 2018 12:10:44 GMT

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 — Sun, 25 Nov 2018 12:12:36 GMT

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

PaigeMiller — Sun, 25 Nov 2018 12:25:15 GMT

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.

Jonathanzz — Sun, 25 Nov 2018 12:29:31 GMT

Thanks a lot! You are my hero!