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.
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.
Ready to level-up your skills? Choose your own adventure.