DATA Step, Macro, Functions and more

substr with nesting find

Accepted Solution Solved
Reply
Contributor
Posts: 48
Accepted Solution

substr with nesting find

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!


Accepted Solutions
Solution
‎01-13-2017 10:27 PM
Super Contributor
Posts: 252

Re: substr with nesting find

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.

View solution in original post


All Replies
Solution
‎01-13-2017 10:27 PM
Super Contributor
Posts: 252

Re: substr with nesting find

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.

Contributor
Posts: 48

Re: substr with nesting find

Good Idea! I have solved my problem.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 314 views
  • 0 likes
  • 2 in conversation