About BrianC

BrianC · ‎03-14-2020

Thank you for the rapid responses! The reason for sql is that the database is stored on teradata (over 30 mil obs) and so far every attempt to run a data step has taken so long that I have had to stop it. Proc sql (and sql in teradata studio) runs much more efficiently/faster. I am new to working with such large files and so if you have insight on how to work more efficiently with a data step over a teradata server, I am all for it. I am open to any solution that gets this done, efficiently! Thank you all again!

BrianC · ‎03-14-2020

I know there is a way in Proc sql to combine multiple rows of a text field into one? I have tried a lot of the sql examples eg sum(), string_agg, xml for path. It all doesn’t seem to work. I can do this in base SAS but I need the code in sql. The data variables are id, date, orderno, line_order, result. ‘Result’ is the text field with multiple rows I need in one row and repeating id, orderno and date. The line_order variable gives the correct order of the rows in ascending. The lines can be as many as 30 rows of text. An id can occur multiple times but with a different orderno. Hope you can help me or point me in the right direction. Thanks!

Online Status	Offline
Date Last Visited	‎03-14-2020 08:35 PM

Re: Combining multiple rows of text into one in Proc sql

Combining multiple rows of text into one in Proc sql

Re: Combining multiple rows of text into one in Proc sql

Combining multiple rows of text into one in Proc sql