Left join - extra rows returned because of multiple matches, need to keep all matched values.

[accintron]

So I'm aware that left joining (if there's multiple matches from the right table) will result in more rows. What I need help with is how to split that column into multiple variables.

So if my data looks like the following:

adm_id   cb_othr

1             a

1             b 

2             a

3             a 

3             c

I want it instead to look like this:

adm_id   cb_othr_1 cb_othr_2

1             a                b

2             a                

3             a                c

I'm sure it's simple, but I haven't used SAS for a while and not sure where to start. Thanks in advance!

[Reeza · Accepted solution]

PROC TRANSPOSE
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

[accintron]

Thank you! I knew it seemed like something I've done before I just couldnt think of what the heck it was. Much appreciated!