how to extract key words from variables

[changxuosu]

thank you so much for your input. it opened my door to the new world of regex, never knew it before!

[Ksharp]

It is depended on your criteria of Keyword.

data have;
input var $50.;
cards;
1545253657356_EI_1_15_CUP_A
1545253657356_EI_1_15_MUG_A
1545265347356_EI_1_15_BOWL_A
1545T432657356_EI_1_15_CUP_B
15452657356_EI_1_15_MUG_B
1545265237356_EI_1_15_BOWL_B
;

data want;
set have;
key=substr(var,findc(var,,'db')+2);
run;

[changxuosu]

it works perfect. thank you so much Ksharp..
What does the modifier 'db' mean? findc(var,,'db')+2 returns the position of the first letter of the last two words (my "key word"). How this is achieved in such a simple function?! it's like magic!

[Ksharp]

modifier 'db' means :

'd'  only search 0-9 number,

'b' search number from RIGHT .

[changxuosu]

wow! that's pretty smart! Learned a lot! Thanks a lot!