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" .
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
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
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!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.