About carlosgg

carlosgg · ‎10-30-2023

👍Thank you @ballardw . The solution by @PGStats looks good. I used @lsilochan 's solution and it worked for me.

carlosgg · ‎10-30-2023

Hello @LinusH, Our application was to put in a single row all the courses a student is taking or took in an academic term. student_id academic_term course 123 Fall 2022 MAT101 123 Fall 2022 ENG101 123 Fall 2022 CMP101 123 Spring 2023 MAT102 123 Spring 2023 ENG102 123 Spring 2023 POS2041 student_id academic_term courses course_count 123 Fall 2022 MAT101; ENG101; CMP101 3 123 Spring 2023 ENG102; POS2041 2

carlosgg · ‎10-26-2023

This worked for me, too. Thank you for sharing it! 👍👍👍

Online Status	Offline
Date Last Visited	‎11-01-2023 01:24 PM

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: Char to numeric with decimal points

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?