Attempting to JOIN 10 tables, but having trouble Joining 3 and want to know what I am doing incorrectly? the code in RED is what I added (in steps) to add another table, but I get NO data back in the data set. If I leave this out, I get data back. Using: SAS EG Version 7.1 Code is below: PROC SQL outobs=40; CREATE TABLE Funding_Data_Table_001 AS SELECT FA.FINANCIAL_ACCOUNT_NUMBER /*,CT.ROW_WID ,CT.FIRST_NAME ,CT.LAST_NAME ,CT.TIME_ZONE */ ,FA.STATUS ,FA.ROW_WID ,FA.ACCOUNT_NUMBER ,LO.CR_SCOR ,LO.PRCSS_MO ,LO.PRCSS_YR ,LO.DLNQNT_30_59_CN ,LO.DLNQNT_10_29_CN ,LO.DLNQNT_60_89_CN ,LO.DLNQNT_90_CN ,LO.OS_AMT_D ,LO.CUST ,LO.MK ,LO.MDL ,LO.MDL_YR ,LO.MDL_D ,LO.DPD_NB as dys_pymnt_pst_due ,LO.BOOK_DT ,LO.MDL_YR_D ,LO.VIN ,LO.REPO_DT ,LO.CHRGOF_AM ,LO.LN_BAL /* ABOVE AND BELOW, IS THE STATE CODES FROM BOTH TABLES AS A CROSS CHECK */ ,FA.CUSTOMER_STATE_CODE ,LO.CSTMR_ST_CD ,FA.ACCOUNT_NUMBER FROM OBII.FINANCIAL_ACCOUNT FA INNER JOIN OBII.DW_LOAN LO ON FA.ACCOUNT_NUMBER=LO.CUST AND LO.BK = FA.BANK_CODE AND LO.BR = FA.BRANCH_CODE INNER JOIN OBII.CONTACT CT ON FA.ROW_WID = CT.ROW_WID WHERE PRCSS_YR = 2021 AND PRCSS_MO =11 AND BOOK_DT BETWEEN '01JAN2021'D AND '01JUN2021'D; QUIT;
... View more
