Get the String from the Right

[iSAS]

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

[Jagadishkatam]

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;

[Jagadishkatam]

alternatively with substr

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

run;

[ghosh]

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

[ChrisNZ]

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;

[Patrick]

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).

[iSAS]

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?

[andreas_lds]

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

Not sure if i should merge the two messages.