delect the PHD and .ph.d from the character

[Smitha9]

I have a dataset,

Sara.Ph.D

Ali PHD

Bran MD

I want remove the .PH.D and PHD and MD

want dataset:

Sara

Ali

Brian

[Reeza]

Use the SCAN() function to extract the characters before the space or period.

FirstName = scan(word, 1, ". ");

[Ksharp]

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;