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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.