%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
To "stack" datasets in SQL, one has to use the UNION clause, which you already have done.
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.