Merging 3 Datasets

[Vinz867]

I have a merge logic and I am trying to understand what kind of join it is doing. Thank you the help!

merge DATA_A(in=a) DATA_B(in=b) data_C(in=c);
by id_loan_syst_gend;
if a and not c;

[SASKiwi · Accepted solution]

This is a match-merge of three datasets by the key variable id_loan_syst_gend. Only rows from DATA_A where there is not a match in DATA_C are kept. Have a look at the examples in the link I provided to understand a match-merge.

[Vinz867]

I see. If I am re-writing this through query builder, what type of join will A and B be? 

[SASKiwi]

The nearest equivalent in SQL is a LEFT JOIN.