Split string out into component words delimited by underscores

[Sharad_Pujari]

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...

[gamotte]

Hello,

You can use the scan function

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

[PeterClemmensen]

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 🙂

[Sharad_Pujari]

yes