Before doing the join, you can rename the variables you want for each dataset. Here is a macro to add a suffix to selected variables. You can select variables starting with "a" by giving this as argument when calling the macro: vars=a: %macro rename_vars(indata=,outdata=,vars=,suffix=);
proc datasets;
delete &outdata.;
quit;
proc transpose data=&indata.(obs=0) out=names;
var &vars.;
run;
proc sql noprint ;
select catx('=',_name_, cats(_name_,"&suffix."))
into :rename_list separated by ' '
from names
;
quit;
data &outdata.;
set &indata.;
rename &rename_list.;
run;
%mend rename_vars;
%rename_vars(indata=,outdata=,vars=a:,suffix=)
... View more