Hi ,
I want to substring the alphanumeric string
example 00000031700ALLISON S00001
which are of different length. I just need to extract the substring starting with first character that is ALLISON S00001.
so the result of substring from
00000031700ALLISON S00001
is below
ALLISON S00001
Here is one way:
data have; informat string $80.; input string &; want=substr(string,anyalpha(string)); cards; 00000031700ALLISON S00001 ;
Art, CEO, AnalystFinder.com
Here is one way:
data have; informat string $80.; input string &; want=substr(string,anyalpha(string)); cards; 00000031700ALLISON S00001 ;
Art, CEO, AnalystFinder.com
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.
Ready to level-up your skills? Choose your own adventure.