Hi. Can anyone help me on the following? I'm using SAS EG and trying to use Proc SQL to combine row values as follows: Project_Name Ref_No A 3 A 4 B 9 B 8 C 1 C 2 D 7 And I want to output a LIST table with the following Project_Name Ref Nos A 3/4 B 8/9 C 1/2 D 7 ... I've tried this in computed columns advanced expression. CASE WHEN first.Project_Name THEN '' END CATX('/',Ref_No,<this variable>) CASE WHEN last.Project_Name THEN Output Based on another similar query. I also need to do this for two more categorical variables.I'm relatively new to coding in SAS in several years. Thanks!
... View more