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...
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 🙂
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.