topic Re: Beginner Looking for Assistance on Finding Matches Between Datasets in SAS Enterprise Guide

Beginner Looking for Assistance on Finding Matches Between Datasets

Subutai — Sun, 25 Jul 2021 16:47:28 GMT

Hello,

I'm trying to find matches from one column in a dataset to another column in a different dataset, using SAS Enterprise Guide 7.1. My plan was to import the two datasets and then perform a series of tasks to find matches. Since I'm a novice using SAS, I am not sure what specific tasks I should be performing and what the flow of the tasks should be to achieve this goal. Any help would be greatly appreciated.

Re: Beginner Looking for Assistance on Finding Matches Between Datasets

PaigeMiller — Sun, 25 Jul 2021 17:20:16 GMT

Can you define "matches"??? Can you give us a little example???

Re: Beginner Looking for Assistance on Finding Matches Between Datasets

Subutai — Sun, 25 Jul 2021 17:29:48 GMT

Sure, when I say "matches" I'm referring to instances where an ID Number from one dataset can also be found in the other dataset.

Re: Beginner Looking for Assistance on Finding Matches Between Datasets

PaigeMiller — Sun, 25 Jul 2021 17:43:43 GMT

PROC SQL can do this.

A DATA step merge can do this.

Re: Beginner Looking for Assistance on Finding Matches Between Datasets

Subutai — Sun, 25 Jul 2021 17:45:18 GMT

Thank you for the assistance, I'll try these out. Sorry if this was an obvious question, I'm still learning.

Re: Beginner Looking for Assistance on Finding Matches Between Datasets

NataljaK — Tue, 03 Aug 2021 07:30:17 GMT

Hi,

The one way is to join two table (Add Tables in Query Builder) by this column using one of the: Left Join, Right Join or Full Outer Join – and putting the fields from both files to new file.
Then you can see where the same fields are in both tables.
Best regards

Natalja