topic Re: proc transpose in New SAS User

proc transpose

peiy5920 — Thu, 28 May 2020 20:00:10 GMT

Hi all,

My data like this

ID Race

1 White

2 Black

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 — Thu, 28 May 2020 20:07:26 GMT

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

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

peiy5920 — Thu, 28 May 2020 20:20:21 GMT

Thanks your reply. I solved the problem.