Find And Replace within a string

[CHAN07]

Hello

I have a variable called Degree. It has various values such as:

MD

NP

PA

MD-PHD

MD PHD

PA-C

I want to search within the degree variable and look for space or - and replace it with ;. So basically I want the output like MD;PHD, PA;C. I am using TRANWRD function but it's not working for multiple characters.

Thanks

Chandan Mishra

[art297 · Accepted solution]

I would use the translate function. e.g.:

data have;
  informat degree $20.;
  input degree &;
  cards;
MD
NP
PA
MD-PHD
MD PHD
PA-C
;

data want;
  set have;
  degree=translate(strip(degree),";;"," -");
run;

Art, CEO, AnalystFinder.com

[CHAN07]

Thank you.