https://communities.sas.com/t5/New-SAS-User/delect-the-PHD-and-ph-d-from-the-character/m-p/697876#M25450 <PRE>data have; input x $40.; cards; Sara.Ph.D Ali PHD Bran MD ; data want; set have; want=prxchange('s/\b(phd|ph\.d|md)\b//i',-1,x); run;</PRE> Tue, 10 Nov 2020 12:23:34 GMT Ksharp 2020-11-10T12:23:34Z https://communities.sas.com/t5/New-SAS-User/delect-the-PHD-and-ph-d-from-the-character/m-p/697717#M25433 <P>I have a dataset,</P><P>Sara.Ph.D</P><P>Ali PHD</P><P>Bran MD</P><P>&nbsp;</P><P>I want remove the .PH.D and PHD and MD</P><P>want dataset:</P><P>Sara</P><P>Ali</P><P>Brian</P> Mon, 09 Nov 2020 21:05:25 GMT https://communities.sas.com/t5/New-SAS-User/delect-the-PHD-and-ph-d-from-the-character/m-p/697717#M25433 Smitha9 2020-11-09T21:05:25Z https://communities.sas.com/t5/New-SAS-User/delect-the-PHD-and-ph-d-from-the-character/m-p/697721#M25434 Use the SCAN() function to extract the characters before the space or period.<BR /><BR />FirstName = scan(word, 1, ". "); Mon, 09 Nov 2020 21:09:10 GMT https://communities.sas.com/t5/New-SAS-User/delect-the-PHD-and-ph-d-from-the-character/m-p/697721#M25434 Reeza 2020-11-09T21:09:10Z https://communities.sas.com/t5/New-SAS-User/delect-the-PHD-and-ph-d-from-the-character/m-p/697876#M25450 <PRE>data have; input x $40.; cards; Sara.Ph.D Ali PHD Bran MD ; data want; set have; want=prxchange('s/\b(phd|ph\.d|md)\b//i',-1,x); run;</PRE> Tue, 10 Nov 2020 12:23:34 GMT https://communities.sas.com/t5/New-SAS-User/delect-the-PHD-and-ph-d-from-the-character/m-p/697876#M25450 Ksharp 2020-11-10T12:23:34Z