This block of SAS SQL code performs the following actions: 1....

This block of SAS SQL code performs the following actions:

1. Creates a New Table: It creates a new table named edw_mtd_loan_recov_1f_test.

2. Selects Data: It selects all columns (a.*) from the table edw_mtd_loan_recov_1a, while also adding an additional column named comments. The value of this comments column is hardcoded to "NEW LN SEG TM" with a length of 20 characters.

3. Performs Left Joins:

   • It performs a left join between edw_mtd_loan_recov_1a (aliased as a) and edw_mtd_loan_recov_1e (aliased as b) based on the condition that a.ar_id = b.ar_id.
   • Another subsequent left join is performed between edw_mtd_loan_recov_1a and edw_mtd_loan_recov_1c (aliased as c) based on the condition that a.ar_id = c.ar_id.

4. Filters Results:

   • Only rows from edw_mtd_loan_recov_1a are included in the output table where a.ar_id is not equal to b.ar_id and also not equal to c.ar_id. In other words, rows from a are excluded if matches are found in either table b or c on ar_id.

Summary:

The code filters rows from the table edw_mtd_loan_recov_1a that do not have matching ar_id values in edw_mtd_loan_recov_1e and edw_mtd_loan_recov_1c, adding a new column comments with a static value of "NEW LN SEG TM" to the output table edw_mtd_loan_recov_1f_test.