Want to append 10 datasets into one dataset using Macro.

[Naveen45]

I have 10datasets of monthly wise data, table names are like IND_UA_012018, IND_UA_022018, IND_UA_032018, IND_UA_042018,....IND_UA_102018.
I want macro code to append all the 10 datasets into one table using a macro

[PaigeMiller]

UNTESTED CODE

%macro dothis;
    %do i=1 %to 10;
		%let monthyear=%sysfunc(mdy(&i,1,2018));
		%let filename=IND_UA_%sysfunc(putn(&monthyear,mmyyn6.));
		proc append base=all new=&filename;
                run;
	%end;
%mend;
%dothis

[Rick_SAS]

If these are the only data sets that start with the prefix IND_UA_ then there is no need to use a macro:

data All;
set IND_UA_: ;
run;

[mkeintz]

And if all those datasets have the same variables and variable attributes, you can add the "open=defer" option to the SET statement.  "open=defer" tells sas to re-use the same input buffer for each incoming data set.  Otherwise a memory buffer is generated for each incoming data set.  We often use this option when concatenating daily data sets over a quarter year.

data All;
set IND_UA_:   open=defer;
run;