exporting several sas tables in a single excel file

[fadel]

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 ?

[RW9]

Hi,

This question appears on these forums many times.  Please use the search facility, "exporting multiple dataset to excel" gives these as first hits:

[viveklanka]

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.. !