Beginner Looking for Assistance on Finding Matches Between Datasets

[Subutai]

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.

[PaigeMiller]

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

[Subutai]

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.  

[PaigeMiller · Accepted solution]

PROC SQL can do this.

 A DATA step merge can do this.

[Subutai]

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

[NataljaK]

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