topic Re: Substring a alphanumeric string starting from first character in the string in SAS Programming

Substring a alphanumeric string starting from first character in the string

sdixit — Mon, 11 Dec 2017 16:44:03 GMT

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

art297 — Mon, 11 Dec 2017 17:00:04 GMT

Here is one way:

data have;
  informat string $80.;
  input string &;
  want=substr(string,anyalpha(string));
  cards;
00000031700ALLISON S00001
;

Art, CEO, AnalystFinder.com

sdixit — Mon, 11 Dec 2017 17:07:47 GMT

Thanks! That works