Hi, I have a variable as 'pr_ins_name' and example : FASHION CO (M) BHD AS OWNER, LOOP FASHION CO (M) BHD AS OWNER, LOOP INTER ABC TECHONLOGY SDN BHD AS PRINCIPAL ABD TECHONLOGY SDN BHD AS PRINCIPAL (AS MENTION FLORA LIMITED FLORA LTD XYZ123 SDN BHD ON THE LIFE OF LKC XYZ123 SDN BHD ON THE LIFE OF M CAPTAIN APPAREL AS HIRER AND CONTRACTOR YS ENTERPRISE AS HIRER AND HP DEVELOPMENT I would like to remove those words (in Bold) : 1) contain "AS OWNER" , "AS PRINCIPAL" , "AS HIRER" , "ON THE LIFE OF" , "AS HIRER" 2) replace the "LIMITED" with "LTD" How to combine above into one statement ? data want; set sasuser.name; ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' AS OWNER')) ; ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' AS HIRER')) ; ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' AS PRINCIPAL')) ; ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' ON THE LIFE OF')) ; run; Thank you.
... View more
