https://communities.sas.com/t5/New-SAS-User/can-you-help-me-with-this-code-pls/m-p/780823#M31671 <P>proc sql;<BR />CREATE TABLE QUEST4 AS<BR />SELECT<BR />M.CUST_Id<BR />,R.Region<BR />,F.FinAdvID<BR />,DELINQUENT_2017_DEC.*<BR />from MTG_CUST as M<BR />left join DELINQUENT_2017_DEC as D on M.CUST_Id = D.CUST_Id<BR />left join FINADVMASTER as F on M.Finadvisor = F.FinAdvID<BR />left join REGION as R on F.Province = R.Province;<BR />quit;<BR />proc sql;<BR />create table Quest4ANS as<BR />select<BR />COUNT(DISTINCT(M.CUST_Id))<BR />sum(M.AMT_OF_LOAN)<BR />,Count(F.FinAdvID)<BR />,Count(D.CUST_Id)<BR />from QUEST4<BR />group by region;<BR />quit;</P> Wed, 17 Nov 2021 18:50:57 GMT demolarich 2021-11-17T18:50:57Z https://communities.sas.com/t5/New-SAS-User/can-you-help-me-with-this-code-pls/m-p/780823#M31671 <P>proc sql;<BR />CREATE TABLE QUEST4 AS<BR />SELECT<BR />M.CUST_Id<BR />,R.Region<BR />,F.FinAdvID<BR />,DELINQUENT_2017_DEC.*<BR />from MTG_CUST as M<BR />left join DELINQUENT_2017_DEC as D on M.CUST_Id = D.CUST_Id<BR />left join FINADVMASTER as F on M.Finadvisor = F.FinAdvID<BR />left join REGION as R on F.Province = R.Province;<BR />quit;<BR />proc sql;<BR />create table Quest4ANS as<BR />select<BR />COUNT(DISTINCT(M.CUST_Id))<BR />sum(M.AMT_OF_LOAN)<BR />,Count(F.FinAdvID)<BR />,Count(D.CUST_Id)<BR />from QUEST4<BR />group by region;<BR />quit;</P> Wed, 17 Nov 2021 18:50:57 GMT https://communities.sas.com/t5/New-SAS-User/can-you-help-me-with-this-code-pls/m-p/780823#M31671 demolarich 2021-11-17T18:50:57Z https://communities.sas.com/t5/New-SAS-User/can-you-help-me-with-this-code-pls/m-p/780848#M31672 <P>And what is your question with regards to this code?</P> Wed, 17 Nov 2021 19:45:51 GMT https://communities.sas.com/t5/New-SAS-User/can-you-help-me-with-this-code-pls/m-p/780848#M31672 Kurt_Bremser 2021-11-17T19:45:51Z