Hello, I make this solution with macro option symbolgen mprint mlogic;
DATA test;
infile cards dsd truncover;
INPUT subject $100. ;
CARDS;
NAME
DYNAMIC COMMERCIAL FINANCE PLC
MTR CORPORATION LIMITED
INTERCEDE GROUP SOCIETE ANONYME
;
run;
%let var_have =LIMITED,SOCIETE ANONYME ;
%let var_change=LTD ,SA ;
%macro test();
data test;
set test;
%let i=1;
%do %while(%length(%scan(%quote(&var_have), &i, %str(,)))>0);
subject=tranwrd(subject, scan("&var_have",&i, ',') , scan("&var_change",&i, ',' ) );
%let i=%eval(&i+1);
%end;
run;
%mend test;
%test;
... View more