BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
thesasuser
Lapis Lazuli | Level 10

I have a data set having a single column of names and 100 rows .

Is there way to combine names from every 10 rows into a string?

For example my data may be like this

aaaa

bbbb

abbc

ddda

....

...

What I want ot get is a new table with

aaaa bbbb abbbc

ddda efgh ijkl lmnop

.....

Is there a way to do it?

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

It's probably a bad idea that will only make your life harder down the road.  But it's not difficult:

 

data want;

length string $ 200;

do _n_=1 to 10 until (done);

   set have end=done;

   string = catx(' ', string, name);

end;

drop name;

run;

 

View solution in original post

3 REPLIES 3
SuryaKiran
Meteorite | Level 14

First group the data by 10 records each and then use proc transpose by the grouped variable.

 

DATA have(drop=i);
do i=1 to 200;
val=put(i,3.);
output;
end;
run;
data want;
retain group;
set have;
IF _N_=1 then group=1;
else if MOD(_N_-1,10)=0 then group+1;
run;

proc transpose data=want out=want1;
by group;
var val;
run;
Thanks,
Suryakiran
Astounding
PROC Star

It's probably a bad idea that will only make your life harder down the road.  But it's not difficult:

 

data want;

length string $ 200;

do _n_=1 to 10 until (done);

   set have end=done;

   string = catx(' ', string, name);

end;

drop name;

run;

 

thesasuser
Lapis Lazuli | Level 10
Thanks
Both solutions are wonderful and good.
Accepted this as simpler code

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1722 views
  • 1 like
  • 3 in conversation