How to concatenate all the values in a column?

[vjpkr]

eg : I have  5 names under the column "User" in a dataset, how do I get the result as  AB;BC;CD;DE;EF where AB,BC,CD,DE,EF are the values under the column "User" .

[PGStats · Accepted solution]

Like this:

data have;
input user :$2.;
datalines;
AB
BC
CD
DE
EF
;

data want(keep=userList);
length userList $24;
do until(eof);
     set have end=eof;
     userList = catx(";", userList, user);
     end;
run;

proc print data=want noobs; run;

PG

[mgrd]

I'd like to know, how it's possible to concatenate one column and mantain the information in each row. For example:

A B

a 1

a 2

a 3

b 4

b 5

b 6

c 7

d 8

e 9

e 10

f 11

Create 3 columns like this:

A    B     Concatenate

a    1     1,2,3

a    2     1,2,3

a    3     1,2,3

b    4     4,5,6

b    5     4,5,6

b    6     4,5,6

Thanks in advance for your help!!