Find text from the right before a modifier

[Solph]

Hi,

I tried to find text from the right before a underscore, but the code didn't work. Any help is much appreciated. Thanks.

data one;                                  
input name $1-18;   
cards;
abc_cost_meanabc_visit_meanu
Claim_Visits_Sum
Claim_Cost_all_Sum
;

data two;
   set one;
   name=compress(name);
   length name2 $10;
   CALL SCAN( name, -1, last_pos, last_length);
	name2 = substrn( name, last_pos , last_length);
run; 
                                      
proc print; run;

Edited. Desired results as below, for name (original) and name2 (derived): 

abc_cost_mean mean

abc_visit_meanu meanu

Claim_Visits_Sum Sum

Claim_Cost_all_Sum Sum

[PeterClemmensen]

What is your desired result here?

[Solph]

Thanks for the reminder. Now added in the original post.

[PeterClemmensen]

Do like this

data one;                                  
input name $1-30;   
cards;
abc_cost_meanabc_visit_meanu
Claim_Visits_Sum
Claim_Cost_all_Sum
;

data two;
    set one;
    name2=substr(name, findc(name,'_','b')+1);
run;

[Astounding · Accepted solution]

Your problem title sounds different compared to your description. Based on the description only, you could get the right result simply:

name2 = scan(name, -1, '_') ;

[Solph]

I thought I tried scan(var, -1,"_") and it didn't work. But apparently I used it wrong. Your code works. Thanks a lot. And thanks all for the help.