%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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: