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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.