I have 90 files to merge.
is it a good practice to merge them all at once?please advise
%macro mrge;
data abc;
merge ctm_comb.combine_oneperc(in=a)
%do i= 1 %to 9;
source.Complaint_main_%sysfunc(putn(&i,z2.))
flip08.flip_notes_%sysfunc(putn(&i,z2.)) flip08.flip_plan_%sysfunc(putn(&i,z2.))
flip08.flip_contract_%sysfunc(putn(&i,z2.)) flip08.flip_category_%sysfunc(putn(&i,z2.))
flip08.flip_switch_%sysfunc(putn(&i,z2.)) flip08.flip_cms_%sysfunc(putn(&i,z2.))
flip08.flip_ctrcttrk_%sysfunc(putn(&i,z2.)) flip08.flip_stat_%sysfunc(putn(&i,z2.))
flip08.flip_issue_%sysfunc(putn(&i,z2.))
%end;;
by complaint_id;
if a;
run;
%mend mrge;
%mrge;