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;