Hi there,   I have the following code in SAS D.I studio.   My objective is to run multiple tranwrd statements (only 2 shown out of ~50) against a number of variables within a dataset. (Please note the Tranwrd 'replace' values have just been used for illustrative purposes).   options symbolgen mprint mlogic; data table_x; input first_name :$10. location:$10. junk:$10.; datalines; Rober$t L$ee£ds A£BCD Chris£topher M$£chester A$$BCD Marti$n Y$o£rk ABC£D ; run; %macro bulk(column); data staging_x; set table_x; &column. = tranwrd(&column.,'$','Y'); &column. = tranwrd(&column.,'£','X'); run; proc sql; create table table_y as select * from &syslast.; quit; %mend bulk; %macro run_now; proc contents data = work.table_x; out = work.table_output; quit; proc sql noprint; select distinct NAME into %nrstr(:name1-:name999) from work.table_output; quit; data _null_; %do i=1 %to &sqlobs.; %let Var = &&name&i; %put Var = &Var.; %bulk(&Var.); %end run; ; %mend run_now; %run_now;   The issue I'm having is every time the job completes it appears my Tranwrd statement has only been applied on one variable. For example;   Table_Y   first_name location    junk  Rober$t   LYeeXds    A£BCD      Chris£top MYXchester A$$BCD     Marti$n   YYoXrk     ABC£D     (The Tranwrd statement has been succesfully ran on the location variable).     If I change the code which creates table Y from using a set statment to using a proc append it looks like the results of my tranwrd function are applied to each variable independently but I just can't manage to get the output into a single dataset. All help very much appreciated ... View more