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.
Thanks!
Nicholas Kormanik
Another way:
data want;
set have;
do name = name1, name2;
output;
end;
drop name1 name2;
run;
Hi,
One way to do this:
data want(keep=Name score);
set have;
array n(*) name1 name2;
do i=1 to dim(n);
Name=n(i);
output;
end;
run;
Another way:
data want;
set have;
do name = name1, name2;
output;
end;
drop name1 name2;
run;
Data want;
set have (rename=name1=name keep=(name score))
Have (rename=name2=name keep=(name score));
run;
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.