Hi All, New to SAS EG and SQL, so I appreciate your patience and assistance! So far I've been able to find a solution to every hiccup I've encountered in my learning process except this one. What I'm trying to do is combine all the row values of a certain column into a single column/row when three different ID variables are the same. Here's the sample data: Person Provider Date Code John ABC 1/1/2015 12345 John ABC 1/1/2015 34567 John ABC 1/1/2015 45678 John XYZ 1/1/2015 12345 Jane RST 1/1/2015 12345 Jane RST 2/1/2015 45678 Jane RST 2/1/2015 34567 And here's what I'm after: Person Provider Date Combo John ABC 1/1/2015 12345 34567 45678 John XYZ 1/1/2015 12345 Jane RST 1/1/2015 12345 Jane RST 2/1/2015 45678 34567 So, essentially, if the Person/Provider/Date are the same in various rows, then I want to combine all the Codes of those rows into one column so there's only one row for each unique Person/Provider/Date possibility. My original data table has many more possibilities than I've listed above, but I hope this provides a general idea on what I'm trying to accomplish. Any idea on how I can do this via PROC SQL? Or, if it's not possible via PROC SQL (which I've encountered on some other hiccups), any idea on the solution via DATA STEP? Many thanks in advance!
... View more
