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!!!!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.