Concatenate into single row!!!

[sam369]

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

[art297 · Accepted solution]

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;

[sam369]

Thank you so much Art!!!!