Hello all, How can I add a column into dataset based on 1 column value. How can I divide each rank into 2 splits or 3 splits. If I used Proc rank. it just splits the dataset into 2/3 equal portion. Is there a way to split the each unique ranks into 2/3 split. In the example below I have splited into 2 splits. Have: Test1 Test2 Rank Apple dd 1 Ball dd 1 Cat dd 1 Dog dd 1 Elephant dd 2 dsd dd 2 sdf dd 2 asdf e 3 asdf e 3 asdf e 3 adsf e 3 want: Test1 Test2 Rank Desired Apple dd 1 1 Ball dd 1 1 Cat dd 1 2 Dog dd 1 2 Elephant dd 2 1 dsd dd 2 2 sdf dd 2 2 asdf e 3 1 asdf e 3 1 asdf e 3 2 adsf e 3 2 proc rank data = have out = want group =2;
var = rank;
ranks =desired;
quit; This code gave me : Test1 Test2 Rank Desired Apple dd 1 0 Ball dd 1 0 Cat dd 1 0 Dog dd 1 0 Elephant dd 2 1 dsd dd 2 1 sdf dd 2 1 asdf e 3 1 asdf e 3 2 asdf e 3 2 adsf e 3 2 Thank you in advance.
... View more