資料處理-尋找指定欄位中的每筆資料的舊字串，取代成新字串

%macro sql_replace (table_name,col_name,old_String,new_String);

proc sql;

update &table_name

       set &col_name = &new_String

       where &col_name = &old_String ;

quit;

%mend sql_replace;

data a1;

input x1$ x2$ @@;

cards;

aaa  www

bbb www

ccc www

;

%sql_replace(a1,x1,"aaa","bbb");