topic Re: scan function in SAS Programming

scan function

mmkr — Tue, 24 Apr 2018 16:59:02 GMT

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 — Tue, 24 Apr 2018 17:06:02 GMT

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

mmkr — Tue, 24 Apr 2018 17:10:02 GMT

it wil come only "dfdkf"

Astounding — Tue, 24 Apr 2018 17:12:17 GMT

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 — Tue, 24 Apr 2018 17:14:11 GMT

THANK YOU SO MUCH !!

Ksharp — Wed, 25 Apr 2018 14:04:49 GMT

data test;

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