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!