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
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
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.