07-02-2016 08:05 PM
Please see the following data set:
Bob Paul 120 Tina Adele 111 Scott Joe 100 Betty Trish 97 Mark Adam 95
Three columns: Name#1, Name#2, Score.
I would like to join the columns to produce the following:
Bob 120 Paul 120 Tina 111 Adele 111 Scott 100 Joe 100 Betty 97 Trish 97 Mark 95 Adam 95
Two columns: Name#1 OR Name#2, Score
How can this be done efficiently?
Any help greatly appreciated.
07-02-2016 10:31 PM
set have (rename=name1=name keep=(name score))
Have (rename=name2=name keep=(name score));
You may need to play with the keep statement. I never remember if you reference a renamed variable with the original or new name in the keep section.
Need further help from the community? Please ask a new question.