topic exporting several sas tables in a single excel file in SAS Programming

exporting several sas tables in a single excel file

fadel — Thu, 26 Mar 2015 09:26:23 GMT

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 — Thu, 26 Mar 2015 11:11:22 GMT

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 — Thu, 26 Mar 2015 11:27:10 GMT

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