Hello,
I used 4 sql procedures to create 4 tables, and i want to export all this tables in a single excel file but i don't know how !!
is there any thing to merge my 4 table (many colomnes and one row in all of it) before exporting ? if not, how can export it in one excel file ?
If you want to use proc export you can do this way.,
Proc export data= dataset
outfile="location and file name.xlsx"
dbms=xlsx replace; sheet='sheetname';run;
Giving a different sheetname for every new export statement is importnat so it doesnot override the previous one.
repeat this procedure for any number of datasets.. !
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 25. 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.