https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856164#M26166 <P>I see. If I am re-writing this through query builder, what type of join will A and B be?&nbsp;</P> Sun, 29 Jan 2023 21:14:53 GMT Vinz867 2023-01-29T21:14:53Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856161#M26164 <P>I have a merge logic and I am trying to understand what kind of join it is doing. Thank you the help!</P><P>&nbsp;</P><P>merge DATA_A(in=a) DATA_B(in=b) data_C(in=c);<BR />by id_loan_syst_gend;<BR />if a and not c;</P> Sun, 29 Jan 2023 21:07:43 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856161#M26164 Vinz867 2023-01-29T21:07:43Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856162#M26165 <P>This is a <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsref/n1i8w2bwu1fn5kn1gpxj18xttbb0.htm" target="_blank" rel="noopener">match-merge</A> of three datasets by the key variable&nbsp;<SPAN>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.</SPAN></P> Sun, 29 Jan 2023 21:09:11 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856162#M26165 SASKiwi 2023-01-29T21:09:11Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856164#M26166 <P>I see. If I am re-writing this through query builder, what type of join will A and B be?&nbsp;</P> Sun, 29 Jan 2023 21:14:53 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856164#M26166 Vinz867 2023-01-29T21:14:53Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856167#M26167 <P>The nearest equivalent in SQL is a LEFT JOIN.</P> Sun, 29 Jan 2023 21:30:24 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-3-Datasets/m-p/856167#M26167 SASKiwi 2023-01-29T21:30:24Z