I have following SAS Code, and need help with PRXCHANGE function. Output of SAS code below is attached in an Excel file. Data A ; Set MisMatch; IF Index(DrugName,'MG') > 0 then do; var2=prxchange("s/[^0-9]//",-1,Drug_Strength); var3=prxchange("s/[^A-Z]//",-1,Drug_Strength); end; run; See the records (in Excel file) # 65,68-70,72-77,87-89. How can I get correct results using PRXCHANGE function? The goal is to match Drug_Strength in a Drugname string. If there is a better way, please let me know. Regards, Girish Patel
... View more