topic Re: substr with nesting find in SAS Programming

substr with nesting find

JNWong — Sat, 14 Jan 2017 02:49:11 GMT

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!

Re: substr with nesting find

LaurieF — Sat, 14 Jan 2017 03:08:39 GMT

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.

Re: substr with nesting find

JNWong — Sat, 14 Jan 2017 03:29:29 GMT

Good Idea! I have solved my problem.