scan function

[mmkr]

data test;

string='abc_234_knm_dfjkdhf_dfdkf';

run;

i want ouput like

output_col = knm_dfjkdhf_dfdkf

can some one help on this 

[novinosrin]

output_col =scan(string,-1,'_');

[mmkr]

it wil come only "dfdkf"

[Astounding · Accepted solution]

I would use:

output_col = substr(string, length(scan(string, 1, '_')) + length(scan(string, 2, '_')) + 3);

I'm sure those familiar with parsing functions could find something elegant.

[mmkr]

THANK YOU SO MUCH !!

[Ksharp]

data test;

string='abc_234_knm_dfjkdhf_dfdkf';
x=substr(string,findc(string,'1234567890','b')+1);
put x=;
run;