DATA Step, Macro, Functions and more

Split string out into component words delimited by underscores

Reply
Occasional Contributor
Posts: 11

Split string out into component words delimited by underscores

[ Edited ]

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

Regular Contributor
Posts: 194

Re: base sas scenario

PROC Star
Posts: 551

Re: base sas scenario

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 Smiley Happy

Occasional Contributor
Posts: 11

Re: base sas scenario

yes
Ask a Question
Discussion stats
  • 3 replies
  • 137 views
  • 1 like
  • 3 in conversation