proc transpose

[peiy5920]

Hi all,

My data like this

ID Race

1   White

1   White

1   White

2   Black

2   Black

2   Black

3   White

3   White

3   White

I hope my new data is below

ID  Race

1   White

2   Black

3   White

I know I should use the code proc transpose, but I am not sure how to use it? Thank you.

[Jagadishkatam · Accepted solution]

no need of proc transpose , you want to use proc sort

proc sort data=have out=want nodupkey;
by id race;
run;

[peiy5920]

Thanks your reply. I solved the problem.