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
CFC_SAS_Communities_400x225.jpg
It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.
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.