topic Re: Concatenate into single row!!! in SAS Procedures

Concatenate into single row!!!

sam369 — Thu, 15 Nov 2012 18:45:15 GMT

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 — Thu, 15 Nov 2012 18:56:00 GMT

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 — Thu, 15 Nov 2012 18:57:57 GMT

Thank you so much Art!!!!