topic Re: Find And Replace within a string in SAS Programming

Find And Replace within a string

CHAN07 — Mon, 31 Jul 2017 21:38:23 GMT

Hello

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

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

Re: Find And Replace within a string

art297 — Mon, 31 Jul 2017 21:52:03 GMT

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

Re: Find And Replace within a string

CHAN07 — Tue, 01 Aug 2017 13:21:12 GMT

Thank you.