proc sql; CREATE TABLE QUEST4 AS SELECT M.CUST_Id ,R.Region ,F.FinAdvID ,DELINQUENT_2017_DEC.* from MTG_CUST as M left join DELINQUENT_2017_DEC as D on M.CUST_Id = D.CUST_Id left join FINADVMASTER as F on M.Finadvisor = F.FinAdvID left join REGION as R on F.Province = R.Province; quit; proc sql; create table Quest4ANS as select COUNT(DISTINCT(M.CUST_Id)) sum(M.AMT_OF_LOAN) ,Count(F.FinAdvID) ,Count(D.CUST_Id) from QUEST4 group by region; quit;
... View more
