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;
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.
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.
I see. If I am re-writing this through query builder, what type of join will A and B be?
The nearest equivalent in SQL is a LEFT JOIN.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.