topic Split string out into component words delimited by underscores in SAS Programming

Split string out into component words delimited by underscores

Sharad_Pujari — Mon, 31 Jul 2017 09:07:26 GMT

i have dataset like

name

john_001_kilber

mathew_josh_007

and i want output like this

f_name num l_name

john 001 kilber

mathew 007 josh

please help me with this...

Re: base sas scenario

gamotte — Mon, 31 Jul 2017 08:36:07 GMT

Hello,

You can use the scan function

http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#p0jshdjy2z9zdzn1h7k90u99lyq6.htm

Re: base sas scenario

PeterClemmensen — Mon, 31 Jul 2017 08:39:08 GMT

Will the data always have this exact structure? So that you have three strings of text separated by two underscores and you want f_name to be the first of the character strings not containing a numbers, num to be the string containing numbers and l_name to be the last string not containing numbers? Am I correct 🙂

Re: base sas scenario

Sharad_Pujari — Mon, 31 Jul 2017 16:06:34 GMT

yes