DATA Step, Macro, Functions and more

solved

Reply
Regular Learner
Posts: 1

solved

[ Edited ]
 
Super User
Super User
Posts: 9,195

Re: How to concatenate multiple rows into 1 by some ID

Follow the new post guidance, post test data in the form of a datastep, you can follow this post if you don't know how:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

 

Then show what you want out at the end from that test data.  At a guess you can retain a variable across and concatenate each row onto it.  However bear in mind that a single variable has a limit to what it can hold, if you ut lots of text into one variable its likely to not fit - which is why it is on multiple lines in the first place.  I would question why you want to do this in the first place?

Ask a Question
Discussion stats
  • 1 reply
  • 76 views
  • 0 likes
  • 2 in conversation