I get this error message 53 left join WORK.sic d 54 on a.acctno=d.acctno 55 where prxmatch("m/^.*(35|30)\s*$/",costCenter)=0 2 The SAS System 20:56 Thursday, January 17, 2019 56 57 and a.timeid = "&CM." 58 and a.restructFlg = 'Y' 59 60 61 and a.commitment not in (0) 62 Order by a.commitment desc, a.baltoday desc; ERROR: Function PRXMATCH requires a character expression as argument 2. ERROR: Expression using equals (=) has components that are of different data types. ... View more

It is numeric, The code that I wrote was, proc sql; create table Sample as select distinct b.mktDesc, a.acctno as Loan_Number , a.acctSName , a.balToday, a.commitment, a.TDR, d.SICD , a.PD, a.LGD, a.pastDue, a.user1 , c.offcrname, a.timeid, a.costCenter from everest.loans a left join everest.loanMaster b on a.acctno = b.acctno left join everest.loanOfficer c on a.offcrCde = c.offcrid left join WORK.sic d on a.acctno=d.acctno where a.timeid = "&CM." and a.restructFlg = 'Y' and a.commitment not in (0) Order by a.commitment desc, a.baltoday desc; quit; But now I have too remove loans that have costCenter that ends in 20 or 25. Help me out with this. ... View more

How do u change it to year quarter format please provide an example I prepared a new custom category with quarter format as quarter 1 -20170100, 20170200,20170300.20180100,20180200,29180300 And the other quarters in similar way but then when I press on quarter 1 it shows all the months I want result of only quarter end month that is 20170300or 20180100 as required ... View more