Hi there,   I have code the below logic to search the multiple words from the  comments variable(CMMT_X) but its not working properly.   DATA TEST; SET X (obs= 20); Comments= upcase (CMMT_X); X= INDEX(CMMT_X, "DECLINE IN PROPERTY"); /*x1= spedis(CMMT_X, "DECLINE IN PROPERTY");*/ got_value=SCAN(CMMT_X, "DECLINE","PROPERTY"); /**/ /* if index(CMMT_X,'DECLINE IN PROPERTY') or index(CMMT_X,'Decrease in Market Value')then RL_Group= 'Decrease to Security Value'; */ /* else if index(CMMT_X,'Customer Complaint') or index(CMMT_X,'Complaint') then RL_Group= 'Customer Complaint' ;*/ /* else if index(CMMT_X,'Customer Complaint') or index(CMMT_X,'Complaint') then RL_Group= 'Customer Complaint' ;*/ if prxmatch("m/DECLINE IN PROPERTY|Decrease in Market Value|Security Value|security property|Property damaged|Property deteriorated|Valuer Error/oi",CMMT_X) > 0 then found='Decrease to Security Value'; else if prxmatch("m/Customer Complaint|'Complaint/oi",CMMT_X) > 0 then found='Customer Complaint'; else if prxmatch("m/Fraud/oi",CMMT_X) > 0 then found='Fraud'; /* Fraud Internal / Fraud External */ else if prxmatch("m/LMI Claim due|No LMI| Delays with MIP|Non-Fair Wear and Tear / oi",CMMT_X) > 0 then found='LMI Claim Reduction'; else if prxmatch("m/Project Jefferson | Project Storm / oi",CMMT_X) > 0 then found='Project Jefferson'; else if prxmatch("m/Project Alton/ oi",CMMT_X) > 0 then found='Project Alton'; else if prxmatch("m/Process Error|Error / oi",CMMT_X) > 0 then found='Process Error'; /*|Funds credited to incorrect account|LMI maladministration|LMI Premium not paid|Release of security for nil consideration|Lender error - LVR miscalculation|Credit Officer - LVR miscalculation | Other HL funding issue | VLOC Limit not Cancelled |Lender Error - Unacceptable Security | LMI Missing documentation |Credit Officer - unacceptable security|Lender Committed | Loan not Secured at Origination |Missing security documentation |Construction Loan Progress Payments|VLOC Limit not Reduced |Lender error - missing documentation|Lender Error - Maladministration |Credit Officer - Approved Outside Policy/Poor Credit Decision | Poor Credit Maladministration |Lender Error - Maladministration |Missing security documentation | VLOC Limit not Cancelled | Other HL funding issue | Other LMI issue */ else if prxmatch("m/Provision Raised in Error|Provision Raised Error|LMI Claim should be lodged |Provision not required|LMI Claim should be lodged / oi",CMMT_X) > 0 then found='Provision Raised in Error'; else if prxmatch("m/Incomplete Building Loan|Builder/ oi",CMMT_X) > 0 then found='Incomplete Building Loan'; else if prxmatch("m/Uninsured Property|No building insurance|Fire Damage/ oi",CMMT_X) > 0 then found='Uninsured Property'; else if prxmatch("m/Valuation Procedures|Non-System Ordered Valuation|Incorrect Source Document | Incorrect Source Valuation |Incorrect Source|VAS decision not followed|Incorrect VAS input / oi",CMMT_X) > 0 then found='Valuation Procedures'; else found='Miscellaneous'; run;   Is there any other better way to write.Instead of prxmatch is index better?   Appreciate your help.thanks   Regards   ... View more

Hi Guys,   I have got the historic data since Jan 2007 to June2019. Any ideas or suggestions to create a automatic code by creating new flags for New Ins and Outs.   I have hard coded and got numbers  using the below code for 6 months but need to automate it. Any help is much appreciated.   data CM; set POS_CM; where Reals_Status='Total_Possession' and END_OF_MONTH = "30JUN2019"d; run; data LM; set POS_LM; where Reals_Status='Total_Possession' and END_OF_MONTH = "31MAY2019"d; run; proc sql; create table New_in as select * from CM where accno not in (Select accno from LM); quit; proc sql; create table New_Out as select * from LM where accno not in (Select accno from CM); quit;   Please advise.thanks   Regards, RS ... View more