topic Re: Get the String from the Right in SAS Programming

Get the String from the Right

iSAS — Tue, 30 Jun 2020 18:03:06 GMT

I have a column with this type of structure:

Last_Name, First_Name Middle_Name 123456789 Company NameX

May I know what function should I use to get the value Company NameX? Thanks

Re: Get the String from the Right

Jagadishkatam — Tue, 30 Jun 2020 18:24:25 GMT

please try below code

data have;
input text&$100.;
cards;
Last_Name, First_Name Middle_Name 123456789 Company NameX
;

data want;
set have;
want=prxchange('s/(.*\d+\s)(\w+)/$2/oi',-1,strip(text));

run;

Re: Get the String from the Right

Jagadishkatam — Tue, 30 Jun 2020 18:26:21 GMT

alternatively with substr

data want;
set have;
want=substr(text,index(text,scan(text,5,'')));

run;

Re: Get the String from the Right

ghosh — Wed, 01 Jul 2020 01:40:10 GMT

namex=scan(text,-1);
  
company=scan(text,-2);

Re: Get the String from the Right

ChrisNZ — Wed, 01 Jul 2020 04:33:05 GMT

To get any value after the last digit:

data WANT;
  STR1='Last_Name, First_Name Middle_Name 123456789 Company NameX';
  STR2=prxchange('s/.*\d //',1,strip(STR1));
run;

Re: Get the String from the Right

Patrick — Wed, 01 Jul 2020 04:53:15 GMT

The scan() function - SCAN(string, count <, character-list <, modifier>>) - with a negative number for the count parameter allows to search a string from the right to the left. A -1 will return the last term (=the first term from the right).

Re: Get the String from the Right

iSAS — Wed, 01 Jul 2020 12:05:11 GMT

Thank you for taking your time to help Patrick. Appreciate it!

I used the scan function but i'm having issue with the delimiter. The delimiter of my data is "3 spaces". Exaample below:

data have;
input text&$100.;
cards;
Last_Name, First_Name Middle_Name 123456789 Company NameX;
data want;
set have;
want=scan(text,1,' ');
run;

My initial plan was to use COMPBL function to remove multiple spaces and have the single space as a delimiter. However, my issue on that was Full Name and Company Names may have spaces and cannot be separated. May I know the turnaround for this?

Re: Get the String from the Right

andreas_lds — Wed, 01 Jul 2020 12:44:38 GMT

Follow-up at https://communities.sas.com/t5/SAS-Programming/How-to-read-delimiter-if-it-s-a-multiple-spaces/m-p/666348

Not sure if i should merge the two messages.