topic Re: Left join - extra rows returned because of multiple matches, need to keep all matched values. in New SAS User

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

accintron — Tue, 13 Aug 2019 15:27:37 GMT

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!

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

Reeza — Tue, 13 Aug 2019 15:34:14 GMT

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

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

accintron — Tue, 13 Aug 2019 15:36:38 GMT

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