topic Only take last string from multiple strings in SAS Enterprise Guide

Only take last string from multiple strings

scha1996 — Fri, 17 Jul 2020 00:49:41 GMT

Hello

I'm currently in the process of learning SAS using SAS Enterprise Guide and I was wondering if there was a way to extract the last string after a semicolon and space.

For example: Stephanie; Ashley; David

I would like to be able to extract JUST David from this if possible. Please let me know if you need any additional details.

Re: Only take last string from multiple strings

SASKiwi — Fri, 17 Jul 2020 01:15:12 GMT

data _null_;
  string = 'Stephanie; Ashley; David';
  last_word = scan(string, countw(string));
  put _all_;
run;

Re: Only take last string from multiple strings

andreas_lds — Fri, 17 Jul 2020 05:35:21 GMT

The scan function has an option to let it start looking from end of the string onwards. In this case the solution provided by @SASKiwi seems to be easier to understand, but if you need the second last-word, i would use:

data _null_;
  string = 'Stephanie; Ashley; David';
  last_word = scan(string, 2, '; ', 'b');
  put _all_;
run;

Re: Only take last string from multiple strings

scha1996 — Fri, 17 Jul 2020 13:24:21 GMT

Thank you so much! 😊

Re: Only take last string from multiple strings

mkeintz — Fri, 17 Jul 2020 17:12:01 GMT

In fact, you don't even need the 'B' parameter for backward scanning. Any negative number in he second parameter tells sas to scan backwards:

data _null_;
  string = 'Stephanie; Ashley; David';
  last_word=scan(string,-1,';');
  put (_all_) (=);
run;