Solved: Merging multiple datasets by including only ids that match with one of... - SAS Support Communities

☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Pyrite | Level 9

Pyrite | Level 9

Merging multiple datasets by including only ids that match with one of the datasets

Posted 11-14-2022 05:51 PM (820 views)

I want to merge multiple datasets based on matching ids in one them. See image:

1 ACCEPTED SOLUTION

Accepted Solutions

Tourmaline | Level 20

Tourmaline | Level 20

Re: Merging multiple datasets by including only ids that match with one of the datasets

Posted 11-15-2022 04:03 AM (770 views) | In reply to ANKH1

Looks like two left joins to me.

Data never sleeps

View solution in original post

1 REPLY 1

Tourmaline | Level 20

Tourmaline | Level 20

Re: Merging multiple datasets by including only ids that match with one of the datasets

Posted 11-15-2022 04:03 AM (771 views) | In reply to ANKH1

Looks like two left joins to me.

Data never sleeps

April 27 - 30 | GAYLORD TEXAN

SAS Innovate 2026 Registration is Open

Register now to lock in early bird pricing through February 25!

Register Now →