topic Find text from the right before a modifier in SAS Programming

Find text from the right before a modifier

Solph — Wed, 25 Sep 2019 10:04:14 GMT

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_mean
abc_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

Re: Find text from the right before a modifier

PeterClemmensen — Wed, 25 Sep 2019 09:07:02 GMT

What is your desired result here?

Re: Find text from the right before a modifier

Solph — Wed, 25 Sep 2019 10:04:48 GMT

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

Re: Find text from the right before a modifier

PeterClemmensen — Wed, 25 Sep 2019 10:15:10 GMT

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;

Re: Find text from the right before a modifier

Astounding — Wed, 25 Sep 2019 10:45:55 GMT

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, '_') ;

Re: Find text from the right before a modifier

Solph — Wed, 25 Sep 2019 15:11:53 GMT

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.