topic Re: Extract last digit from a string in SAS Programming

Extract last digit from a string

singhsahab — Sat, 14 Aug 2021 06:36:10 GMT

Hi,

i want to extract all last numeric value from a given string. Datasets are given below with input and output.

data have;
input string $20.;
cards;
P@123kjh2345
r@ty56kli122
ghjgdj788jkjlk23456
;
run;

data want;
input string $20.;
cards;
2345
122
23456
;
run;

Thank you All 🙂

Re: Extract last digit from a string

PeterClemmensen — Sat, 14 Aug 2021 07:18:30 GMT

How about

data have;
input string $20.;
cards;
P@123kjh2345
r@ty56kli122
ghjgdj788jkjlk23456
;
run;

data want(keep = string lastnum);
   set have;
   pid = prxparse('/(\d+)(?!.*\d)/'); 
   if prxmatch(pid, string) then 
      call prxposn(pid, 1, p, l);
   lastnum = substr(string, p, l);
run;

Result:

string               lastnum 
P@123kjh2345         2345 
r@ty56kli122         122 
ghjgdj788jkjlk23456  23456

Re: Extract last digit from a string

FreelanceReinh — Sat, 14 Aug 2021 09:45:22 GMT

Hi @singhsahab,

You can also use the SCAN function to extract the last "word" (second argument -1) of the string, treating all non-digit characters as delimiters (fourth argument 'kd', third argument empty).

data want;
set have;
string=scan(string,-1,,'kd');
run;