combine three excels in datastep and proc sql

[BrahmanandaRao]

%macro import(file,dname);	
   Proc import datafile="&file" out=&dname
   Dbms=xlsx replace;
   Getnames=yes;
   Run;
%mend;
%import(/home/u35263349/My_Folder/sheet1.xlsx,ds1);
%import(/home/u35263349/My_Folder/sheet2.xlsx,ds2);
%import(/home/u35263349/My_Folder/sheet3.xlsx,ds3);

proc sql;
create table transaction as
select * from ds1
union all
select * from ds2
union all
select * from ds3;
quit;

data master;
set ds1 ds2 ds3;
run;

Hi Guys i want to import these excel files  dynamically and combine three datasets i tried data step and proc sql  please suggest any alternative method using proc sql

[Kurt_Bremser]

To "stack" datasets in SQL, one has to use the UNION clause, which you already have done.

[Patrick]

Your SQL code works with your sample Excels. What's the problem/your question.

In case in your real data the columns in the Excels are not always in the same order: Use  union all CORR