topic Re: How to concatenate all the values in a column? in SAS Programming

How to concatenate all the values in a column?

vjpkr — Tue, 03 Sep 2013 01:47:25 GMT

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" .

Re: How to concatenate all the values in a column?

PGStats — Tue, 03 Sep 2013 01:59:15 GMT

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;

Re: How to concatenate all the values in a column?

mgrd — Fri, 22 Jan 2016 17:10:27 GMT

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!!