topic Re: How to extract characters from a string staring from right hand side? in SAS Programming

How to extract characters from a string staring from right hand side?

nismail1976 — Thu, 28 Sep 2017 21:58:36 GMT

Hello everyone,

I have a string variable called part4 that looks something like:

I am trying to extract the first 24 characters starting from right hand side moving toward the left, how can I accomplish that?

Thanks

Re: How to extract characters from a string staring from right hand side?

ChrisNZ — Thu, 28 Sep 2017 23:01:52 GMT

Like this?


EXTRACT=substr(reverse(trim(PART4)),1,24);

Re: How to extract characters from a string staring from right hand side?

ballardw — Thu, 28 Sep 2017 23:03:55 GMT

extract= substr(x, length(x)-24+1);

I did 24 + 1 incase you need to change the 24 based on a variable value.

If you have 10 characters and want 4, 10-4=6, but character positions 6,7,8,9 and 10 = 5 characters, so add 1.

This will not work if you ask for more characters than exist though.

Re: How to extract characters from a string staring from right hand side?

ShiroAmada — Fri, 29 Sep 2017 01:22:47 GMT

Try this....

data want;
  set have;
Latest24months = ifc(length(text)>24,substrn(text,length(text)-23), text);

LATETS24MONTHS_2= ifc(length(text)<=24,TEXT, substrn(text,length(text)-23));

IF LATEST24MONTHS = LATEST24MONTHS_2 THEN TAG=1;
run;

Choose between latest24months or latest24months_2. Tag is used to check if both will provide the same result.

Hope this helps.

Re: How to extract characters from a string staring from right hand side?

PGStats — Fri, 29 Sep 2017 03:51:20 GMT

I think this will always work:

extract= right(subpad(x, max(1, length(x)-24+1), 24));