topic Re: How to concatenate multiple rows into 1 by some ID in SAS Programming https://communities.sas.com/t5/SAS-Programming/solved/m-p/459562#M116738 <P>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:</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A></P> <P>&nbsp;</P> <P>Then show what you want out at the end from that test data.&nbsp; At a guess you can retain a variable across and concatenate each row onto it.&nbsp; 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.&nbsp; I would question why you want to do this in the first place?</P> Thu, 03 May 2018 08:16:16 GMT RW9 2018-05-03T08:16:16Z solved https://communities.sas.com/t5/SAS-Programming/solved/m-p/459557#M116737 Fri, 04 May 2018 08:27:28 GMT https://communities.sas.com/t5/SAS-Programming/solved/m-p/459557#M116737 Yiting 2018-05-04T08:27:28Z Re: How to concatenate multiple rows into 1 by some ID https://communities.sas.com/t5/SAS-Programming/solved/m-p/459562#M116738 <P>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:</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A></P> <P>&nbsp;</P> <P>Then show what you want out at the end from that test data.&nbsp; At a guess you can retain a variable across and concatenate each row onto it.&nbsp; 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.&nbsp; I would question why you want to do this in the first place?</P> Thu, 03 May 2018 08:16:16 GMT https://communities.sas.com/t5/SAS-Programming/solved/m-p/459562#M116738 RW9 2018-05-03T08:16:16Z