03-26-2015 05:26 AM
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 ?
03-26-2015 07:11 AM
03-26-2015 07:27 AM
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.. !