substr with nesting find

[JNWong]

Hi,

   I would like to subtra a string of characters ,as I have used find function to make position.

   like substr(name,find(name,'in','i'),20),  since i want to substr from right to left.(start from the position that find function have made),

   i have no idea about how to do that with the nesting find).

thank you!

[LaurieF · Accepted solution]

Have you tried the reverse function? It's easier if you set up a reversed value of your name variable. Like this:

 data _null_;
name = "Valerie Adams";
reverse_name = reverse(name);
substring = substr(reverse_name, find(reverse_name, reverse("erie"), 'i'), 7);
put substring=;
run;

This looks for the substring eire (erie, reveresed) in the reversed string, then counts back 7 characters from that point - giving eirelaV. Then you can reverse that to give the answer you want.

[JNWong]

Good Idea! I have solved my problem.