Hi All,
Data have;
input id mut $;
cards;
100 mut1
100 nomut
100 mut3
101 mut3
101 mut4
105 mut5
105 nomut
105 mut6
;
run;
i want like this
100 mut1/nomut/mut3
101 mut3/mut4
105 mut5/nomut/mut6
Thanks in Advance
Sam
Here is one way to do it, but this would leave it up to you to specify the length needed to capture the new field:
data want (drop=mut);
set have;
by id;
length newfield $100;
retain newfield;
if first.id then newfield=mut;
else newfield=catx('/',newfield,mut);
if last.id then output;
run;
Here is one way to do it, but this would leave it up to you to specify the length needed to capture the new field:
data want (drop=mut);
set have;
by id;
length newfield $100;
retain newfield;
if first.id then newfield=mut;
else newfield=catx('/',newfield,mut);
if last.id then output;
run;
Thank you so much Art!!!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.