topic Re: string function in SAS Programming

string function

SASPhile — Tue, 29 Aug 2017 19:00:53 GMT

How to achieve this?

if a varaible has values
finance_data_scores_income.rpt
finace_scores.rpt

the desired output is (to remove _scores_income.rpt and _scores.rpt)
finance_data
finance

Re: string function

Reeza — Tue, 29 Aug 2017 19:05:44 GMT

Are those the only ones or does this need to be generalized?

If only those words, look at TRANWRD() function to replace/remove the text.

Re: string function

Shmuel — Tue, 29 Aug 2017 19:25:33 GMT

There are more than one way to achieve it, assuming that TEXT_IN is the variable which contains the string to check:

1) result = substr(text_in, 1, find(text_in,'_scores'));

2) if text_in = 'finance_data_scores_income.rpt' then result = 'finance_data'; else

if text_in = 'finace_scores.rpt' then result = 'finance';

3) text1 = 'finance_data_scores_income.rpt';

text2 = 'finace_scores.rpt';

length1 = length(text1);

length2 = length(text2);

lengthx = length(text_in);

select (lengthx);

when (length1) result = 'finance_data';

when (length2) result = 'finance';;

end;

Re: string function

novinosrin — Tue, 29 Aug 2017 19:35:53 GMT

data have;

input var $50.;

datalines;

finance_data_scores_income.rpt

finance_scores.rpt

;

data want;

set have;

k= index(var,'_scores.rpt');

if k>0 then substr(var,k)=' ';

else do;

k=index(var,'_scores_income.rpt');

if k>0 then substr(var,k)=' ';

end;

drop k;

run;

Re: string function

SASPhile — Tue, 29 Aug 2017 20:14:04 GMT

the files will have many variations not just limited to scores.rpt or _scores_income.rpt.

Re: string function

Reeza — Tue, 29 Aug 2017 20:16:44 GMT

Then you need to provide a better sample data set that reflects your actual situation.

Re: string function

Ksharp — Wed, 30 Aug 2017 12:57:05 GMT


data have;
input x $40.;
want=prxchange('s/_scores[_a-z]*\.rpt//i',-1,x);
cards;
finance_data_scores_income.rpt
finace_scores.rpt
;
run;

Re: string function

SASPhile — Wed, 30 Aug 2017 15:23:22 GMT

Thanks KSharp, I tried to improvise the code by passing a macro variable in place of _scores instead and it failed:

want=prxchange("s/_&name.[_a-z]*\.rpt//i",-1,x);

ERROR message:

8 ! array charvar
ERROR 200-322: The symbol is not recognized and will be ignored.

Re: string function

Ksharp — Thu, 31 Aug 2017 12:27:49 GMT

You could try this one.

%let name=scores;
data have;
input x $40.;
pid=cats('s/_',"&name",'[_a-z]*\.rpt//i');
want=prxchange(pid,-1,x);
cards;
finance_data_scores_income.rpt
finace_scores.rpt
;
run;